How to Build an LBO Debt Schedule in a Private Equity Interview (Step-by-Step)

"Walk me through how you'd build a debt schedule" is one of the follow-up questions that almost always shows up after a candidate has already handled the basics of why leverage increases returns in a private equity interview. It's a harder question than it sounds, because you're expected to build a working, multi-year calculation out loud, on paper, or in a bare-bones spreadsheet — without losing track of how each year connects to the next. This walkthrough breaks the exercise into the same five-step sequence a strong candidate would use in the room.

Step 1: Restate the Given Data Before You Touch a Formula

Before calculating anything, lay out exactly what you've been given and what you still need to assume. A typical prompt hands you a beginning debt balance, an interest rate, a mandatory amortization rate, a cash sweep percentage, and either an explicit cash flow figure or enough information to derive one. For example: $400.0m of beginning debt, an 8.0% (0.08) interest rate, 5.0% (0.05) mandatory amortization of the original principal per year, a 100% (1.00) cash sweep, and cash flow available for debt service (CFADS) of $60.0m, $65.0m, and $70.0m across a three-year projection. Saying this out loud first does two things: it confirms you understood the prompt correctly, and it buys you a few seconds to organize the calculation before committing to numbers.

When an Input Is Missing

If any of these inputs are missing — for instance, if you aren't told the mandatory amortization rate — state a reasonable market assumption (1% to 5% is typical for a term loan) explicitly rather than silently picking a number. Interviewers are testing judgment as much as arithmetic.

Step 2: Calculate Mandatory Amortization First

Mandatory amortization is usually the easiest number in the schedule because it's typically fixed as a flat percentage of the original principal, not the declining balance. Using the example above: Mandatory Amortization = $400.0m × 5.0% = $20.0m, and that figure holds constant across all three years. Calculating this first, before interest or the sweep, keeps you anchored to a number you're confident in while you build out the more interdependent parts of the schedule.

Step 3: Calculate Interest Expense on the Beginning Balance

State your convention explicitly: "I'll calculate interest on the beginning-of-year balance rather than an average balance, to avoid a circular reference." This single sentence signals to the interviewer that you understand why more sophisticated models need an iterative solver, and that you're deliberately choosing a simplification appropriate for a verbal or paper exercise — not that you're unaware of the more precise approach.

Year 1 Interest in Numbers

Year 1 interest is then $400.0m × 8.0% = $32.0m. Because you're using the beginning balance, you can calculate every year's interest expense as soon as you know that year's beginning balance, with no need to solve for interest and the ending balance simultaneously.

Step 4: Solve for the Cash Sweep

The cash sweep is where most candidates lose the thread, because it depends on two numbers you've already calculated. The formula is: Cash Available for Sweep = CFADS − Interest Expense − Mandatory Amortization. In Year 1: $60.0m − $32.0m − $20.0m = $8.0m. At a 100% sweep rate, all $8.0m goes toward additional debt paydown; at a lower sweep percentage, say 50%, only half of that — $4.0m — would be applied, with the rest retained as cash.

Narrating the Sweep Out Loud

A useful habit here is narrating the logic, not just the arithmetic: "CFADS is the cash generated before any debt service. Interest and mandatory amortization are the two contractual obligations that come out of it first. Whatever's left is discretionary, and the sweep percentage tells us how much of that discretionary cash goes to additional paydown versus staying on the balance sheet." That framing shows the interviewer you understand the waterfall, not just the subtraction.

Step 5: Roll the Ending Balance Forward and Repeat

Ending Debt Balance = Beginning Debt Balance − Mandatory Amortization − Optional Sweep. For Year 1: $400.0m − $20.0m − $8.0m = $372.0m. This ending balance becomes Year 2's beginning balance, and you repeat Steps 3 and 4 with the new beginning balance and the next year's CFADS figure. Talking through this "roll-forward" step explicitly — rather than jumping straight to a final answer — is what separates candidates who understand the schedule from candidates who memorized a single year's arithmetic.

Carried through three years, the full schedule looks like this:

Reading the Schedule Row by Row

Notice how the interest expense falls each year even though the interest rate never changes — that's a direct consequence of the shrinking beginning balance, and calling that pattern out loud is a good way to demonstrate you understand the mechanics rather than just having executed them correctly. You can practice this exact build, with the full model answer and follow-up questions, in the LBO debt schedule case.

A Verbal Script You Can Adapt

If you're answering this out loud with no paper or spreadsheet, it helps to have a script structure ready rather than improvising the order on the spot: "First, I'll restate the inputs. Second, I'll calculate mandatory amortization, since that's fixed and doesn't depend on anything else. Third, I'll calculate interest on the beginning balance, stating that I'm avoiding the circular reference a full model would need to resolve. Fourth, I'll figure out how much cash is left to sweep after interest and mandatory amortization are covered. Fifth, I'll roll the ending balance into next year's beginning balance and repeat." Reciting this structure — even briefly — before diving into numbers reassures the interviewer that you have a repeatable process, not just a memorized answer to one specific version of the question.

Common Mistakes to Avoid Mid-Answer

• Calculating interest on the ending balance instead of the beginning balance without stating that choice — this either creates an unstated circular reference or quietly changes your answer.
• Applying the mandatory amortization rate to the declining balance instead of the original principal, which understates the (flat) dollar amount owed in later years.
• Sweeping the full CFADS figure instead of only the residual after interest and mandatory amortization — this double-counts cash that's already spoken for.
• Forgetting to roll the ending balance into the next year's beginning balance, which silently produces the same interest expense every year and signals you're not tracking the schedule as a connected sequence.
• Jumping straight to a final multi-year answer without narrating the steps — interviewers are usually grading the process as much as the arithmetic.

How to Handle Follow-Up Twists

Once you've built the base case, interviewers frequently add a twist to see how you adapt. A common one: "What if the sweep were only 50% instead of 100%?" Walk through the same five steps, but apply the lower percentage in Step 4 — you'll retain more cash on the balance sheet and end up with a higher debt balance at the end of the projection period, which is a trade-off worth naming explicitly (more balance-sheet flexibility, slower deleveraging). Another common twist involves multiple debt tranches with different seniority — reviewing how senior, mezzanine, and PIK debt differ in cost and repayment priority will prepare you to extend the same five-step framework to a cash sweep that has to be allocated across tranches in order of seniority rather than applied to a single debt balance.

Twists on the Amortisation Profile

Interviewers may also ask how the debt schedule connects to the rest of the deal: where did the original $400.0m of debt come from, and how do you know the company can actually support it? Those questions point back to the sources and uses table that set the debt amount at close, and to a debt capacity analysis that tests whether the company's cash flow and covenant headroom can support that debt load in the first place. Being ready to connect your debt schedule answer back to those two topics — rather than treating it as an isolated calculation — signals a more complete understanding of the deal.

Why the Result Matters Beyond the Calculation Itself

A good answer doesn't stop at the arithmetic — it connects the ending debt balance back to what the interviewer actually cares about: equity returns. A lower ending debt balance at exit means more of the exit enterprise value flows to equity holders, which is the deleveraging lever inside a value creation bridge analysis. Being able to say, in one sentence, "this schedule shows the company delevering from $400.0m to roughly $293.7m over three years — call out that reduction as part of your equity value build if this were feeding into a full return calculation" demonstrates that you see the debt schedule as a means to an end, not a standalone spreadsheet exercise. It's also a natural bridge into a MoM and IRR calculation, since the ending debt balance is exactly what you'd subtract from exit enterprise value to arrive at exit equity value.

Practicing Under Time Pressure

The biggest difference between a candidate who has practiced this exercise and one who hasn't is speed and composure under the five-step sequence, not knowledge of the formulas themselves. Most candidates can recite "beginning balance minus amortization minus sweep equals ending balance" — the difficulty is doing that three years in a row, out loud, while also tracking a changing interest figure, without losing your place. The most effective way to build that fluency is repetition with slightly different starting numbers each time, so you're not simply memorizing one specific answer. Working through a paper LBO alongside a dedicated debt schedule case is a good combination, since the paper LBO forces you to estimate a simplified debt paydown quickly, while the dedicated case demands the full year-by-year precision described in this walkthrough.

Frequently Asked Questions

Do I need a calculator to answer this in an interview? Ideally you can do it with round numbers and basic percentage math in your head or on paper, but a calculator or spreadsheet is normal for a take-home or modeling-test version of the question. What matters more than the tool is narrating the five-step sequence clearly.

What if I'm not given a cash sweep percentage? State an assumption — 100% is common in simplified exercises since it's the cleanest to calculate, but note explicitly that real credit agreements often specify something lower, and that you're using 100% purely to simplify the walkthrough.

How many years should I project? Three to five years is typical for both interview exercises and real holding periods. Three years is usually enough to demonstrate the roll-forward mechanic clearly without the exercise becoming unwieldy to do by hand.

Is it acceptable to round the numbers? Yes — rounding to the nearest tenth of a million, as shown throughout this walkthrough, is standard practice in a verbal or paper exercise. Precision to the dollar is not what's being tested.

How This Fits Into a Full "Walk Me Through an LBO" Answer

The debt schedule rarely gets asked in total isolation — it's usually one piece of a broader "walk me through an LBO" answer that starts with the purchase price and sources and uses, moves through the operating projections, builds the debt schedule described here, and finishes with an exit valuation and a return calculation. If you're asked the debt schedule question as a standalone follow-up, it's worth briefly locating it in that bigger picture before diving in: "This debt schedule would sit between the initial sources and uses and the exit return calculation — it's what determines how much debt is left to subtract from exit enterprise value." That one sentence of framing costs almost nothing and shows the interviewer you understand how the pieces of a full LBO analysis fit together, rather than treating the debt schedule as an isolated arithmetic drill.

Bringing It Together

Building an LBO debt schedule under interview conditions is really an exercise in sequencing: mandatory amortization first because it's fixed, interest expense second because it only needs the beginning balance, the cash sweep third because it depends on both of the first two, and the roll-forward last to set up the next year. Once that sequence is automatic, the specific numbers an interviewer hands you stop mattering much — you're simply running the same five steps with a different starting balance, rate, or CFADS figure each time. The fastest way to make that sequence automatic is deliberate repetition: work through the schedule once with the numbers given here, then again with your own made-up inputs, until narrating all five steps out loud takes less conscious effort than the arithmetic itself.