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

Beginner

Client update email for advisory engagement (status, next steps)

Drafts a polished client status update email with progress, blockers, and next steps. Useful for consultants maintaining client confidence and alignment.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Advisory & Consulting

Advanced

DCF 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

Advisory & Consulting

Advanced

Market multiples valuation: peer set screening and adjustments

Creates a peer screening framework and calculates valuation multiples with normalization adjustments. Useful for quick valuation triangulation and fairness work.

GPT-5.2 Thinking; GPT-4.1; o3-mini