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
IntermediateD&O Insurance Adequacy Review
Advises clients on whether their Directors and Officers insurance is sufficient.
GPT-4oClaude 3.5 Sonnet
0
0
34
Advisory & Consulting
AdvancedExpert Witness Report Outline (Forensic)
Structures a formal report for litigation support regarding financial damages.
GPT-4oClaude 3.5 Sonnet
0
0
18
Advisory & Consulting
IntermediateValuation sensitivity table generator (WACC, growth, margins)
Creates a sensitivity matrix and narrative explaining how key assumptions affect value. Useful for boards and audit committees reviewing valuation uncertainty.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
16