Articles

How to build an LBO model in Excel, step by step

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.

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. Sources and uses

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.

2. The operating plan

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.

3. The debt schedule

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.

Build it with the video course

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 →

4. Covenants

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.

5. Exit and returns

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.

6. The value creation bridge

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.

7. Management package and scenarios

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

8. Sensitivity grids and checks

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.

Three rules that save hours

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 does it take to build an LBO model?

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.

Which sheets does an LBO model need?

Inputs, plan, transaction (sources and uses), operations, debt, covenants, returns, scenarios, sensitivity and checks, plus a dashboard.

Should an LBO model be annual or quarterly?

Annual is the norm for a buy-side model; lenders and some funds add a quarterly version for covenant testing.

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 →