Advanced
Debt schedule model: amortization, covenants, and waterfalls
Builds a debt schedule including amortization, interest, covenants, and a cash waterfall. Useful for refinancing, restructuring, and lender models.
Design a debt schedule for {company_name}.
Inputs:
- Debt instruments and terms: {debt_terms}
- Interest rate assumptions (fixed/variable): {rate_assumptions}
- Fees and OID: {fees_oid}
- Required amortization and maturities: {amort_maturity}
- Covenant definitions: {covenant_defs}
- Cash flow available for debt service: {cash_flow_for_debt_service}
Output:
1) Debt schedule layout and formulas (begin balance, draws, repayments, interest, end).
2) Cash waterfall order and toggles.
3) Covenant calculation module and reporting table.
4) Stress test scenarios and breach flags.
Avoid assuming missing terms; request them explicitly.Related Prompts
Advisory & Consulting
AdvancedBusiness Combination: Purchase Price Allocation (PPA)
Drafts the technical logic for allocating a purchase price to identifiable assets.
Claude 3.5 SonnetGPT-4o
0
0
77
Advisory & Consulting
IntermediateAudit Strategy & Materiality Planner
Calculates overall and performance materiality based on financial benchmarks and sets the scope for the engagement.
GPT-4oClaude 3.5 Sonnet
0
0
74
Advisory & Consulting
IntermediateModel audit checklist: errors, consistency, and presentation
Creates a model audit checklist to catch formula errors, circularity issues, and presentation problems. Useful for final review before sharing with clients/investors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
95