Gross Margin Bridge
Corporate Finance Financial Model (Free Excel Download)
Bridge gross margin changes through price, volume, mix, product costs, freight, and foreign-exchange effects to explain profitability movement between periods.
professionals from Deloitte
Used by professionals from
About this model
A gross margin bridge decomposes the year-over-year change in gross profit (GP) into five clean drivers - Volume, Price, Mix, Cost, and FX - across a five-SKU portfolio (Premium, Standard, Economy, Service, Bundle). The workbook is organised as Assumptions, Period_View, Bridge_Calc, and Summary, with every effect formula sized on a SKU-by-SKU basis and a portfolio total that reconciles PY GP to CY GP to the cent through a tolerance-based check.
The Assumptions sheet holds per-SKU inputs for PY and CY: units, price per unit, cost per unit, plus a CY FX translation factor for revenue. The Period_View sheet computes PY and CY revenue, COGS, gross profit, and gross margin % by SKU, applies the FX factor to CY revenue, and sums to a portfolio total column. The Bridge_Calc sheet computes a portfolio PY average gross profit per unit as the helper for the standard volume / mix split, then derives five effects per SKU: Volume = (CY_units − PY_units) × portfolio PY avg GP per unit, Price = (CY_price − PY_price) × CY_units, Mix = (CY_units − PY_units) × (SKU PY GP per unit − portfolio PY avg), Cost = (PY_cost − CY_cost) × CY_units, and FX = CY_units × CY_price × (CY_FX − 1).
The Summary sheet walks PY GP through the five drivers in order to a bridge total, anchors that against CY GP actual from Period_View, and prints a residual along with a check status that fires "Reconciles" when the absolute residual is within the user-set tolerance (default $1). CFOs, FP&A leaders, controllers, and divisional finance teams use this template for quarterly earnings walks, board packs, and 10-K MD&A narrative - flexing CY units, price, cost, and FX factor by SKU and watching the bridge reconcile in real time.
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 Gross Margin Bridge
- Per-SKU PY and CY assumptions: units, price, cost, plus a CY FX translation factor
- Period_View with PY and CY revenue, COGS, gross profit, and gross margin % by SKU
- Bridge_Calc with Volume, Price, Mix, Cost, FX effects by SKU and portfolio
- Standard volume / mix split using the portfolio PY average gross profit per unit
- Summary walk from PY GP to CY GP with a tolerance-based reconciliation check
- Seed data for five SKUs (Premium, Standard, Economy, Service, Bundle) so the report works out of the box
Gross Margin Bridge: How the Model Works
A gross margin bridge explains the year-over-year change in gross profit by isolating the impact of volume, price, mix, cost, and FX. This template provides a structured framework across a twelve-SKU portfolio, helping CFOs and FP&A teams present a clear reconciliation from prior-year to current-year gross profit.
Operating Drivers Behind the Bridge
The model decomposes the change in gross profit into six drivers: volume, price, mix, cost, FX price, and FX cost. Volume reflects the effect of selling more or fewer units, holding the prior-year product mix constant.
- Price captures the impact of changes in selling prices. Mix measures how shifts in the relative sales of higher- versus lower-margin SKUs affect gross profit.
- Cost reflects changes in unit costs, positively when costs fall. FX price and FX cost isolate currency translation effects on revenue and costs, allowing separate treatment when they differ.
Calculation Flow and Conventions
The bridge follows a standard convention where price and cost effects are calculated using current-year units, which cleanly allocates cross-effects and avoids residual amounts. Volume and mix are based on the portfolio's prior-year average gross profit per unit, with mix capturing the difference between SKU-level and portfolio averages.
- This ensures that the sum of volume and mix effects equals the total unit change multiplied by each SKU's prior-year gross profit per unit. FX effects are split into price and cost components, each formula adjusting for the change in translation rates.
- The result is a decomposition that exactly reconciles to the total gross profit change within a defined tolerance.
Outputs and Reporting Views
The model produces three key outputs: a side-by-side period view showing prior-year and current-year P&L by SKU, a detailed bridge calculation sheet with per-SKU driver effects and channel rollups, and a one-page summary waterfall that walks from prior-year gross profit to current-year gross profit.
- The summary includes a reconciliation check that compares the bridge total to the actual current-year gross profit, with a status indicator that flags any residual beyond tolerance. A channel rollup distributes each driver across DTC, Wholesale, and Marketplace based on SKU-level mix.
- A tornado sensitivity strip shows the impact of scaling each driver by plus or minus ten percent.
Practical Use for Financial Analysis
This template is designed for CFOs, controllers, and FP&A leads who need to explain gross margin movements to a board or earnings audience. It supports three current-year scenarios—Base, Upside, and Downside—selectable from the cover sheet, with all current-year inputs linked to the active scenario.
- The model is a gross-profit-only walk; it excludes balance sheet, cash flow, and operating expenses. Each SKU includes a reporting currency, channel mix, and a free-text rationale field.
- The reconciliation check and conditional formatting flag reconciliation differences and common errors such as sign flips or missing FX factors.
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 a gross margin bridge?+
A gross margin bridge decomposes the year-over-year change in gross profit into named drivers - typically Volume, Price, Mix, Cost, and FX - so a finance leader can explain exactly what moved the number. The drivers sum to the actual GP change to the cent.
How is the Mix effect different from the Volume effect?+
Volume holds the SKU mix at PY proportions and only flexes total unit count, valued at the portfolio PY average gross profit per unit. Mix is the residual that captures the impact of selling more or fewer of higher-margin SKUs than the PY portfolio shape. Together they sum to the SKU-by-SKU volume contribution at PY economics.
How is FX applied?+
FX is applied to CY revenue per SKU through a translation factor. Factor > 1.0 means the CY currency strengthened against PY; factor = 1.0 means no FX effect. The FX_Effect formula is CY_units × CY_price × (CY_FX − 1).
Why is the Cost-effect sign flipped from the others?+
By convention, positive numbers in the bridge are favourable to gross profit. A unit cost reduction is favourable, so Cost_Effect is computed as (PY_cost − CY_cost) × CY_units, which lands as a positive when costs fell.
How do I plug in my own SKUs?+
Replace the seed values in the Assumptions sheet (PY and CY units, price, cost, and CY FX factor for each of the five SKU slots). The Period_View, Bridge_Calc, and Summary sheets recalculate from those cells.
Have more financial modelling questions? Contact us
Related templates
Budget vs Actuals Tracker
12-month operating P&L variance tracker with YTD summary.
Revenue Waterfall
Multi-stream bookings to recognized revenue with a deferred-revenue roll-forward.
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.
