Free Excel templates

A free LBO model template in Excel, with a complete worked deal

Sources and uses, a two-tranche debt schedule, taxes, the three statements, covenants, exit and sponsor returns: twelve linked sheets, one fictional deal, no macros.

The file models one leveraged buyout from signing to exit. A sponsor buys Kestrel for $450 million, 9.0 times $50 million of EBITDA, with a $225 million first-lien term loan, a $50 million second lien and $200 million of equity. Five years later it earns 17.05% on its money and 2.20 times what it put in. Every one of those numbers is a formula you can move.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Kestrel_LBO_Model.xlsx (95 KB) · a copy for Google Sheets

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

Need the full deal structure? The LBO Model, Pro Edition adds four debt tranches, covenants, a management ratchet and 31 checks, with no circular reference and no macros. $99 → · Watch the 60-second preview · Learn to build it: video course

The book behind this model

This file is one worked case from The Buyout Investor. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

Five-minute video demo of the LBO Model, Pro Edition: no circular reference, no macros, 31 checks

LBO Model, Pro Edition: seven-year buyout model with four debt tranches, covenants, a management ratchet, 31 checks, a blank copy and an 18-page guide. $99 → · See what is inside · Watch the 5-minute demo

The Pro Models Bundle: LBO, Development and Fund models, Pro Editions. $199 instead of $327 → · See what is inside

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Twelve sheets, in the order the calculation runs. Inputs are blue type on a yellow fill and sit on one sheet; everything else is a formula.

Assumptions
Every input in one place: price, fees, the two debt tranches and their pricing, the operating plan, the holding period.
Sources_Uses
The price, the refinancing of existing debt, both kinds of fees, the cash left on the balance sheet, and the equity as the balancing item. A line that must read zero proves sources equal uses.
Operating
Revenue to EBITDA year by year.
Debt
Both tranches and the revolver: interest on opening balances, mandatory amortisation, a cash sweep that steps down with net leverage, and a revolver drawn only to hold minimum cash.
Tax
Cash taxes after interest, so the tax shield of the debt is in the numbers rather than assumed.
Cash_Flow and Balance_Sheet
Free cash flow and a balance sheet that balances every year.
Covenants
Leverage and coverage tested against their levels, with the headroom shown.
Exit
Exit value, net debt at exit and the equity bridge.
Returns
Sponsor flows by year, IRR on annual flows and by XIRR on dated flows, the multiple, and where the gain came from.
Checks
Every figure the book prints set against what the model computes, with a verdict on each line.

What the worked deal returns

MeasureValue
Enterprise value at entry$450m (9.0x EBITDA)
Total debt at closing$275m (5.5x EBITDA)
Sponsor equity$190m
Sponsor IRR, annual flows17.05%
Sponsor IRR, XIRR on dates17.04%
Sponsor multiple of money2.20x
Cumulative free cash flow over the hold$88.1m
Cumulative cash interest$126.5m
Net debt paid down$35.3m
EBITDA growth, compounded9.25%

Read the last lines together. Over the hold the company pays $126.5 million of interest and $38.7 million of tax, and still repays $35.3 million of net debt. But the gain in enterprise value is 55.6% of the entry price: most of the return comes from EBITDA growth, not from paying down debt. That is the split an investment committee should ask for, and the Returns sheet prints it.

How to use it on your own deal

  1. Open Assumptions and overwrite the blue cells: EBITDA, entry multiple, fees, the tranche sizes and pricing, the plan.
  2. Look at Sources_Uses first. If the check line is not zero, an input is inconsistent.
  3. Read Covenants before Returns. A deal that breaks its leverage test in year two has no return worth reading.
  4. Change the holding period on Assumptions: Exit and Returns follow it.
  5. Keep the Checks sheet: once you change inputs it stops matching the book, which is expected. Use its structure for your own tie-outs.

Questions people ask about it

Is this LBO model really free?

Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Does it use macros or circular references?

No macros and no circular reference: interest is charged on opening balances, which the model already knows at the start of each year. The file recalculates in Excel, LibreOffice or Google Sheets without iterative calculation.

Why two different IRRs?

Annual flows put every cash flow on a year end. XIRR uses the actual dates. On this deal they give 17.05% and 17.04%; on a deal with interim dividends the gap can matter.

Can I use it for a real transaction?

You can reuse the structure. The deal, the company and every figure in it are fictional, and nothing here is investment advice.

The rest of the files

This template is one of the companion files for The Buyout Investor: the full set adds the deal-to-fund bridge, the returns and sensitivities workbook and the 60-minute test. Free, like this one.

Open the companion files →

Worked questions from the same book

Short articles that each answer one question with the arithmetic shown, on the same ground as this model.

Other free templates

This template comes from The Buyout Investor. The book is on Amazon.

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. The template stays free either way.

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 →