Pro models

LBO Model Excel Template, Pro Edition

An integrated leveraged buyout model in Excel: sources and uses, a seven-year plan, four debt tranches without a circular reference, covenants, a management package and sponsor returns, with 31 built-in checks.

Enter the price, the financing, the plan and the management terms. The workbook builds the sources and uses, projects seven years, runs four debt tranches without a circular reference, tests the covenants, values the exit and splits the proceeds between sponsor and management.

60-second preview, sound off: press play. Watch the full five-minute demo with narration.

LBO Model, Pro Edition: $99

One zip file: the model with a worked example, a blank copy and an 18-page PDF user guide. Single-user license.

Buy now, $99 →

Secure checkout by Stripe. Also in the Pro Models Bundle, $199 for the three Pro models. Want to try the method first? The free LBO model template stays free.

Want to learn to build it yourself? The video course rebuilds this model from a blank sheet, step by step, and includes the Pro model.

Watch the five-minute demo

  1. 0:00 An LBO with no circular reference
  2. 0:25 Inputs: transaction, plan, debt, management
  3. 1:30 Debt schedule: revolver, cash sweep, notes, PIK
  4. 2:20 Covenants and headroom
  5. 2:49 Management package and ratchet
  6. 3:28 Returns, value bridge, scenarios, sensitivity
  7. 4:36 The 31 integrity checks
  8. 4:56 What you receive

The worked example uses a fictitious company. AI-generated voice over real captures of the workbook. Not investment advice.

Dashboard sheet of the LBO Model, Pro Edition: master check, entry and exit, returns and the three scenarios for the worked example
The Dashboard: status, entry and exit, returns, credit headroom and scenarios.

What the model does, tab by tab

The tabs run from inputs to outputs. Blue text on a pale yellow fill marks an input; every other cell is a formula.

Cover
What the model does, the color code, how to use it, the no-circularity design, conventions, limitations, version and license.
Dashboard
Status and master check, entry and exit figures, the value creation bridge, returns, credit headroom, the three scenarios side by side, and two charts: debt by tranche, revenue and EBITDA.
Inputs
Company and timing, entry valuation, three revenue lines, operations and tax, the four tranches, financing fee amortization, equity structure and management package, exit.
Plan
Year-by-year assumptions: growth by line, SG&A and capex as a % of revenue, receivable, inventory and payable days, the base rate curve, covenant levels.
Scenarios
The active scenario selector, and the Base, Downside and Upside shifts to growth, EBITDA margin, base rate and exit multiple.
Transaction
Entry valuation, uses, debt raised, sources, credit statistics at closing, equity structure and management investment.
Operations
Revenue lines, gross profit, EBITDA, the income statement down to net income, tax losses, working capital, capex.
Debt
Cash flow available for debt service, the revolver, the cash sweep, rates, each tranche's schedule, net debt and leverage.
Covenants
Senior net leverage and interest cover each year against their maximum and minimum, headroom, PASS or BREACH, and a holding period summary.
Returns
Exit valuation, the exit waterfall and the ratchet, IRR and MOIC, the value creation bridge, equity cash flows.
Sensitivity
Sponsor IRR and MOIC for 25 combinations of entry and exit multiple around the active case.
Checks
The master check, 31 integrity controls with value, rule, result and purpose, and 4 deal warnings.
Engine
Three full replicas of the calculation sheets, one per scenario, and the 25-column block behind the grid. No inputs.
Debt sheet of the LBO Model, Pro Edition: revolver, Term Loan B with cash sweep, senior notes and PIK notes year by year
The Debt sheet: four tranches, interest on opening balances, the cash sweep.

The worked example

The example is Corvane Industrial Components, a fictitious US maker of engineered components. A sponsor buys it at the end of FY2026 for 9.00x LTM EBITDA of $50.0 million and sells it after five years. Base case, amounts in $ millions:

MeasureValue
Enterprise value at entry450.0 (9.00x EBITDA)
Total debt at closing305.0 (6.10x EBITDA)
Equity check170.6 (35.9% of capitalization)
Equity value at exit, FY2031442.8
Sponsor IRR / MOIC19.9% / 2.48x
Management IRR / MOIC43.8% / 6.14x
Lowest covenant headroom33.4% leverage, 20.6% interest cover
Downside: sponsor IRR / MOIC4.8% / 1.26x
Upside: sponsor IRR / MOIC24.5% / 2.99x

With no multiple expansion assumed, the 272.2 of value created comes from revenue growth and margin (73%) and from deleveraging (36%), net of 25.4 of fees and costs. In the sensitivity grid, half a turn more at entry costs 3.0% of sponsor IRR, while half a turn more at exit adds 1.1%. In the Downside, interest cover in year 1 is 2.01x against a 2.00x minimum: the test passes, barely, which is what a lender would look at first. The example and every figure in it are fictitious and illustrative.

Who it is for

What you receive

Checks sheet of the LBO Model, Pro Edition: the 31 integrity controls and the master check
The Checks sheet: 31 integrity controls, a master check and 4 deal warnings.

Technical notes

Questions people ask about it

Does the LBO model use macros or circular references?

No. Every interest charge is computed on the opening balance of the year, so the debt schedule runs one way: no iterative calculation, no macro, no data table. A built-in control proves that each tranche's interest equals its opening balance times its rate in every year.

Does it work in Google Sheets and LibreOffice?

Yes. It uses standard functions only and was recalculated and verified with LibreOffice. Charts may render slightly differently outside Excel.

How is it different from the free LBO model template?

The free template works one deal from The Buyout Investor. The Pro Edition is a general tool, not tied to any case: it chains the transaction, the operations, four debt tranches, covenants, the management package and the returns, switches between three scenarios and verifies itself with 31 controls. The free template stays free.

What do I receive after purchase?

One zip file with the model and its worked example, a blank copy for your own deal, and an 18-page PDF user guide.

What does the model leave out?

It is an annual model with one tranche of each kind. There is no dividend recapitalization, no add-on acquisition and no interim distribution, and tax is simplified to a single rate with unlimited loss carry-forward. The guide lists every simplification.

Can I use it on a live deal?

Yes, the blank copy is built for that. The license is single-user, the example company is fictitious, and nothing in the model is investment advice.

Get the LBO Model, Pro Edition

$99, single-user license. Download right after checkout. Digital download: no refunds once the file has been downloaded.

Buy now, $99 →

Start free with the free LBO model template, or read The Buyout Investor, the book behind it.

Other Pro models

Learn to build the whole 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 →