Case 84 / 183 Analyst

LBO Debt Schedule

LBO & Private Equity

The prompt

“As a leveraged finance analyst, walk me through how you would build a simplified LBO debt schedule — how do interest expense, mandatory amortization, and a cash sweep interact to pay down the debt balance over the first few years after the deal closes, and how would you avoid the circular reference that a full model would otherwise create?”

📋 What you're given

As a leveraged finance analyst, walk me through how you would build a simplified LBO debt schedule — how do interest expense, mandatory amortization, and a cash sweep interact to pay down the debt balance over the first few years after the deal closes, and how would you avoid the circular reference that a full model would otherwise create?

1. Task Overview

Task: build a 3-year LBO debt schedule that rolls the beginning debt balance forward each year using interest expense, mandatory amortization, and an optional cash sweep.

Step 1: Given Data — Debt Terms and Cash Flow Available for Debt Service

A sponsor's LBO model needs the debt schedule for the first three years after closing.

Line ItemValue
Beginning Total Debt (Year 1)$400.0m
Interest Rate on Debt8.0% (0.08)
Mandatory Amortization (% of original principal, per year)5.0% (0.05)
Cash Flow Available for Debt Service (CFADS) — Year 1$60.0m
Cash Flow Available for Debt Service (CFADS) — Year 2$65.0m
Cash Flow Available for Debt Service (CFADS) — Year 3$70.0m
Cash Sweep Percentage (of cash remaining after interest and mandatory amortization)100% (1.00)

Step 2: Mandatory Amortization

Show Mandatory Amortization Formula

Mandatory Amortization = Original Principal × Mandatory Amortization Rate

Using this formula, compute the mandatory amortization due each year.

Step 3: Interest Expense

Show Interest Expense Formula

Interest Expense = Beginning Debt Balance × Interest Rate

Using this formula, compute the interest expense for each year, using that year's own beginning balance.

Step 4: Cash Available for Optional Sweep

Show Cash Available for Sweep Formula

Cash Available for Sweep = CFADS − Interest Expense − Mandatory Amortization

Using this formula, compute how much cash remains each year to sweep toward additional debt paydown.

Step 5: Ending Debt Balance and Rolling Forward

Show Ending Debt Balance Formula

Ending Debt Balance = Beginning Debt Balance − Mandatory Amortization − Optional Sweep

Assume:

  • Interest is calculated on the beginning-of-year debt balance, not an average balance — this avoids the circular reference a full LBO model would otherwise need to resolve.
  • Mandatory amortization is a fixed 5.0% (0.05) of the original $400.0m principal each year, not a percentage of the declining balance.
  • The optional cash sweep is 100% (1.00) of the cash remaining after interest and mandatory amortization — no cash is held back.

Using these inputs, build the full 3-year debt schedule, where each year's ending balance becomes the next year's beginning balance.

💡 Model answer

Try answering out loud first — then reveal the model answer and compare.

⚠️ Common mistakes

  • Calculating interest on the ending balance or an average balance instead of the beginning balance, which either requires solving a circular reference or silently changes the answer without the candidate realizing it.
  • Forgetting that mandatory amortization is typically fixed as a percentage of the original principal, not a percentage of the declining balance — using the wrong base overstates paydown in later years.
  • Sweeping 100% of CFADS instead of only the cash remaining after interest and mandatory amortization have already been deducted — this double-counts cash that was already used for scheduled debt service.
  • Not rolling the ending balance from one year into the beginning balance of the next year, which breaks the schedule and produces the same interest expense every year.
  • Ignoring the cash sweep entirely and only tracking mandatory amortization — this understates how quickly a well-performing LBO actually delevers.

🔁 Follow-up questions

➡️ Related cases

Previous Case 83: Value Creation Bridge

⭐ Rate this case

0 ratings

💬 Comments (0)

No comments yet — be the first to ask a question.

Part of a 183-case learning path. Create a free account to save progress & unlock follow-up answers.
Create free account