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.
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.
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).
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
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
Measure
Management
Underwritten
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 reported
49.8%
34.8%
Enterprise value at 10.0x run-rate
$779.0m
$700.8m
$280m of senior debt / run-rate EBITDA
3.59x
4.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
Overwrite reported LTM EBITDA and revenue on Inputs, then the deal multiple and the debt you are testing.
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.
For acquisitions, enter the target’s LTM EBITDA and the months you have owned it. The bridge adds only the missing months.
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.
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.
Cash or stock: which should an acquirer pay with?The break-even is the same either way: synergies equal to the premium. What the method of payment changes is who wins above it and who loses below it.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
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.