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.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Finance & Accounting