Articles

LBO modeling test questions, with worked answers

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

The case

The running case: Corvane Industrial Components, Inc. (fictional), $m.
ItemValue
LTM revenue / EBITDA350.0 / 50.0
Entry multiple / enterprise value9.0x / 450.0
Debt at closing (revolver, Term Loan B, senior notes, PIK notes)305.0 (6.10x)
Equity check170.63
Exitend of year 5, 9.0x

1. What does the sponsor pay the sellers for the shares?

Equity value = enterprise value - debt + cash = $450.0m - $120m + $15m = $345.0m. The price is agreed on enterprise value; the sellers receive equity value.

2. How big is the equity check?

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.

3. A deal returns 2.5x in five years. What is the IRR?

2.5^(1/5) - 1 = 20.1%. Anchors worth memorizing for five years: 2.0x is 14.9%, 3.0x is 24.6%.

4. Do the paper LBO for this deal.

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.

5. Why tax income after interest, not EBIT?

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.

6. How do you avoid a circular reference with a cash sweep?

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.

Practice on the full model

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).

Watch lesson 1.1 and try ten quiz questions, free →

7. Walk me through year 1 of the debt schedule.

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.

8. What is covenant headroom?

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. What is the equity value at exit?

9.0x x $72.08m = $648.76m, less $9.73m of exit costs, less net debt of $196.24m (PIK included) = $442.78m.

10. Where does the return come from?

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.

11. What is an envy ratio?

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.

12. Exit in year 3 or year 7?

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.

Sources

  1. Julian R. Sterling, Build an LBO Model in Excel (video course, 2026): running case Corvane Industrial Components
  2. Julian R. Sterling, The Buyout Investor
  3. LBO Model, Pro Edition: user guide and verification report

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.

Build the whole model, step by step

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).

Watch lesson 1.1 and try ten quiz questions, free →

Questions readers ask

How long is an LBO modeling test?

Paper LBOs take 10 to 20 minutes; a full modeling test from a case pack usually takes one to three hours in Excel.

Do I need macros for an LBO modeling test?

No. Interest on opening balances removes the circular reference a cash sweep creates, so no macro or iterative calculation is needed.

What is a good LBO IRR?

Buyout funds typically target about 20% gross on a deal, which is 2.5x in five years (20.1%).

Read the whole case

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.

Also on this site

All 1908 articles →