Debt Schedules and the Interest Expense Circularity Problem
Interest expense depends on the debt balance. The debt balance depends on cash available to repay it. Cash available depends on net income, which already has interest subtracted. Here is how debt schedules handle that loop.
What is a debt schedule, and why does it create circularity?
A debt schedule tracks each debt tranche's opening balance, repayments, closing balance, and the interest expense that balance generates. Circularity arises because interest expense depends on the debt balance, while the cash available to repay debt depends on net income, which is already net of interest. Models break the loop by charging interest on the opening balance, or by enabling iterative calculation with a circularity breaker.
Key takeaways
- A debt schedule feeds interest expense into the income statement and the debt balance into the balance sheet.
- The circularity is genuine, not a modeling artifact: interest sets the balance and the balance sets interest.
- Charging interest on the opening balance avoids circularity entirely, at the cost of slight imprecision.
- Using the average balance is more precise but requires iterative calculation plus a circularity breaker switch.
- A cash sweep applies excess free cash flow to prepay debt, usually the most senior or most expensive tranche first.
What is a debt schedule?
- Debt schedule
- A supporting schedule in a financial model that tracks each tranche of debt period by period: opening balance, mandatory amortization, optional prepayments, closing balance, and the resulting interest expense.
A debt schedule tracks each tranche of a company's debt period by period: the beginning balance, any mandatory amortization (scheduled repayment) or optional prepayment, the ending balance, and the interest expense that balance generates. That interest expense then flows into the income statement, which is exactly why the debt schedule sits at the center of any model with meaningful leverage, most visibly an LBO, where the whole return depends on how quickly debt gets paid down.
Why does interest expense create a circular reference?
Interest expense depends on the debt balance outstanding during the period. But the cash available to pay down that debt depends on net income (or free cash flow), which itself depends on interest expense, since interest is a line on the income statement above net income. Interest expense determines the debt balance, and the debt balance determines interest expense: a genuine circular reference within the same period, not just a modeling inconvenience.
How do you break interest expense circularity?
There are two common approaches. The simplest is to calculate interest expense on the beginning-of-period debt balance only, a figure already known before the period's cash flow or ending balance is calculated at all. This avoids circularity entirely, at the cost of slightly understating interest expense in a period where debt is being paid down (since the balance was lower on average than at the start).
Worked example: a company begins the year with $300mm of debt at a 6% rate. Using the beginning-balance convention, interest expense for the year is fixed at $300mm × 6% = $18mm, calculated before anything about the year's cash flow or ending balance is known, which is exactly why this convention has no circularity.
The more precise alternative uses the average of the beginning and ending balance, which is genuinely circular and requires enabling iterative calculation in the modeling tool, plus a “circularity breaker,” a switch cell that can force interest to zero to break the loop if the model ever gets stuck in an error state (a common real-world failure mode when a spreadsheet with circular references gets copied, or a formula gets broken, and the circular calculation stops converging).
| Beginning balance | Average balance | |
|---|---|---|
| Circular? | No | Yes, requires iterative calculation |
| Accuracy while debt is repaid | Slightly overstates interest | More accurate |
| Needs a circularity breaker? | No | Yes, in practice |
| Risk of a broken model | Very low | Can lock into an error state if a formula breaks |
| Typical use | Interview models and quick analyses | Production LBO and leveraged credit models |
What is a cash sweep?
Beyond mandatory amortization, many debt structures require excess free cash flow, cash left over after mandatory obligations, capex, and working capital needs, to be used to prepay debt, most often starting with the most senior or most expensive tranche. This “cash sweep” is standard in LBO structures specifically because paying down debt faster with the company's own cash flow is one of the core drivers of a sponsor's equity return.
Try a real question
This is the same question engine and thirty-second clock a real duel uses, filtered to this guide's topic. No account, no signup, nothing saved.
Common debt schedule interview questions
What causes interest expense circularity in a debt schedule?
Interest expense depends on the debt balance, but the cash available to pay that debt down (which sets the ending, and therefore average, balance) depends on net income, which itself already has interest expense subtracted from it. That two-way dependency within the same period is the circularity.
What is a circularity breaker, and why is it needed?
It's a switch cell, usually a simple toggle, that can force a circular interest calculation to zero, breaking the loop. It's needed because a model with true circular references (using average debt balances) can get stuck in an error or #REF state if a formula changes or the file is copied, and the breaker gives you a way to reset the calculation rather than rebuilding it.
Why use a cash sweep, and what does it prioritize?
A cash sweep directs excess free cash flow toward debt repayment rather than letting it sit as cash, typically prioritizing the most senior or most expensive tranche first. It's central to LBO returns specifically, since faster debt paydown with the company's own cash flow directly grows the sponsor's equity value even if the business itself doesn't grow.
Beginning balance vs. average balance for computing interest: what's the tradeoff?
The average balance is more accurate, since it reflects debt actually being paid down during the period, but it's circular and requires iterative calculation. The beginning balance avoids circularity entirely and is simpler to build, at the cost of slightly overstating the true average balance (and therefore interest expense) whenever debt is being paid down during the period.
What's the difference between mandatory amortization and an optional prepayment?
Mandatory amortization is a scheduled repayment required by the loan agreement regardless of how much cash the company generates. An optional prepayment, including a cash sweep, uses cash beyond what's required, when it's available, to pay down debt faster than the mandatory schedule requires.