Debt Schedule Excel Template
Free Excel Financial Model Download
Tranche-by-tranche debt with draws, repayments, interest and balances.
Other examples (78 models)
Used by professionals from
About this debt schedule
A debt schedule models each borrowing tranche, including opening balance, new draws, mandatory repayments, optional repayments, interest expense, commitment fees, and closing balance. It is the financing engine behind interest expense, leverage ratios, cash sweeps, and lender covenant tests.
Use this free Excel debt schedule preview to compare term loan, revolver, amortization, and interest calculation layouts across real financial models. It is useful for LBO models, project finance, acquisition finance, credit analysis, and any forecast with debt-driven cash flow constraints.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Frequently asked
What does the Debt Schedule schedule do?+
A debt schedule models each borrowing tranche, including opening balance, new draws, mandatory repayments, optional repayments, interest expense, commitment fees, and closing balance. It is the financing engine behind interest expense, leverage ratios, cash sweeps, and lender covenant tests.
When should I use a Debt Schedule schedule?+
Use this free Excel debt schedule preview to compare term loan, revolver, amortization, and interest calculation layouts across real financial models. It is useful for LBO models, project finance, acquisition finance, credit analysis, and any forecast with debt-driven cash flow constraints.
What is included on this Debt Schedule schedule page?+
The page includes a live Excel preview, source model examples, sheet-name variants, and related schedules for the debt schedule workflow.
Can I download the workbook behind this Debt Schedule example?+
Yes. Use the download button or open one of the linked source models to download the full Excel workbook that contains this schedule.
Have more financial modelling questions? Contact us
