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
IntermediateCustomer concentration and churn diligence: risk memo
Analyzes customer concentration, churn, and contract terms to produce a risk memo. Useful for buyers assessing sustainability of revenue and margins.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
58
Advisory & Consulting
IntermediateM&A Teaser (Blind Profile)
A 1-page document sent to potential buyers that keeps the seller anonymous.
GPT-4oGemini 1.5 Pro
0
0
53
Advisory & Consulting
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
44