Blog · Finance metrics and formulas · Finance and FP&A teams
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.