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
AdvancedDCF valuation model blueprint with assumptions checklist
Outlines a DCF model structure, key assumptions, and validation checks. Useful for valuation analysts producing defensible valuations for boards, investors, or disputes.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
28
Advisory & Consulting
AdvancedOperating model: unit economics to financial statements
Connects unit economics (volume, pricing, conversion) to full financial statements and cash. Useful for SaaS/e-commerce and growth-stage models.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
25
Advisory & Consulting
BeginnerRetail: Inventory Turnover by Category
Identifies the 'hero' and 'zero' products based on velocity.
GPT-4oGemini 1.5 Pro
0
0
18