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
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
144
Advisory & Consulting
IntermediateReal Estate: Fair Value of Investment Properties (IAS 40)
Values commercial real estate holdings based on capitalization rates and net operating income.
GPT-4oClaude 3.5 Sonnet
0
0
135
Advisory & Consulting
AdvancedRestructuring & Turnaround: 13-Week Cash Flow
A critical tool for distressed companies to manage daily liquidity and prioritize payments.
Claude 3.5 SonnetGPT-4o
0
0
171