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
BeginnerRetail: Inventory Turnover by Category
Identifies the 'hero' and 'zero' products based on velocity.
GPT-4oGemini 1.5 Pro
0
0
50
Advisory & Consulting
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
50
Advisory & Consulting
AdvancedNet Working Capital (NWC) Peg Negotiation
Strategic advice for setting the NWC target in a purchase agreement.
Claude 3.5 SonnetGPT-4o
0
0
54