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
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt