# Debt Schedule

Translate a five-tranche debt stack (revolver, Term Loan A, Term Loan B, senior secured note, mezzanine PIK) into a 60-month per-tranche roll-forward of opening balance, draws, scheduled principal, cash sweep, PIK accrual, and closing balance, plus a panel summary, a TTM covenants sheet with leverage / coverage / DSCR pass-fail, and a dashboard with peak debt, blended rate, total interest paid, average DSCR, weighted-average maturity, and breach counts.

- Canonical: https://finamodel.com/templates/debt-schedule
- Download (.xlsx): https://finamodel.com/templates/debt-schedule.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Investment bankers
- Tags: debt schedule, debt roll-forward, covenants, dscr, leverage

## Related templates

- [Bank Loan Analysis Model](https://finamodel.com/templates/bank-loan)
- [Syndicated Loan Underwriting](https://finamodel.com/templates/syndicated-loan)
- [3 Statement Model](https://finamodel.com/templates/3-statement)