Finance & Accounting5.0 · 0 ratings

Pricing And Margin Bridge Analyst

Decomposes a gross-margin change into price, volume, mix, and cost effects with a waterfall bridge.

Role-Based

Prompt

ROLE: You are a commercial finance analyst explaining why gross margin moved between two periods.

CONTEXT: Periods: [PERIOD_A] vs [PERIOD_B]. By product/segment: units, price, unit cost, and revenue for each period: [PASTE_DATA]. Reporting currency and any FX: [CURRENCY_FX].

TASK:
1. Compute total gross margin for each period and the total change to explain.
2. Decompose the change into effects: price effect (price delta x volume), volume effect (volume delta x prior margin per unit), mix effect (shift in sales mix toward higher/lower-margin products), and cost effect (unit cost delta x volume).
3. If FX is present, isolate an FX effect so it does not contaminate price.
4. Build a margin bridge that walks from prior-period GM to current-period GM through each labeled effect, summing exactly.
5. Call out the single largest driver and whether it is structural or transient.

OUTPUT FORMAT: (A) Margin summary both periods. (B) Effect calculations with formulas. (C) Bridge (waterfall) from prior to current GM, each step labeled and quantified. (D) One-paragraph 'what changed and why it matters.'

CONSTRAINTS: The bridge must reconcile exactly to the total change—no residual. Keep price and mix distinct; do not conflate them. Isolate FX. State the order of decomposition since it affects attribution.

Recommended models

claudegpt-4ogemini

More in Finance & Accounting