50% off all plans.Ends 20 May 2026Claim 50% off
RGM Academy
Sign inSign up free
Free tool · no login required

Promo ROI Calculator

Build the Net Incremental Profit Bridge for any FMCG trade promo, then read the Performance Grid verdict (BEST / GOOD / REVIEW / STOP) before signing the trade plan. The same interactive model the full RGM Academy course uses for TPO Lesson 1 — no auth, no paywall.

Updated 23 April 2026Extracted from the Trade Promotion Optimisation module, lesson 1: Promo ROI Fundamentals
Loading calculator…
Scenario walkthrough

Tap any section to explore in detail

5.1Scenario setup

The starting SKU, market, and assumptions the model makes.

You're a Customer Marketing Manager working a national grocery account on a Mainstream Biscuits 250g SKU. Regular price $4.99, unit cost $2.10, full margin $2.89/unit (57.9% gross margin), baseline 5,000 units/week. The retailer wants a Q3 trade plan — they're pushing for a 25% TPR (temporary price reduction) running 2 weeks, expecting a 2.0x uplift. You've seen this template before; the Sales team loves it because the volume hits the sell-in number. Finance wants to know whether it actually creates profit.

Your job: build the Net Incremental Profit Bridge for the proposed event, classify it on the four-quadrant Performance Grid (BEST / GOOD / REVIEW / STOP), and come back with either a green light or a restructured counter-proposal before the JBP meeting on Thursday.

Your objective

Use the calculator to quantify the Net Incremental Profit of the proposed promo template, then test whether shallow-with-high-uplift or restructured-mechanic alternatives clear the +25% ROI / 50% incrementality threshold needed to land in the BEST quadrant.

Key assumptions

  • The calculator models a single SKU × single retailer event in isolation — no portfolio cannibalisation, no competitive promo overlap, no halo to non-promo packs. Cross-SKU effects sit in the TPO L2 Source-of-Volume lesson.

  • Incremental % is the share of promo volume that is genuinely new demand. The remainder is subsidised base — loyal buyers who would have bought at full price but now enjoy the discount. The split is the single most consequential assumption in the entire model.

  • Margin dilution = subsidised units × (full margin − promo margin). This is the cost of the discount on the volume you'd have sold anyway. It's a real P&L cost; the retailer just doesn't see it on their side.

  • Post-promo dip is the volume reduction below baseline AFTER the event ends, because pantry-loaded shoppers stay away. Heavy-promotion categories see 15-25% dips lasting 1-3 weeks; light-promotion categories see 5-10% dips lasting 1 week. Multiplied by Dip Duration to get total deferred volume.

  • ROI denominator is total promotional cost (margin dilution + dip cost), not gross promo investment. A small ROI % on a large cost can still be a large absolute loss — read Net Profit alongside ROI, never one without the other.

5.2Controls & toggles

Every input the calculator exposes, its range, and what it changes.

ControlRangeDefaultWhat it changes
Discount Depth5% to 50% in 1% steps25% (proposed retailer template)How deep the price cut goes during the promo. Drives both uplift AND margin dilution. Doubling depth roughly doubles margin given away per subsidised unit, but typically less than doubles uplift — diminishing returns in the deep-discount zone.
Volume Uplift1.0x to 5.0x in 0.1x steps2.0x (the retailer's headline expectation)Multiplier on baseline weekly volume during the promo. Realistic FMCG uplifts sit in the 1.5x-3.0x band; >4.0x almost always implies pantry-loading rather than new demand. The Performance Grid's BEST quadrant requires uplift to be paired with ≥50% incrementality.
Incremental % of Uplift10% to 90% in 5% steps40% (post-2020 industry mean for mature FMCG categories)The single most important LEVER. Slider value is share of UPLIFT volume; the Performance Grid threshold uses share of TOTAL promo volume (different number — the Incremental Units tile shows both). Healthy events typically clear 40-50% on the slider; mechanic design (multi-buy gates, basket-build, new-shopper acquisition slots) lifts it to 60-80%. To clear BEST (≥50% share-of-total), the slider value must reach roughly 100% at 2.0x uplift (unreachable), 83% at 2.5x, 75% at 3.0x.
Duration1 to 6 weeks in 1-week steps2 weeks (standard TPR slot)Weeks the promo runs. Longer durations boost total volume but train shoppers to only buy on deal — incrementality erodes with each repeat exposure. A 4-week TPR at the default depth/uplift loses roughly 1.85× the absolute profit a 2-week TPR loses at the same template.
Post-Promo Dip0% to 40% in 5% steps15% (heavy-promotion category mean)Percentage volume falls below baseline after the promo ends, as pantry-loaded shoppers stay away. Multiplied by Dip Duration to get total deferred volume × full margin, which is a pure P&L drag. Shallow promos with low pantry potential see 5-10%; deep promos in stockable categories see 25-30%.
Dip Duration0 to 4 weeks in 1-week steps1 week (post-2-week-TPR default in scanner data)Weeks the post-promo volume dip lasts. A 15% dip lasting 1 week costs much less than a 15% dip lasting 4 weeks. Heavy-promotion calendars where consecutive events run back-to-back never let the dip fully resolve — the modelled dip cost is then chronically understated.
5.3Step-by-step exploration

7-step guided exploration of the scenario.

  1. Read the proposed template at the default

    The calculator initialises at the retailer's proposed template: 25% discount, 2.0x uplift, 40% incremental of uplift, 2 weeks, 15% post-promo dip, 1 week dip duration. Look at the four KPI tiles and the Performance Grid ribbon. Net Profit reads -$15,558 in red. ROI reads -70.3%. The Incremental Units tile shows 4,000 units = only 20% of TOTAL promo volume is incremental (the rest is subsidised baseline). The ribbon classifies the event as STOP. The waterfall shows why: the Incremental Margin bar (~$6,570) is dwarfed by Margin Dilution (~$19,960 given away to the 16,000 subsidised units) plus the post-promo dip (~$2,168).

    Expected outcome: Net Profit = **-$15,558**. ROI = **-70.3%**. Incrementality (% of total) = **20.0%**. Performance Grid = **STOP**. The headline retailer pitch (25% TPR, 2x uplift, 2-week slot) destroys roughly $15K of profit per event on this single SKU — and only one in five units sold during the promo was genuinely incremental. Industry benchmark: in a published scorecard of 1,640 events, **21% landed in STOP** with combined turnover loss of ~€5.1M against ~€4.3M of trade spend — the default scenario is a textbook example of the failure mode.
  2. Slide Incremental % of Uplift to feel the dominant lever

    Hold every other control at default. Drag Incremental % of Uplift from 40% down to 25% — Net Profit collapses to ~-$19,893, share-of-total drops to 12.5%. Now drag UP to 60% — Net Profit recovers to ~-$9,778, share-of-total rises to 30%. Even at 60% slider (which is excellent for a straight TPR mechanic), the default depth + 2.0x uplift still destroys profit AND keeps share-of-total well below the BEST threshold of 50%. At 2.0x uplift, BEST is mathematically unreachable.

    Expected outcome: Net Profit at 25% / 40% / 60% slider = **-$19,893 / -$15,558 / -$9,778**. incrementalityShare at the same three points = **12.5% / 20.0% / 30.0%**. Each 10pp on the slider is worth roughly **$3K-4K** of profit on this single SKU per 2-week event. The slider is the lever; the share-of-total is the verdict. Multiply by the dozen-or-more SKUs and 50+ slots in a typical national trade calendar to feel why incrementality measurement is the single highest-leverage capability a Customer Marketing team can build.
  3. Compare two strategic templates head-to-head

    Reset, then try the shallow + high-uplift template: discount 12%, uplift 2.5x, incremental-of-uplift 60% (achievable with a multi-buy mechanic that gates incrementality). Then try the deep + moderate-uplift trap: discount 35%, uplift 1.8x, incremental-of-uplift 50% (typical of a deep TPR with no mechanic gating).

    Expected outcome: Shallow + high-uplift: Net Profit **+$8,873**, ROI **+75.5%**, share-of-total **36.0%**, Performance Grid **GOOD** (clears the ROI bar but not the ≥50% share-of-total bar required for BEST). Deep + moderate-uplift: Net Profit **-$22,045**, ROI **-82.8%**, share-of-total **22.2%**, **STOP**. A $30K profit gap on the SAME SKU at the SAME 2-week slot, driven entirely by the depth/uplift/incrementality combination. Deep discounts almost never recover the margin they give away even when the headline uplift looks healthy — depth eats margin linearly, uplift earns it only at the incrementality multiplier.
  4. Add a realistic post-promo dip

    Reset to default. Now set Post-Promo Dip to 30% and Dip Duration to 3 weeks — the realistic shape for a stockable category running back-to-back deep events. The dip cost balloons from $2,168 (default) to $13,005.

    Expected outcome: Net Profit at default + heavy dip = **-$26,395**, ROI = **-80.1%**, still STOP. The Post-Promo Dip bar in the waterfall is now nearly TWICE the size of the Incremental Margin bar — meaning the deferred-volume cost alone exceeds everything the promo earned. This is the silent profit killer in heavy-promotion calendars: scanner data routinely shows promo-week gains fully reversed within 4-6 weeks, and the bridge math here is why.
  5. Stretch the duration to see compounding losses

    Reset, then drag Duration from 2 to 4 weeks, holding everything else at default. Compare the Net Profit, ROI, and waterfall against the 2-week baseline.

    Expected outcome: At 4 weeks: Net Profit = **-$28,948**, ROI = **-68.8%**. The absolute loss is ~1.85× the 2-week loss; ROI improves slightly because the fixed dip cost becomes a smaller share of the (now larger) total cost base, but the underlying P&L damage is much bigger. Longer durations DO NOT fix bad templates — they amplify them. Worse, in scanner data, longer durations also REDUCE incrementality as shoppers learn the cycle, so this calculator is being kind by holding incrementality constant.
  6. Build a GOOD counter-proposal — and see what BEST takes

    Reset. Construct a defensible counter-proposal to bring back to the retailer: discount 15%, uplift 2.5x, incremental-of-uplift 60% (achievable with a 3-for-£X multi-buy mechanic), 2 weeks, default 15% / 1 week dip. Read the tiles. Then, to see what a BEST-quadrant event actually requires, push uplift to 3.0x AND incremental-of-uplift to 75% at the same 12% depth.

    Expected outcome: Counter-proposal at 15% / 2.5x / 60% slider: Net Profit = **+$5,130**, ROI = **+36.3%**, share-of-total **36%**, Performance Grid = **GOOD**. Profit-positive (loss → gain on the same SKU), but doesn't clear the ≥50% share-of-total bar required for BEST. Push to 12% / 3.0x / 75% slider: Net Profit = **+$23,219**, ROI = **+208.3%**, share-of-total = **50.0%**, Performance Grid = **BEST**. The BEST tier exists in real trade calendars but is rare — it requires both very high uplift (3.0x+) AND very high mechanic-gated incrementality (75%+ on the slider). Most well-run trade plans target a portfolio of mostly GOOD events with a small share of BEST, not the other way around.
  7. Land on the Thursday recommendation

    Pin your preferred template, then pressure-test against three what-ifs: incrementality drops 10pp (mechanic underperforms), dip extends 1 extra week (calendar overlap), depth creeps +3pp (retailer compression). Record Net Profit and ROI for each. Then size the recommendation across the portfolio: if this single SKU clears +$5K/event in GOOD or +$23K in BEST, what does the calendar look like at 8 SKUs × 6 events/year?

    Expected outcome: Your recommendation should sound like: 'The retailer's proposed 25% / 2.0x template is STOP — it destroys $15K/event. Counter-proposal at 15% / 2.5x / 60% slider with multi-buy gating delivers +$5K/event in GOOD quadrant; pushing to 12% / 3.0x / 75% with stronger mechanic gating delivers +$23K/event in BEST. Downside cases (mechanic underperforms by 10pp slider, depth creeps +3pp) keep both options profit-positive. Annualised across 8 SKUs × 6 events, the swap from STOP to GOOD is worth roughly +$960K incremental gross profit vs the proposed plan; the swap to BEST adds another +$870K on top.' Six numbers, one paragraph, decision-ready. Cross-reference Pricing Lesson 2: at 57.9% gross margin, **a 1% list-price improvement on this SKU delivers ~+$2.9K/week of gross profit at baseline** — the trade-investment opportunity-cost hurdle every trade dollar should clear.
5.4Reading the output

Every KPI, the formula behind it, and how to interpret a positive or negative value.

KPIFormulaHow to read it
Net Profit(Incremental units × promo margin) − (Subsidised units × margin given away) − (Dip volume × full margin)The number Finance cares about. Negative means the promo destroyed gross profit; positive means it created it. Read this BEFORE ROI — a small ROI % on a large investment can be a much bigger absolute loss than a large negative ROI % on a small investment. The KPI tile turns red when negative, emerald when positive.
Promo ROINet Profit / (Margin Dilution + Dip Cost) × 100ROI as a ratio of net incremental profit to total promotional cost. Useful for comparing events of different absolute sizes, but read alongside Net Profit. A +35% ROI on a $10K event is a $3.5K win; a +35% ROI on a $200K event is a $70K win — same ROI, very different P&L impact.
Incremental Units(Total promo volume − Baseline volume in promo period) × Incremental %Units the promo ACTUALLY sold incrementally — the only volume the event can honestly take credit for. The rest is subsidised base (loyal buyers who would have bought at full price). The gap between Total Promo Volume and Incremental Units is the size of the margin give-away you're funding.
Subsidised UnitsTotal promo volume − Incremental unitsUnits that would have been bought at full price but now enjoy the discount — pure margin give-away. Every unit here is money pushed across the table for nothing. The default scenario gives away 16,000 units' worth of margin to fund 4,000 genuinely incremental units; that 4:1 give-away ratio is why the Net Profit reads -$15,558.
Performance Grid QuadrantBEST: ROI > +25% AND incrementalityShare ≥ 50% (where incrementalityShare = Incremental Units / Total Promo Volume). GOOD: ROI > 0% (other). REVIEW: ROI > -35%. STOP: ROI ≤ -35%.The single number to take into a trade review. The BEST threshold uses share of TOTAL promo volume that is incremental — NOT the Incremental % slider value (which is share of UPLIFT volume only, a different number). The Incremental Units tile shows both side-by-side. BEST = scale this template across analogous SKUs and slots. GOOD = profit-positive but capped (share-of-total below 50% means too much margin still goes to subsidised base). REVIEW = restructure depth/mechanic/duration before repeating. STOP = profit-destructive at scale; kill the template, don't repeat. The four-quadrant classification is what separates 'we ran some promos' from 'we run a portfolio of templates with known ROI distributions'.

Read the four tiles + the ribbon as a stack. Net Profit answers 'did this make money?'. ROI answers 'how efficient was the spend?'. Incremental vs Subsidised Units answers 'where did the profit go?' — and is the diagnostic that tells you whether the lever to pull is depth (to reduce dilution), uplift (to grow the incremental pool), or a mechanic change (to gate the incrementality share). Performance Grid Quadrant answers 'what do I do next?' — scale, protect, restructure, or stop.

The pre-trade-review check is to read all five together, then stress-test the result by sliding incrementality ±10pp around your assumed value. If the verdict (BEST/GOOD/REVIEW/STOP) is robust to a 10pp incrementality swing, the recommendation is committee-ready. If a 10pp swing flips the quadrant, you need scanner-data calibration on incrementality before signing the JBP. Industry benchmark to keep handy: across published FMCG scorecards, roughly 59% of trade promotions destroy value at scale — the bridge tool is what separates the 41% that work from the 59% that don't.

5.55 common mistakes to avoid

Diagnostic patterns that catch most misuse of this calculator in practice.

  1. Mistake 1Reporting 'ROI' on total volume instead of incremental volume
    Symptom: The headline read '+150% ROI' on a 25% TPR. Six months later the post-event analysis ran with proper incrementality controls and the same event was reclassified as STOP at -68% ROI. Same data, different denominator definition — different P&L conclusion.
    Fix: ROI must always be **net incremental profit / total promotional cost**, where promotional cost is margin dilution + dip cost (not gross revenue × discount %). The default 25% / 2.0x scenario in this calculator clears that test: -$15,558 net profit / $22,128 total cost = -70.3% ROI, which is honest. The 'sales spike × margin per unit' shortcut almost always overstates ROI by a factor of 2-5×.
  2. Mistake 2Confusing volume uplift with profit success
    Symptom: Sales celebrated a 2.5x uplift on the Q2 event. Trade marketing celebrated the sell-in number being hit. Three months later the bridge analysis showed -$22K net profit per event because incrementality was 25%, not the assumed 50%, and the 35% depth gave away too much margin to subsidised loyal buyers.
    Fix: Volume uplift is a **necessary but not sufficient** condition for profit. The Performance Grid BEST quadrant requires BOTH ROI > +25% AND incrementality ≥ 50%. A 2.5x uplift with 25% incrementality typically delivers REVIEW or STOP; the same 2.5x with 60% incrementality typically delivers BEST. Always pair the uplift number with the incrementality estimate before celebrating.
  3. Mistake 3Ignoring the post-promo dip in the bridge
    Symptom: The promo-week analysis showed +$8K net profit. The retailer called it a win. The 4-week post-event analysis showed -$15K because the pantry-loaded shoppers stayed away for 3 weeks afterwards, and nobody had baselined that loss into the bridge.
    Fix: **Always include Post-Promo Dip × Dip Duration** in the bridge. Heavy-promotion categories (biscuits, snacks, frozen, cleaning) see 15-25% dips lasting 1-3 weeks. Light-promotion categories see 5-10% lasting 1 week. The default 15% × 1 week in this calculator is the moderate case; many real events are worse. Cross-check post-promo baselines in your scanner data before signing big-depth trade plans.
  4. Mistake 4Comparing depth and uplift in isolation, without incrementality
    Symptom: The trade plan compared 'shallow + low uplift' vs 'deep + high uplift' templates and chose the deeper one because it delivered more total volume. The bridge math, run after the fact, showed the shallow template delivered 2-3× the net profit because it ran at 60% incrementality (multi-buy mechanic) vs the deep template at 25% (straight TPR).
    Fix: **Incrementality is a lever, not a constant.** Mechanic design (multi-buy, basket-build, new-shopper trial slots, time-limited offers) can lift incrementality from the 25-30% base TPR rate to 50-65%. The shallow + high-uplift + high-incrementality template (12% / 2.5x / 60% in this calculator) consistently outperforms deep + moderate templates because depth eats margin linearly while uplift earns it only at the incrementality multiplier.
  5. Mistake 5Repeating losing templates because the cosmetic ROI metric looks 'okay'
    Symptom: The retailer scorecard showed 'avg ROI -8% across the calendar' and the Customer Marketing team treated it as 'roughly break-even, just optimise around the edges'. The bridge math run by Commercial Finance showed that average concealed a portfolio with 21% of events deeply STOP, 38% REVIEW, 30% GOOD, and only 11% BEST — and the 21% STOP events were destroying enough value to wipe out the entire BEST tier.
    Fix: Track **distribution, not average**. Build a Performance Grid summary every quarter classifying every event into BEST / GOOD / REVIEW / STOP, and treat the STOP tier as a kill list. The published industry benchmark of 21% of events in STOP and 59% destroying value at scale is not an industry average to accept — it's the gap a properly-run trade calendar should close. The Net Incremental Profit Bridge is the per-event diagnostic; the Performance Grid is the portfolio-level decision tool.
Related concepts

Go deeper on the theory

Continue with the lessons

Go further inside Trade Promotion Optimization

This calculator is the sandbox slice of Lesson 1: Promo ROI Fundamentals. Each of the other 7 Trade Promotion Optimization lessons teaches a complementary concept that sharpens how you read the output above.

See Promo ROI Calculator inside the full lesson

RGM Academy lets you pull every commercial lever yourself inside a senior-practitioner simulator, with the AI RGM Strategist coaching every decision you make.

Claim 50% off — unlock the full lesson

Or sign up free — 12 lessons included