Free Excel templates

A free private equity value creation bridge in Excel, with a zero residual

Five years of EBITDA, debt and cash, then entry equity to exit equity in six buckets, the cross-term under three conventions, add-ons net of their cost, leverage, and a gross-to-net initiative reconciliation: eight sheets, no macros.

The file builds the bridge for Vireo Health Services, a fictional platform bought at 9.5 times 14.0 of EBITDA with 4.5 turns of debt: 70.0 of equity. Five years later EBITDA is 24.5, the exit multiple 10.2 and the equity 215.7: 3.08 times the money and a 25.25% IRR. Of the 145.7 created, organic growth is 59.85, or 41%. Deleveraging, which no operating partner performs, is 28.83, nearly 20%. The add-ons look like 28.5 at the entry multiple, but they cost 12.0 in cash, so their net contribution is 16.5: the gross figure overstates them by 73%.

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.

Value_Creation_Bridge.xlsx (25 KB)

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.

The book behind this model

This file is one worked case from The Private Equity Operating Partner. 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 →

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

Eight sheets. Amber cells are inputs; grey cells are computed.

0. Read Me
What the bridge shows and the three things worth knowing.
1. Inputs
The deal in fourteen numbers, and the EBITDA path split into organic, market and acquired.
2. The hold
Five years of EBITDA, interest, capex, tax, cash flow and debt, then exit EBITDA, enterprise value, net debt, equity, MOIC and IRR.
3. The bridge
Six buckets from entry to exit equity, the residual that must be zero, and the add-ons gross and net of their cost.
4. Conventions
The cross-term assigned to growth, to the multiple, or split in proportion, and how far each bucket swings.
5. Leverage
What 3.5x to 6.5x of debt changes in MOIC, IRR and the buckets, and what it does not.
6. Reconciliation
Eighteen months of gross initiative impact against net EBITDA movement, and the gap priced at the entry multiple.
7. Checks
Every figure in the chapter's appendix, tested: all pass.

What the worked case returns

MeasureValue
Entry equity70.0
Exit equity215.73
Money multiple and IRR3.08x, 25.25%
Organic EBITDA growth59.85 (41.1%)
Acquired EBITDA, gross28.50 (19.6%)
Market-driven EBITDA11.40 (7.8%)
Multiple expansion9.80 (6.7%)
Cross-term7.35 (5.0%)
Deleveraging28.83 (19.8%)
Residual0.00

The cross-term is growth times expansion, and it belongs to both buckets and to neither. Assigned to growth, the multiple bucket is 9.80; assigned to the multiple, it is 17.15: a 75% swing on the bucket a buyer discounts most, from a convention nobody has to disclose. The file shows all three conventions side by side.

How to use it on your own deal

  1. Enter your deal on 1. Inputs: entry EBITDA and multiple, leverage, cost of debt, tax, capex, hold, add-ons and the exit multiple.
  2. Split your EBITDA growth into organic, market and acquired.
  3. Check the residual on 3. The bridge: anything but zero means the bridge is not a bridge.
  4. Choose and state a convention for the cross-term on 4. Conventions.
  5. Net the add-ons of their cash cost before presenting them as value created.

Questions people ask about it

Is this value creation bridge template 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. Debt rolls forward year by year from cash flow, and each bucket is a product of EBITDA and multiple changes.

Why does the bridge need a cross-term?

Because enterprise value is EBITDA times a multiple. When both move, the change is growth at the old multiple, plus expansion on the old EBITDA, plus growth times expansion. That last piece is 7.35 here and has no natural owner.

Can I use it for a real portfolio company?

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

The rest of the files

This template is the companion workbook for The Private Equity Operating Partner; the companion page also carries forty self-marking questions on the same material. Free, like this one.

Open the companion files →

Other free templates

This template comes from The Private Equity Operating Partner. 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.