Twelve questions private equity interviewers ask, each answered with numbers on the same buyout: a $450.0m purchase, 6.10x of debt, a 19.9% sponsor IRR.
Private equity interviewers test the same dozen ideas: the equity check, the paper LBO, tax after interest, the debt schedule without a circular reference, covenant headroom, exit equity, the value creation bridge and the management package. Below, each question is answered with numbers on one buyout, so you can check every step.
The case comes from the Build an LBO Model in Excel course by Julian R. Sterling, author of The Buyout Investor.Get the book as a DRM-free PDF, $19.99 →or see it on Amazon
| Item | Value |
|---|---|
| LTM revenue / EBITDA | 350.0 / 50.0 |
| Entry multiple / enterprise value | 9.0x / 450.0 |
| Debt at closing (revolver, Term Loan B, senior notes, PIK notes) | 305.0 (6.10x) |
| Equity check | 170.63 |
| Exit | end of year 5, 9.0x |
Equity value = enterprise value - debt + cash = $450.0m - $120m + $15m = $345.0m. The price is agreed on enterprise value; the sellers receive equity value.
Uses: 345.0 + refinancing 120.0 + fees 15.63 + minimum cash 10.0 = $490.63m. Less debt $305.0m and the $15m of cash acquired: $170.63m, 35.9% of the capital.
2.5^(1/5) - 1 = 20.1%. Anchors worth memorizing for five years: 2.0x is 14.9%, 3.0x is 24.6%.
Exit EBITDA $72.1m x 9.0x = $648.8m. Net debt $295.0m - $115.9m of cash flow after interest + $17.1m of PIK accrued = $196.2m. Equity $452.5m / $170.6m = 2.65x, about 21.5%. The full model gives 2.60x and 21.0% after exit costs.
Interest is the largest tax shield in a leveraged company. Year 1 tax is $4.52m on $18.10m of taxable income; on EBIT it would be $10.78m.
Charge interest on opening balances. The year 1 Term Loan B interest is 7.50% x $200m = $15.00m; on the average balance, solved by iteration, it would be $14.78m. The difference is small and the model never loops.
Sixteen video lessons that build a complete LBO model in Excel on one case, from sources and uses to sponsor returns, with step files, exercises that check your answers, a 160-question quiz and the LBO Model, Pro Edition included ($149).
Cash flow from operations $35.72m, less net cash interest $21.33m, less $2m of amortization = free cash flow $12.39m. Repay the $5m revolver first, then sweep 50% of the rest: $3.70m. The PIK notes grow to $27.75m.
How far EBITDA can fall before a test fails. Year 1 senior net leverage 3.33x against 5.00x: 1 - 3.33 / 5.00 = 33.4%. Interest cover 2.52x against 2.00x: 20.6%. In the downside, cover headroom falls to 0.3%.
9.0x x $72.08m = $648.76m, less $9.73m of exit costs, less net debt of $196.24m (PIK included) = $442.78m.
Revenue growth $138.8m (51%), margin $59.9m (22%), multiple $0.0m, net debt reduction $98.8m (36%), fees -$25.4m. Total $272.2m = exit equity - equity check.
The price per point of ordinary equity paid by the sponsor divided by the price paid by management: ($165.1m / 85%) / ($5.56m / 15%) = 5.24x. Three to seven is common.
Year 3: 21.7% on 1.80x. Year 7: 16.8% on 2.97x. A longer hold raises the multiple and lowers the IRR; the fund's targets decide.
Every figure is computed by script from the course's running case, Corvane Industrial Components, a fictional company, and checked on 17 November 2026. For education, not investment advice.
Sixteen video lessons that build a complete LBO model in Excel on one case, from sources and uses to sponsor returns, with step files, exercises that check your answers, a 160-question quiz and the LBO Model, Pro Edition included ($149).
Paper LBOs take 10 to 20 minutes; a full modeling test from a case pack usually takes one to three hours in Excel.
No. Interest on opening balances removes the circular reference a cash sweep creates, so no macro or iterative calculation is needed.
Buyout funds typically target about 20% gross on a deal, which is 2.5x in five years (20.1%).
This article is one calculation from The Buyout Investor. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.