Sign in

Blog · Finance metrics and formulas · Finance and FP&A teams

EBITDA margin bridge: explain the change in points

An EBITDA margin bridge explains how revenue mix, direct costs and operating expenses change the company margin. Work two business units through an exact percentage-point reconciliation and reproduce the spreadsheet formulas.

The short answerAn EBITDA margin bridge explains the difference between two periods' EBITDA margins in percentage points. Calculate each business unit's revenue share and EBITDA margin, isolate mix using prior-period margins, then weight direct-cost and overhead-rate changes using current-period revenue shares. The effects must sum to closing margin minus opening margin, with consistent scope, revenue definitions and expense classifications.

An EBITDA margin bridge explains a change in EBITDA divided by revenue as percentage-point effects that add up exactly. Start with comparable P&L exports, separate business-unit mix from direct-cost and overhead rates, and check the closing margin against the accounts.

Define the measure before explaining its movement

Use the same business units, periods, consolidation scope and account mapping in both exports. A shift of payroll from direct cost to overhead should be a classification reconciliation, not an apparent operating improvement. Include central costs and consolidation eliminations somewhere in the rows so the company total is complete.

The EBITDA margin definition owns the underlying metric. This article uses a simplified operating P&L with no nonoperating gains or losses: revenue less direct operating costs and operating overhead, both excluding depreciation and amortization, equals EBITDA. It includes all other operating expenses and no discretionary add-backs.

For external performance reporting, the SEC says EBITDA should reconcile to GAAP net income, rather than treating operating income as the closest GAAP comparator. Keep that reconciliation alongside an internal margin bridge. If the numerator includes further exclusions, use a distinct adjusted EBITDA margin reconciliation.

Assemble the two-period export

An illustrative US industrial services company compares the quarters ended June 30 and September 30, 2026. Dollar figures below are exact; margins and effects are displayed to two decimal places, using unrounded values in calculations.

Business unit Prior revenue (USD) Prior direct costs (USD) Prior overhead (USD) Current revenue (USD) Current direct costs (USD) Current overhead (USD)
Equipment services 1,000,000 600,000 200,000 1,500,000 930,000 255,000
Parts distribution 1,000,000 700,000 150,000 1,000,000 680,000 160,000
Total 2,000,000 1,300,000 350,000 2,500,000 1,610,000 415,000

Subtract both cost columns from revenue within each period:

Business unit Prior EBITDA (USD) Current EBITDA (USD) Prior margin Current margin Prior revenue share Current revenue share
Equipment services 200,000 315,000 20.00% 21.00% 50.00% 60.00%
Parts distribution 150,000 160,000 15.00% 16.00% 50.00% 40.00%
Total 350,000 475,000 17.50% 19.00% 100.00% 100.00%

Current EBITDA is 2,500,000 − 1,610,000 − 415,000 = $475,000. The margin moves from 350,000 / 2,000,000 = 17.50% to 475,000 / 2,500,000 = 19.00%: an increase of 1.50 percentage points.

Separate mix, direct costs and overhead

Let each unit's revenue share be its revenue divided by company revenue. This method changes shares first at old unit margins, then changes cost rates at current shares:

Mix effect = Sum of (Current share − Prior share) × Prior unit margin

Direct-cost effect = Sum of Current share × (Prior direct-cost rate − Current direct-cost rate)

Overhead effect = Sum of Current share × (Prior overhead rate − Current overhead rate)

Multiply each fractional result by 100 to express it in percentage points. Cost rates are the relevant cost divided by that unit's own revenue.

Equipment services' direct-cost rate rises from 60% to 62%, while its overhead rate falls from 20% to 17%. Parts distribution's direct-cost rate falls from 70% to 68%, while overhead rises from 15% to 16%. Every rate follows from the first table.

Unit contribution Mix (points) Direct costs (points) Overhead (points) Total (points)
Equipment services +2.00 −1.20 +1.80 +2.60
Parts distribution −1.50 +0.80 −0.40 −1.10
Company change +0.50 −0.40 +1.40 +1.50

For example, equipment mix is (60% − 50%) × 20% × 100 = +2.00 points. Its direct-cost effect is 60% × (60% − 62%) × 100 = −1.20 points. These are contributions to company margin, not changes in the unit's standalone margin.

The exact check is 17.50 + 0.50 − 0.40 + 1.40 = 19.00%. More revenue from the higher-margin unit helps; overhead absorption helps more; direct-cost rates offset part of the improvement.

Reproduce the bridge in Excel

Place the first table in A:G, units in rows 2:3 and totals in row 4. Add columns H:I for prior and current EBITDA, J:K for their unit margins and L:M for revenue shares:

H2 =B2-C2-D2
I2 =E2-F2-G2
J2 =H2/B2
K2 =I2/E2
L2 =B2/$B$4
M2 =E2/$E$4
N2 =(M2-L2)*J2*100
O2 =M2*(C2/B2-F2/E2)*100
P2 =M2*(D2/B2-G2/E2)*100

Fill down to row 3. Sum B:I in row 4; set J4 to =H4/B4 and K4 to =I4/E4. N:P contain numeric percentage points, so do not format them as percentages. This residual must equal zero:

=K4-J4-SUM(N2:P3)/100

A separate weighted-margin check is =SUMPRODUCT(M2:M3,K2:K3), which must equal K4. Microsoft documents SUMPRODUCT as multiplying corresponding entries and summing the results. Covirage is not affiliated with Microsoft.

Check the denominator and assign the follow-up

An alternative company-level reconciliation makes the denominator explicit. Re-express old EBITDA on current revenue: 350,000 / 2,500,000 = 14.00%, a −3.50-point denominator effect. Revenue growth contributes 500,000 / 2,500,000 × 100 = +20.00 points; higher direct costs contribute −310,000 / 2,500,000 × 100 = −12.40; higher overhead contributes −65,000 / 2,500,000 × 100 = −2.60.

Thus 17.50 − 3.50 + 20.00 − 12.40 − 2.60 = 19.00%. This is another complete bridge, not extra bars to add to the mix bridge. It explains the same result through a different ordering.

FP&A owns the reconciliation. Operations investigates direct-cost rates; business leaders explain revenue composition; functional budget owners explain overhead. Use price volume mix analysis for a deeper revenue explanation when comparable units exist, and EBITDA versus operating income to keep depreciation out of the wrong bridge.

Where it goes wrong

  • Dollar effects called points. Divide by the specified revenue base before labeling a margin contribution.
  • Unit margins averaged equally. Weight them by revenue shares to recover company margin.
  • Changing adjustment policy. A new exclusion can create an apparent gain unrelated to operations.
  • Missing or new units. A unit without prior revenue has no prior margin; show a separate entry effect with an explicit convention.
  • Causal labels without evidence. A lower overhead rate shows absorption; it does not by itself prove greater productivity.

Reconcile your own margin change in Covirage

Upload your two-period P&L file with business-unit mappings and documented adjustments: Covirage maps the columns, and its tools compute and check the margins and reconciling effects. The external AI model explains the results with every figure traced to its rows; create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See FP&A reporting for the supporting reporting context.

Questions people ask

Is margin change measured in percent or percentage points?

Use percentage points when subtracting two margin percentages. A relative percentage change divides that difference by the starting margin and answers a different question. Label bridge bars in points so a reader cannot confuse the two measures.

Can you build an EBITDA margin bridge without units sold?

Yes. Revenue, direct costs and operating expenses by business unit support a mix and expense-rate bridge. They do not establish separate price and physical-volume effects. Those need comparable units and realized prices at a suitable product level.

Does higher EBITDA always mean a higher margin?

No. EBITDA can rise while revenue rises faster, reducing the margin. Check both dollar EBITDA and EBITDA divided by revenue. A margin bridge explains changes in their relationship rather than only the movement in earnings dollars.

Why do two valid bridges allocate different effects?

Bridge methods allocate interactions differently. Holding old margins constant while changing revenue shares assigns the interaction to later rate effects. Another ordering can change individual bars while preserving the total. State the convention and keep it consistent between periods.