EBITDA Bridge
Corporate Finance Financial Model (Free Excel Download)
Bridge reported to adjusted EBITDA by isolating one-off items, run-rate synergies, cost savings, and operating adjustments for valuation and transaction analysis.
professionals from Deloitte
Used by professionals from
About this model
An EBITDA bridge translates the year-over-year change in reported EBITDA into a named-driver decomposition that adds up exactly to the headline delta. The workbook lives on a single Assumptions sheet that holds PY and CY values for the operating drivers - units sold, average selling price, variable cost per unit - and the four fixed-cost lines - SG&A, R&D, Other opex, and Restructuring / one-offs. A CY FX factor (PY anchored at 1.000) captures the revenue translation effect, and a tolerance scalar (named range Tolerance) governs the reconciliation check. The default seed has PY units 5,200k and CY units 5,650k, PY price $48.50 and CY price $50.25, PY VC $27.20 and CY VC $27.95, and the four fixed lines stepping up from PY to CY with restructuring growing from $1.2m to $1.85m.
The PL_View sheet sits PY and CY side-by-side from revenue (units × price for PY, units × price × FX for CY) through variable-cost COGS, gross profit, gross margin %, SG&A, R&D, Other opex, Restructuring, EBITDA, and EBITDA %. A dollar-delta column and a percent-delta column flank the data so the bridge bars and the P&L story stay in lockstep. The Bridge_Calc sheet builds four helper anchors (PY CM per unit, PY revenue, PY EBITDA, CY EBITDA) and then the eight driver effects: Volume = (CY units − PY units) × PY CM per unit; Price = (CY price − PY price) × CY units; Variable cost = (PY VC − CY VC) × CY units; SG&A, R&D, Other, Restructuring each compute as PY minus CY so a cost reduction lands as a positive bar; FX = CY units × CY price × (CY FX − 1). The algebra is constructed so the sum of the eight effects equals CY EBITDA − PY EBITDA to the cent.
The Summary sheet is the one-page walk: PY EBITDA → +Volume → +Price → +VC → +SG&A → +R&D → +Other → +Restructuring → +FX → CY EBITDA (bridge), with the walked total compared to CY EBITDA actual on the next row, the residual surfaced to two decimal places, and a status flag that prints 'Reconciles' or 'Off' against the tolerance named range. A final EBITDA delta and EBITDA delta % block closes the sheet. CFOs, FP&A teams, controllers, and investor relations use this template for earnings call commentary (anchor the walk on the eight bars), board EBITDA review (one page that reconciles to the headline number), and underlying-EBITDA scrubbing (flex restructuring inputs to strip one-offs and read the underlying walk).
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the EBITDA Bridge
- Single Assumptions sheet with PY and CY inputs for units, price, variable cost, the four fixed-cost lines, CY FX factor, and tolerance
- PL_View with side-by-side PY vs CY income statement to EBITDA, plus dollar and percent delta columns
- Bridge_Calc with four helper anchors and eight named driver effects
- Summary one-page walk from PY EBITDA to CY EBITDA with reconciliation status flag
- Cost effects signed so positive equals favourable to EBITDA
- Named-range Tolerance scalar governing the "Reconciles" / "Off" check
- Bridge_Calc with helpers and eight driver effects (Volume, Price, Variable Cost, SG&A, R&D, Other Opex, Restructuring, FX)
How the EBITDA Bridge Template Explains Period-to-Period EBITDA Movement
The EBITDA Bridge template decomposes the change in reported EBITDA between two periods into clear operating drivers, M&A effects, and a parallel underlying view. It is designed for CFOs, controllers, and FP&A leads who need to attribute EBITDA movement, separate organic performance from perimeter changes, and reconcile the walked total within a user-set tolerance.
Operating drivers behind the EBITDA walk
The primary bridge decomposes the change in EBITDA from the prior year to the current year across ten drivers: volume, mix, price, variable cost inflation, variable cost productivity, SG&A, R&D, other, restructuring, and FX. Volume is calculated at the aggregate level using the prior-year contribution margin per unit, so it ties directly to the P&L view.
- Price uses the aggregate price change multiplied by current-year units. Variable cost is split into inflation, reflecting input-cost drift at prior-year productivity, and productivity, capturing yield or throughput improvements.
- Cost lines are expressed as prior-year minus current-year so that a reduction in cost appears as a favourable bridge bar. FX captures translation effects on revenue using a ratio form that holds the bridge identity for any non-zero prior-year FX rate.
Calculation flow and scenario toggle
A single scenario toggle on the Assumptions sheet drives eight current-year inputs—units, price, variable cost, variable cost at prior-year productivity, SG&A, R&D, other, and restructuring—via a CHOOSE function across Base, Bull, and Bear columns.
- Three additional toggles control the underlying view label and the inclusion of acquisition and divestiture bars.
- The model carries a five-period P&L from two years prior through the next year, and the bridge calculations layer on top: a shallow historical walk, the primary ten-driver walk with M&A bars, a forward budget walk, and a parallel underlying walk that strips restructuring from both endpoints.
- Every driver is exposed as a named range, so cross-sheet formulas read in plain English.
Outputs and reporting views
The Dashboard presents eight KPI tiles including prior-year and current-year EBITDA, the dollar and percentage change, underlying change percentage, largest favourable and unfavourable drivers, and reconciliation status. It also includes a twelve-row driver-ranking table with conditional formatting and a native Excel waterfall chart that walks from prior-year EBITDA through the drivers to current-year EBITDA.
- The Summary sheet provides a one-page reconciliation walk with the same drivers plus two M&A bars, alongside a parallel underlying walk. It calculates a residual and displays a PASS or FAIL status based on a user-set tolerance, defaulting to one dollar.
- A Sensitivity sheet offers two two-dimensional grids: one showing current-year EBITDA across price and volume changes, and another showing EBITDA margin across FX factor and variable cost inflation scenarios.
Practical use and scope boundaries
This EBITDA bridge is intended for aggregate-company P&L analysis, with an optional four-segment decomposition for volume, mix, and price attribution. It separates organic performance from M&A perimeter changes using acquisition and divestiture toggles, and it provides both reported and underlying views side by side.
- The underlying walk excludes restructuring from both endpoints, so users can see performance without one-off items. Mix is included as a memo bar only, meaning it informs the mix-shift story but is not summed into the bridge total, preserving exact reconciliation.
- The model does not cover capex, working capital, or any items below EBITDA; it is a focused tool for explaining EBITDA movement, not a full three-statement model. All checks are verified under Base, Bull, and Bear scenarios.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is an EBITDA bridge?+
An EBITDA bridge decomposes the year-over-year change in reported EBITDA into named drivers - typically volume, price, variable cost, fixed cost lines, one-offs, and FX - that add up exactly to the headline delta. It is the standard format for explaining earnings movement to a board, audit committee, or the sell-side: each bar names what changed and the bars sum exactly to the EBITDA walk total.
Why are cost effects signed "positive equals favourable"?+
Because the reader is walking a P&L outcome, not a P&L line. A bar labelled "+ SG&A" that reads positive means SG&A fell year-over-year, which lifted EBITDA. Signing every bar so positive equals favourable lets the audience read the walk in one direction without inverting costs in their head.
How does the FX bar work?+
The FX effect is computed as CY units × CY price × (CY FX − 1), which captures the revenue translation impact only. Cost lines stay in domestic currency on the assumption that the entity's cost base does not translate. For a foreign-currency cost base, extend the model with a parallel cost-FX factor and a second FX bar.
Why does the volume bar use PY contribution margin?+
Using PY contribution margin in the volume formula isolates "more units sold at last year's economics" and prevents double-counting with the price and variable-cost bars. If volume used CY contribution margin, every dollar of price increase would land twice - once in price and again in the volume bar - and the bridge would not reconcile.
Can the bridge handle a multi-product mix shift?+
Not at this level of aggregation. This template is single-aggregate: units, price, and variable cost are blended portfolio averages. For a per-SKU Volume / Price / Mix / Cost / FX walk on gross profit, use the gross-margin-bridge template. Pair the two if both the EBITDA walk and the GP mix walk are needed.
Have more financial modelling questions? Contact us
Related templates
Gross Margin Bridge
PY to CY gross profit walk across Volume, Price, Mix, Cost, FX for a 5-SKU portfolio.
Budget vs Actuals Tracker
12-month operating P&L variance tracker with YTD summary.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
M&A Modeling & Valuation
Comprehensive M&A valuation with DCF, comparable companies, and precedent transactions analysis.
