What Is a Debt Schedule?
A debt schedule lays out every tranche of a company's borrowings, typically ordered by seniority, and rolls each balance forward period by period. For each tranche, the schedule shows the beginning balance, any mandatory amortization, any optional prepayments funded by excess cash, and the ending balance that carries into the next period.
The schedule also computes interest expense, usually by applying each tranche's rate to the average of its beginning and ending balances. That interest figure feeds back into the income statement, which is why the debt schedule sits at the center of a fully integrated three-statement or LBO model.
How a Debt Schedule Works in a Model
The schedule starts with cash available for debt repayment, typically free cash flow after mandatory amortization. That cash first repays the revolver, then flows to optional prepayment of the term loan through a cash sweep, and only after the sweepable tranches are retired does cash accumulate on the balance sheet. High-yield bonds usually cannot be prepaid early, so their balances stay flat until maturity.
Because interest expense depends on debt balances while debt paydown depends on cash flow after interest, the schedule creates a circular reference. Modelers handle this with iterative calculation enabled in Excel or by using beginning-of-period balances to break the loop, a distinction interviewers frequently probe.
Why It Matters in Practice
In an LBO, debt paydown is one of the primary drivers of equity returns alongside EBITDA growth and multiple expansion. The debt schedule quantifies exactly how quickly the sponsor deleverages, so getting it right determines whether the model's IRR output is credible. A buyout that enters at 6.0x leverage and exits at 3.0x has created substantial equity value purely through the schedule.
Building a clean debt schedule under time pressure is a standard private equity modeling test. Candidates are expected to sequence the revolver draw and repayment logic correctly, apply the cash sweep in order of seniority, and reconcile ending debt balances to the balance sheet without errors.
