Free Excel templates

A free run-rate EBITDA bridge in Excel, from reported to underwritten

One-off items, pro forma acquisitions, cost savings and synergies, each with the amount management claims and the share a buyer accepts, a credit agreement cap and the price of the gap: five sheets, no macros.

Run-rate EBITDA is reported EBITDA plus everything management says the business will earn once the year’s noise is removed: one-off costs added back, acquisitions counted for a full twelve months, savings counted at their full annual rate. The file builds that number for Halden Packaging, a fictional company with $52.0 million of reported LTM EBITDA, presented to buyers as $77.9 million of run-rate EBITDA. A buyer who haircuts each line underwrites $70.1 million. At 10.0x, the difference is $78.3 million of price.

Get the template

The worked case and an empty copy, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Run_Rate_EBITDA_Bridge.xlsx (17 KB) · Run_Rate_EBITDA_Bridge_Blank.xlsx (15 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 blank file has the same formulas and checks with every input cleared: type your own reported EBITDA and adjustments and the bridge fills in.

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

The book behind this model

This file is one worked case from Mergers and Acquisitions. 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 →

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: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Five sheets. Inputs are blue type on a yellow fill and sit on one sheet; everything else is a formula.

Inputs
Reported LTM EBITDA and revenue, the deal multiple and the debt, the cap, and three tables: one-off items, acquisitions closed during the LTM period, and run-rate adjustments. Each line carries the management amount, the share accepted and the reason.
Bridge
Reported, adjusted, pro forma adjusted and run-rate EBITDA in a management column, an underwritten column and the amount not accepted. Pro forma lines add only the months before closing; run-rate lines add only the part of the annual saving not yet in the LTM figure. Below the bridge, the cap a credit agreement puts on run-rate add-backs and the covenant EBITDA that results.
Valuation
Enterprise value and leverage on each EBITDA level at the same multiple and the same debt, the price paid for adjustments the buyer does not accept, and the cost to achieve the savings.
Checks
Four tie-outs on the arithmetic and every figure printed on this page set against the model, with a verdict on each line.

What the worked case returns

MeasureManagementUnderwritten
Reported EBITDA, LTM$52.0m$52.0m
Adjusted EBITDA (after one-off items)$60.1m$58.3m
Pro forma adjusted EBITDA (acquisitions for twelve months)$67.0m$64.5m
Run-rate EBITDA$77.9m$70.1m
Run-rate above reported49.8%34.8%
Enterprise value at 10.0x run-rate$779.0m$700.8m
$280m of senior debt / run-rate EBITDA3.59x4.00x
Covenant EBITDA, run-rate add-backs capped at 15%$77.1m

Read the two columns against each other, not the bottom line alone. 33.2% of management’s run-rate EBITDA is not in reported earnings yet. The buyer accepts every true one-off but refuses the restructuring that has come back three years running, takes the unaudited bolt-on at 75%, and gives the plan that has not started a quarter of its value. Revenue synergies get nothing. Leverage moves the other way: the same $280 million of debt is 3.59x management’s run-rate and 5.38x reported EBITDA. The credit agreement cap, 15% of pro forma adjusted EBITDA, strikes $0.9 million of run-rate add-backs, so covenant EBITDA is $77.1 million.

How to use it on your own numbers

  1. Overwrite reported LTM EBITDA and revenue on Inputs, then the deal multiple and the debt you are testing.
  2. List each add-back on its own line with the amount management claims. Do not net lines together: the haircut is set line by line.
  3. For acquisitions, enter the target’s LTM EBITDA and the months you have owned it. The bridge adds only the missing months.
  4. For run-rate savings, enter the full annual saving and the part already visible in LTM EBITDA. The difference is what you are being asked to pay for.
  5. Set the accepted share on each line, then read Valuation: the price of the gap is the number to negotiate.

Questions people ask about it

What is run-rate EBITDA?

Reported EBITDA for the last twelve months, adjusted to what the business would earn if the year's one-off items were gone, acquisitions had been owned all year and actioned savings had been in place for twelve months. It is a forward-looking number presented as a historical one, which is why each line needs evidence.

How do you calculate run-rate EBITDA?

Start from reported LTM EBITDA. Add back genuine one-off costs. Add the pre-closing months of EBITDA of businesses acquired during the period. Add the part of each annualized saving not yet in the LTM figure. In the worked case: 52.0 + 8.1 + 6.9 + 10.9 = 77.9 million.

What is the difference between adjusted, pro forma and run-rate EBITDA?

Adjusted EBITDA removes one-off items. Pro forma EBITDA also restates for acquisitions or disposals as if they had happened at the start of the period. Run-rate EBITDA goes further and counts savings and synergies at their full annual rate, before they have been earned.

Why haircut the adjustments?

Because a buyer pays a multiple on every dollar of them. Here the 7.8 million of run-rate EBITDA the buyer does not accept is worth 78.3 million at 10.0x. Actioned savings with evidence are accepted at a high share; plans and synergies at a low one; revenue synergies not at all.

Does it use macros or circular references?

No. The file recalculates in Excel, LibreOffice or Google Sheets without iterative calculation.

Can I use it for a real transaction?

You can reuse the structure. 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 Mergers and Acquisitions: the full set adds the seven prices of one deal, the combined accounts under four accretion conventions, the value bridge and the margin ladder. 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 Mergers and Acquisitions. 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.