“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?”
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?
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.
A sponsor's LBO model needs the debt schedule for the first three years after closing.
| Line Item | Value |
|---|---|
| Beginning Total Debt (Year 1) | $400.0m |
| Interest Rate on Debt | 8.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) |
Mandatory Amortization = Original Principal × Mandatory Amortization Rate
Using this formula, compute the mandatory amortization due each year.
Interest Expense = Beginning Debt Balance × Interest Rate
Using this formula, compute the interest expense for each year, using that year's own beginning balance.
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.
Ending Debt Balance = Beginning Debt Balance − Mandatory Amortization − Optional Sweep
Assume:
Using these inputs, build the full 3-year debt schedule, where each year's ending balance becomes the next year's beginning balance.
Try answering out loud first — then reveal the model answer and compare.
No comments yet — be the first to ask a question.