Advanced Finance

The Debt Schedule

The sub-schedule that makes a leveraged model behave like a real credit agreement: tranche by tranche, sweep by sweep, with interest computed on balances the schedule itself is changing.

  • Advanced
  • 9 min total
  • 12 chapters

What decision this helps you make: How much debt actually gets repaid in each forecast year, what interest that leaves on the income statement, and where the model breaks if the assumptions are wrong.

What this topic is

The debt schedule is the engine room of a three-statement or LBO model. It rolls every tranche from opening balance through draws, mandatory amortisation, contractual cash sweeps, optional prepayments and any payment-in-kind accretion to a closing balance; computes interest and fee amortisation off those balances; and feeds three numbers back into the model: interest expense to the income statement, financing flows to the cash flow statement, and debt balances to the balance sheet.

Why it matters

In a leveraged structure the debt schedule is where returns are actually made. Deleveraging is the largest single driver in most buyout returns bridges, and it is entirely determined by the interaction of cash generation with the repayment mechanics written into the credit agreement. A model with a flat debt balance and a single blended interest rate is not modelling the deal; it is decorating a spreadsheet.

Who should learn it

Anyone building or reviewing leveraged models: private equity and credit investors, restructuring and M&A advisers, corporate development teams, and CFOs of debt-financed businesses who have to live inside the schedule they signed.

What you will understand

  • The full waterfall from cash flow available for debt service to a closing balance, with worked numbers
  • How mandatory amortisation, excess cash flow sweeps and step-downs actually work in a credit agreement
  • Why interest on average balances creates circularity, and how modellers handle it honestly
  • The accounting details that trip up real schedules: issuance costs, original issue discount, PIK accretion, and modification versus extinguishment

Prerequisites

Common misconception

"The debt schedule is bookkeeping. The interesting work is the operating model." Backwards. In a typical leveraged buyout, the operating case sets how much cash arrives; the debt schedule decides who receives it and in what order, and therefore how much equity value is created. Two identical operating forecasts under two different credit agreements produce materially different equity returns, and the difference lives entirely in this one tab.