Skip to main content

Frac CFO

By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 5, 2026

An EBITDA bridge explains why earnings moved from one period to another, one driver at a time. In Excel you build it in two parts: a small table that calculates each driver’s dollar impact and proves the total, then a waterfall chart that draws that table. This guide walks through both, with a worked example you can copy into a blank workbook.

Fraccfo
fraccfo.org
Bring Your EBITDA Bridge Into Focus
Frac CFO builds customized financial models and dashboards around your existing spreadsheets, helping make business performance clearer.

Explore spreadsheet finance support

TL;DR

  • An EBITDA bridge is a table of signed driver impacts that takes starting EBITDA to ending EBITDA, with nothing left unexplained.
  • Typical drivers are volume, price, mix, direct cost, overhead, one-offs and FX. Keep them mutually exclusive.
  • Build the table first, add a check cell that must equal zero, then chart it with Excel’s built-in waterfall and mark the first and last bars as totals.
  • Label the chart in dollars, color increases and decreases differently, and group small movements so it reads at a glance.

Table of Contents

What an EBITDA bridge shows

A bridge starts with EBITDA in one period, adds or subtracts the effect of each business driver, and lands on EBITDA in the next period. The comparison can be last year to this year, or budget to actual. The core rule is simple: ending EBITDA equals starting EBITDA plus the sum of the signed driver impacts, and the drivers must account for the whole change. LegalClarity’s explainer illustrates this with a move from $20 million to $23 million, where the drivers have to add up to exactly $3 million.

That last point is what separates a bridge from a rough chart. If your drivers add up to $60,000 and EBITDA moved $68,000, the bridge is not finished. Glacier Lake Partners makes the same point for plan-to-actual analysis: unexplained residuals mean the analysis is incomplete.

Driver impacts fall $8,000 short of change

Microsoft notes that waterfall charts are also called bridge charts, which is why people search for both terms. They are the same visual.

Set up the workbook

Use three small blocks on one sheet, or on three tabs if your model is larger.

  1. Inputs. For each product or revenue line: units, average price, unit variable cost, for both periods. Below that: fixed overhead and one-off items for both periods.
  2. Bridge table. Two columns: Driver and Impact. First row is starting EBITDA, last row is ending EBITDA, and the rows between are the signed impacts.
  3. Check cell. Starting EBITDA plus the sum of impacts, minus ending EBITDA. It must show 0.

Pull ending EBITDA straight from your income statement, not from the bridge. Then the check cell tests the bridge against your actual books instead of against itself.

If you want the inputs to feed several reports at once, our guide to driver-based budgeting in Excel shows how to keep volume, price and cost assumptions in one place.

Choose the drivers

There is no single correct list. Pick categories that match how your business actually makes money, and make sure no dollar is counted twice. Common choices, per the VCI Institute walkthrough, are volume, price, mix, direct cost, overhead, M&A, one-offs and FX. Glacier Lake Partners lists five core categories for a plan-to-actual bridge: volume, price, mix, cost and non-recurring items, each quantified in dollars with brief commentary.

For a small business, start lean:

  • Volume: you sold more or fewer units.
  • Price: you charged more or less per unit.
  • Mix: the share of higher or lower margin products shifted.
  • Direct cost: materials, freight, merchant fees or subcontractors per unit changed.
  • Overhead: rent, salaries, software and other fixed costs changed.
  • One-offs: a settlement, a grant, a launch cost or other non-recurring item.

Add FX only if you sell or buy in other currencies, and acquisitions only if you actually made one.

Calculate each driver’s impact

The order matters, because each step uses the result of the previous logic. The VCI approach is to measure volume at prior price and cost, then price at prior volume, then mix, direct cost and overhead. The formulas below follow the same pattern. Here they are in plain terms:

Driver Formula What it answers
Volume (Current units − prior units) × prior contribution per unit What if only quantity had changed?
Price (Current price − prior price) × current units What did the price change add?
Mix Change in product share of units × prior contribution per unit Did we sell more of the profitable items?
Direct cost (Current unit cost − prior unit cost) × current units, sign reversed Did costs per unit rise or fall?
Overhead Prior fixed costs − current fixed costs Did fixed spending change?
One-offs Current one-off items − prior one-off items What was non-recurring?

Breaking Into Wall Street gives the same logic for volume in a healthcare example: new patient count minus old count, times the old price per patient. It isolates what happens when quantity changes and price does not.

Two habits keep the formulas clean. Put costs in as positive numbers and flip the sign in the impact formula, so a cost increase shows as a negative impact. And write each formula once, then fill it down, so every product line is treated the same way.

A worked example

The figures below are made up for illustration. Imagine an online retailer whose EBITDA grew from $400,000 last year to $468,000 this year.

Driver Impact
EBITDA, last year $400,000
Volume +$72,000
Price +$45,000
Mix −$8,000
Direct cost (supplier and freight increases) −$34,000
Overhead (two hires, higher software spend) −$22,000
One-off (insurance refund) +$15,000
EBITDA, this year $468,000

Add the impacts: 72,000 + 45,000 − 8,000 − 34,000 − 22,000 + 15,000 = 68,000. Starting EBITDA plus 68,000 is 468,000, so the check cell reads zero.

The story is clear in one read. Growth in units and a price increase did the heavy lifting, rising costs gave back about a third of it, and part of the year’s improvement came from a refund that will not repeat. That last observation is the sort of thing a lender or investor will ask about, so showing one-offs on their own bar saves a conversation.

Reconcile and check the bridge

Before you chart anything, run three checks:

  • The total check: starting EBITDA plus all impacts minus ending EBITDA equals 0.
  • The sign check: every cost increase is negative, every price or volume gain on a profitable item is positive.
  • The overlap check: no expense sits in two drivers. If freight is in direct cost, it cannot also be in overhead.

If the check cell is off, the usual culprits are a product that appears in only one period, a mix calculation that uses the wrong base, or a one-off that is still sitting inside overhead. Fix the cause. Do not add a “misc” row to absorb the difference, because that hides the very thing the bridge is meant to expose.

The same discipline of proving totals before trusting a report applies well beyond finance, for example in a parking data analytics pilot that tests operational numbers before changing pricing.

When the bridge is for budget versus actual, our variance analysis template sheets give you the line-by-line comparison that feeds the driver table.

Build the EBITDA bridge chart in Excel

Modern Excel has a native waterfall chart, and it is the fastest route.

  1. Lay out two columns: Driver and Impact. The first row is starting EBITDA, the middle rows are signed impacts, the last row is ending EBITDA.
  2. Select the range and go to Insert, then Waterfall, as described in Microsoft’s instructions.
  3. Click the first bar once, then click it again so only that bar is selected. Right-click and choose Set as Total. Repeat for the last bar.
  4. Excel now draws the first and last bars from the axis and floats the others, treating positive values as increases and negative values as decreases. ChartKit walks through the same steps.

The bridge table does all the thinking, and the chart just draws it. If the chart looks wrong, the table is almost always the cause.

If your Excel has no waterfall chart

Older versions lack the native option. The workaround, documented by CorpReady, is a stacked column chart with a hidden base series under the visible change bars. You add a helper column for the invisible base, set its fill to none, and plot increases and decreases as separate series. It takes longer and needs more helper cells, but it works in any version.

Format it so it reads at a glance

Default charts are legible but rarely board-ready. A few changes make a large difference:

  • Color: gray for totals, green for increases, red for decreases. The SFA guide recommends exactly this scheme.
  • Gap width: tighten it to 10% or less so the bars sit close together and the flow reads left to right.
  • Labels: show values with signs and a dollar format, such as +$72,000. Narrow bars can push labels outside, so widen the chart or shorten the driver names.
  • Title: include the period and units, such as “EBITDA bridge, last year to this year ($000s)”.
  • Driver count: ChartKit flags too many drivers as a common problem. Group small movements into one category so the chart holds six to eight bars.

Use names your managers already speak. A bar called “Wholesale volume” says more than “Revenue variance 4010”. The SFA view is that a bridge should explain performance without a second explanation, which means KPIs over account codes.

One thing to know: Excel’s native waterfall gives limited control over connectors and annotations, so expect to add text boxes by hand for commentary. A short caption under each major bar, in dollars and one phrase, does more than a paragraph of notes.

What a good EBITDA bridge template contains

Whether you build your own or start from a ready-made file, a template that survives real use has these parts:

  • An input sheet for both periods, with units, prices, unit costs, fixed costs and one-offs.
  • A calculation sheet with one formula per driver, copied down every product or segment.
  • A bridge table with starting EBITDA, impacts and ending EBITDA, linked by formula rather than typed.
  • A check cell that turns red when the difference is not zero.
  • A chart pointed at the bridge table, so it updates when inputs change.
  • A notes column for one line of commentary per driver.

Adapt it by business type:

  • E-commerce: drivers like orders, average order value, product mix, shipping and merchant fees, ad spend.
  • Service firms: billable hours or clients, rate per hour, utilization, contractor cost, overhead.
  • Retail: store traffic, basket size, category mix, shrink, rent.
  • Startups: customer count, price per plan, hosting and support cost, headcount, one-off launch costs.

The structure stays the same. Only the input rows and driver names change. If you want that setup built and tested for you, our Excel templates are designed for businesses that run on spreadsheets, and our EBITDA calculator covers the starting figure.

Perspective: why the spreadsheet is enough

Many owners think an EBITDA bridge needs a dedicated platform. We see it differently. A bridge is a handful of formulas, a clear check and a chart, and Excel or Google Sheets does all three well.

What we see in practice is that the spreadsheet is not the obstacle. The obstacle is unclear inputs: prices in one file, costs in another, and no agreed definition of a driver. When we build finance tools for small and midsize businesses, we start by organizing the numbers you already have, so the bridge, the forecast and the dashboard all draw from one source.

That approach keeps you in control. You can see every formula, change every assumption and explain every bar to a lender, investor or partner without waiting for anyone. That is the clarity we aim for in every project we build.

frac

Make the bridge part of your monthly rhythm

A bridge is most useful when it is routine rather than a one-time exercise. Once your inputs are tidy, refresh them monthly and compare actual to budget, then roll up to a quarterly and annual view. Pair it with a financial dashboard so EBITDA, cash and key ratios sit on one page, and with a revenue forecast so the next period’s bridge is planned before it happens.

If your overhead is allocated across several lines, a clear cost allocation model stops the overhead driver from becoming a debate each month.

Get help building yours

If you would rather not build this from scratch, we can set it up around your numbers. A one-time project gives you a finished model, such as a custom finance project, budget build or KPI dashboard. Our Launch Kit is $650 one-off and you can see what it includes on the Launch Kit page.

Investor Pitch Model Excel Template

For ongoing support, our fractional CFO plans run from Starter at $600 per month or $7,200 per year, to Growth at $1,750 per month or $21,000 per year, and Scale at $3,500 per month or $42,000 per year. Each includes hands-on onboarding and email support, and everything is built in the Excel or Google Sheets you already use. You can also explore the full range on our home page.

FAQ

Can I build an EBITDA bridge in Excel without add-ins?

Yes. Build the driver table with ordinary formulas, then use Insert, then Waterfall, and set the first and last bars as totals. If your version has no native waterfall, a stacked column chart with a hidden base series gives the same result.

How many drivers should an EBITDA bridge have?

Six to eight is a practical range for a small business. Volume, price, mix, direct cost, overhead and one-offs cover most cases. Group smaller items so the chart stays readable.

What if my drivers do not add up to the EBITDA change?

The bridge is incomplete. Check for items counted in two drivers, products missing from one period, and one-offs left inside overhead. Fix the source rather than adding a plug row.

Can I use the same bridge for budget versus actual?

Yes. Replace the prior-period inputs with budget inputs and keep the same formulas. The bridge then explains why actual EBITDA differs from plan.

About the author

Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.

Sources

Leave a Reply