# EBITDA Bridge

Bridge the change in reported EBITDA between a prior period and a current period across eight clean drivers, surface each effect on a "positive equals favourable" basis, and reconcile the walked total to the actual EBITDA delta within a user-set tolerance.

- Canonical: https://finamodel.com/templates/ebitda-bridge
- Excel download: https://finamodel.com/templates/ebitda-bridge.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Investors & analysts, CFOs, FP&A teams, Controllers, Investor relations
- Tags: ebitda, bridge, variance, p&l, earnings

## Overview

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's included

- 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
- Single Assumptions sheet with PY and CY inputs for units, price, variable cost, SG&A, R&D, Other opex, Restructuring, CY FX factor, and reconciliation tolerance
- PL_View with side-by-side PY vs CY income statement to EBITDA, dollar deltas, and percent deltas
- Bridge_Calc with helpers and eight driver effects (Volume, Price, Variable Cost, SG&A, R&D, Other Opex, Restructuring, FX)
- Summary one-page walk from PY EBITDA to CY EBITDA with reconciliation check
- All cost effects signed as 'positive = favourable to EBITDA' so the walk reads in one direction
- Tolerance-based status flag ('Reconciles' / 'Off') anchored on a named-range scalar

## 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.

## Built for the earnings narrative

Every CFO, IR lead, and FP&A team faces the same question on earnings day: what moved EBITDA? An eight-driver bridge that reconciles exactly to the actual delta replaces vague commentary with a named-bar walk that adds up.

## Designed for one-edit responsiveness

Every PY and CY input is a single cell. Flex any one driver - units, price, SG&A, restructuring, FX - and the P&L recomputes, the eight effects rebalance, and the Summary reconciliation stays at zero residual.

## Honest about FX and one-offs

FX is applied to revenue only; cost lines stay in domestic currency. Restructuring is its own bar inside reported EBITDA so a reader can see the GAAP walk and mentally add back to get the underlying walk - no parallel bridge needed.

## Built for the earnings narrative

Every CFO, IR lead, and FP&A team faces the same question on earnings day: what moved EBITDA? An eight-driver bridge that reconciles exactly to the actual delta replaces vague commentary with a named-bar walk that adds up.

## Designed for one-edit responsiveness

Every PY and CY input is a single cell. Flex any one driver - units, price, SG&A, restructuring, FX - and the P&L recomputes, the eight effects rebalance, and the Summary reconciliation stays at zero residual.

## Honest about FX and one-offs

FX is applied to revenue only; cost lines stay in domestic currency. Restructuring is its own bar inside reported EBITDA so a reader can see the GAAP walk and mentally add back to get the underlying walk - no parallel bridge needed.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every PY and CY driver in one sheet plus the FX factor and tolerance.

- Units sold, average selling price, variable cost per unit (PY and CY)
- SG&A, R&D, Other opex, Restructuring (PY and CY)
- CY FX factor with PY anchored at 1.000
- Reconciliation tolerance scalar (named range)

### PL_View

Side-by-side PY vs CY income statement to EBITDA with delta and delta % columns.

- Revenue = units × price (PY) and units × price × FX (CY)
- Variable cost COGS, gross profit, gross margin %
- SG&A, R&D, Other opex, Restructuring
- EBITDA and EBITDA % with dollar delta and pp delta

### Bridge_Calc

Helpers and the eight-driver EBITDA decomposition.

- Helpers: PY CM per unit, PY revenue, PY EBITDA, CY EBITDA
- Volume = (CY units − PY units) × PY CM per unit
- Price = (CY price − PY price) × CY units
- Variable cost = (PY VC − CY VC) × CY units (favourable = positive)
- SG&A, R&D, Other, Restructuring each = PY − CY
- FX = CY units × CY price × (CY FX − 1)
- Total effect sum reconciles to CY − PY EBITDA

### Summary

One-page walk from PY EBITDA to CY EBITDA with reconciliation check.

- PY EBITDA → +Volume → +Price → +VC → +SG&A → +R&D → +Other → +Restructuring → +FX → CY EBITDA bridge
- CY EBITDA actual anchored directly from PL_View
- Residual surfaced to two decimal places
- Status flag "Reconciles" / "Off" against named-range Tolerance
- EBITDA delta and EBITDA delta % closing block

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every PY and CY driver in one sheet plus the FX factor and tolerance.

- Units sold, average selling price, variable cost per unit (PY and CY)
- SG&A, R&D, Other opex, Restructuring (PY and CY)
- CY FX factor with PY anchored at 1.000
- Reconciliation tolerance scalar (named range)

### PL_View

Side-by-side PY vs CY income statement to EBITDA with delta and delta % columns.

- Revenue = units × price (PY) and units × price × FX (CY)
- Variable cost COGS, gross profit, gross margin %
- SG&A, R&D, Other opex, Restructuring
- EBITDA and EBITDA % with dollar delta and pp delta

### Bridge_Calc

Helpers and the eight-driver EBITDA decomposition.

- Helpers: PY CM per unit, PY revenue, PY EBITDA, CY EBITDA
- Volume = (CY units − PY units) × PY CM per unit
- Price = (CY price − PY price) × CY units
- Variable cost = (PY VC − CY VC) × CY units (favourable = positive)
- SG&A, R&D, Other, Restructuring each = PY − CY
- FX = CY units × CY price × (CY FX − 1)
- Total effect sum reconciles to CY − PY EBITDA

### Summary

One-page walk from PY EBITDA to CY EBITDA with reconciliation check.

- PY EBITDA → +Volume → +Price → +VC → +SG&A → +R&D → +Other → +Restructuring → +FX → CY EBITDA bridge
- CY EBITDA actual anchored directly from PL_View
- Residual surfaced to two decimal places
- Status flag "Reconciles" / "Off" against named-range Tolerance
- EBITDA delta and EBITDA delta % closing block

## Features

- **Eight-driver decomposition reconciles to zero:** Volume uses PY contribution margin per unit, Price uses CY units, Variable Cost flips sign so a cost drop is favourable, and fixed-cost effects subtract CY from PY. FX is applied to revenue only - cost lines stay in domestic currency. The algebra is constructed so the sum of the eight effects equals CY EBITDA − PY EBITDA exactly.
- **Reported EBITDA, with restructuring visible:** The bridge walks reported EBITDA (restructuring included) but surfaces the restructuring delta as its own bar. A reader can see the GAAP walk and the underlying walk by mentally adding back that bar - no need to maintain two parallel bridges.
- **Tolerance-based check, not a brittle equality:** The reconciliation status compares the absolute residual to a user-set tolerance (default $1) so display rounding never breaks the check while any structural sign error stays loud.

## Use cases

- **Earnings call commentary:** Investor relations and FP&A use the bridge to anchor the prepared remarks on the EBITDA walk: how much of the year-over-year movement came from volume, price, fixed-cost discipline, restructuring add-backs, and FX translation.
- **Board EBITDA review:** A CFO presenting full-year EBITDA to the board uses the one-page Summary as the visual: each driver bar is labelled and the total reconciles exactly to actuals, removing the 'what is in the unexplained' line that haunts most bridges.
- **Underlying-EBITDA scrubbing:** An analyst stripping out non-recurring restructuring from a peer's reported EBITDA can adjust the restructuring inputs and watch the EBITDA delta and the bridge bars recompute, leaving an 'underlying' walk that strips one-offs.

## Frequently asked questions

### 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.

## Related templates

- [Gross Margin Bridge](https://finamodel.com/templates/gross-margin-bridge)
- [Budget vs Actuals Tracker](https://finamodel.com/templates/budget-vs-actuals)
- [3 Statement Model](https://finamodel.com/templates/3-statement-model)