Eight steps, each built on the one before, with the numbers of one worked case: $450.0m of value, $305.0m of debt, a 19.9% sponsor IRR.
An LBO model is built in eight steps, always in the same order: sources and uses, the operating plan, the debt schedule, covenants, exit and returns, the value creation bridge, the management package with scenarios, then sensitivity grids and integrity checks. Each step uses the output of the one before, which is why the order matters more than any single formula.
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 steps below follow one buyout from the first table to the last check. Every figure comes from the same model, so you can rebuild it and compare.
| 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 |
Price on enterprise value (9.0x x $50.0m = $450.0m), deduct debt and add cash to get the equity price ($345.0m), add refinancing, fees and minimum cash. Size the debt in turns of EBITDA (6.10x) and let equity be the plug: $170.63m.
Project each revenue line with its own growth and gross margin, SG&A as a share of revenue, working capital in days, capex and D&A. Year 1: revenue $371.20m, EBITDA $54.26m, cash flow from operations $35.72m. Tax comes after interest, PIK and fee amortization.
Rates, interest on opening balances, mandatory repayments, free cash flow, revolver, then the sweep. Year 1 free cash flow $12.39m; the Term Loan B ends at $194.30m. Interest on opening balances costs about $0.22m of precision in year 1 and removes the circular reference.
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).
Test senior net leverage and interest cover every year and show the headroom. Lowest base case headroom: 20.6% on cover in year 1; 0.3% in the downside.
Exit at 9.0x the exit year's EBITDA, less costs and net debt: $442.78m of equity. Sponsor IRR 19.9%, MOIC 2.48x.
Revenue growth, margin, multiple, net debt and fees must add up to the equity gain, $272.2m, to the cent. Value growth at the entry multiple so nothing is counted twice.
Split the equity into a preferred strip and ordinary shares, compute the envy ratio (5.2x) and a ratchet tested before it applies. Run downside, base and upside as shifts on one plan: 4.8% / 19.9% / 24.5%.
Build the entry x exit grid with plain formulas (center cell 19.9%), then the integrity checks: sources equal uses, roll-forwards, waterfall, bridge, inputs. One master check on the dashboard, read before the IRR.
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).
A paper LBO takes minutes; a full annual model with four tranches, covenants, a management package and scenarios takes a day for an experienced associate.
Inputs, plan, transaction (sources and uses), operations, debt, covenants, returns, scenarios, sensitivity and checks, plus a dashboard.
Annual is the norm for a buy-side model; lenders and some funds add a quarterly version for covenant testing.
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.