The debt schedule and circular references
By SuperdayReps · Wharton MBA · ex-Greenhill · investment banking interview coaching
6 min read · updated July 2, 2026
The debt schedule is where a model earns its keep. It answers one question every quarter: how much does this company owe, and what does that debt cost? Get it right and your three statements tie. Get it wrong and the balance sheet stops balancing.
It's also where you meet the circular reference, the loop that makes first-time modelers panic. Don't. It's expected, it's manageable, and knowing why it happens is exactly the kind of thing a good interviewer probes.
What a debt schedule actually does
A debt schedule is a small table, one column per period, that rolls each piece of debt from a beginning balance to an ending balance. The template is always the same:
Most companies carry more than one layer. A term loan and senior notes sit on top of a revolving credit facility, and each layer gets its own row. The order matters because cheaper, safer debt gets repaid on its own mandatory schedule, while the flexible piece absorbs whatever cash is left over.
Here is a clean two-tranche year:
| Line | Beginning | Repayment | Ending |
|---|---|---|---|
| Term loan | 500 | (50) | 450 |
| Revolver | 100 | (40) | 60 |
| Total debt | 600 | (90) | 510 |
The term loan pays down 50 on its mandatory amortization schedule no matter what. The revolver moves based on how much cash the business had left after everything else.
Keep reading
The rest of this lesson is free with an account
There's about 4 more minutes of The debt schedule and circular references below this, plus every other lesson in Financial Modeling. Free account, no card.
Any partner school .edu
Frequently asked
- What is a circular reference in a financial model?
- It is an intentional loop where interest expense depends on the debt balance, interest changes net income, net income drives cash, cash determines debt paydown, and paydown resets the debt balance. Excel cannot solve it in one left-to-right pass because the answer feeds back into the input. This designed circularity is real economics, not a bug.
- Why is the revolver called the plug in a debt schedule?
- The revolver is the balancing plug for cash. Each period you calculate cash after mandatory repayments and capex, then draw on the revolver if the company runs short and sweep excess cash to pay it down if flush. It exists so cash never goes negative and the balance sheet always balances.
- How do you handle a circular reference in Excel?
- Two tools tame it. Enable iterative calculation so Excel guesses, plugs the guess back in, and repeats until the number settles. Then build a circuit breaker, one cell that forces interest to zero, so you can cut the loop and flush cascading errors. Charging interest on the beginning balance removes the circularity entirely.
LearnAI