RGMAcademy
Talk to us
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 before you sign the trade plan. The same interactive model the full RGM Academy course uses for TPO Lesson 1, no auth, no paywall.

Updated 26 July 2026Extracted from the Trade Promotion Optimization module, lesson 1: Promo ROI Fundamentals
Loading calculator...
Guided walkthrough

Explore the tool, from setup to common mistakes

Five short sections explain the scenario, what each control does, how to read the output, and the mistakes to avoid. Open whichever helps. The tool above works without them.

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, read its Performance Grid verdict (SCALE / HOLD / FIX / CUT), 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 a shallower, higher-uplift or mechanic-gated alternative clears both questions the grid asks: did the money come back, and was more than half the uplift genuinely new.

Key assumptions

  • The calculator models a single SKU x single retailer event in isolation. No portfolio cannibalization, 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 subsidized 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 = subsidized units x (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 everything that left the business: the discount funded on the subsidized base, the discount funded on the genuinely new units (they were sold at the deal price too), and the margin the post‑promo dip takes back. Those are the three red bars on the waterfall, so the denominator is readable off the chart. A small ROI % on a large investment 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 subsidized 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 to 3.0x band; above 4.0x almost always implies pantry-loading rather than new demand. Uplift on its own answers neither question the grid asks, which is the point: it has to be paired with incrementality that clears 50 and money that comes back.
Incremental % of Uplift10% to 90% in 5% steps40% (a common planning assumption for mature FMCG categories)The single most important LEVER, and the one the grid cuts on at 50. The slider is the share of UPLIFT volume that is genuinely new. The Incremental Units tile also shows the share of TOTAL promoted volume, which is always smaller, because the baseline was never incremental. Healthy events typically clear 40 to 50 on the slider, and good mechanic design lifts it to 60 to 80 through multi-buy gates, basket-build and new-shopper acquisition slots.
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.85x 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 x 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 modeled 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 initializes 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 Incremental Profit reads -$15,558 in red on a $27,118 investment, a return of -57.4%. The Incremental Units tile shows 4,000 units, 20% of everything sold on deal, against a slider set at 40% of the uplift. The ribbon reads CUT: it failed both questions. The waterfall shows why. The green bar, the gross profit on the new units, is $11,560. The three red bars against it are $19,960 of discount funded on the 16,000 shoppers who were coming anyway, $4,990 funded on the new ones, and $2,168 of margin the dip takes back afterwards. Add those three and you have the number the percentage divides by.

    Expected outcome: Net Incremental Profit = **-$15,558** on a **$27,118** investment. Return = **-57.4%**. Share of everything sold that was genuinely new = **20.0%**. Grid = **CUT**. The headline retailer pitch (25% TPR, 2x uplift, 2-week slot) destroys roughly $15K per event on one SKU, and only one bag in five that went out on deal was demand the brand did not already have. Industry pattern: McKinsey, working from Nielsen data, puts the share of trade promotions that lose money at around **59 percent**, and this template is a textbook example of how.
  2. Slide Incremental % of Uplift to feel the dominant lever

    Hold every other control at default. Drag Incremental % of Uplift down to 25. Net profit collapses to -$19,893, a -73.4% return, and only 12.5% of what shipped was new. Now drag UP to 60. Net profit recovers to -$9,778 at -36.1%, and the ribbon changes from CUT to FIX. Nothing about the money moved: the investment is $27,118 in all three cases, because the depth never changed. What moved is the answer to the second question, and with it what you should do about the event.

    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 **$2.9K** of profit on this single SKU per 2-week event. The slider is the input you control, and the share of total volume is the number the Performance Grid actually scores. 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 and high-uplift: Net Incremental Profit **+$8,873** on a **$17,137** investment, a return of **+51.8%**, with 36.0% of everything sold genuinely new and a 60 on the slider. Grid **SCALE**. Deep and moderate-uplift: **-$22,045** on a **$33,605** investment, a return of **-65.6%**, share of total 22.2%. Grid **CUT**. A $31K gap on the SAME SKU in the SAME 2-week slot, driven entirely by the depth, uplift and incrementality combination. Note the investment line as well as the profit line: the deep template put nearly twice as much money on the table to lose more of it. Every extra point of depth costs margin on every discounted unit, while extra uplift only pays back on the share of it that is genuinely new.
  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 Incremental Profit at default plus a heavy dip = **-$26,395**, a return of **-69.5%**, still **CUT**. The Post-Promo Dip bar in the waterfall is now **$13,005**, larger than the $11,560 of gross profit the new units earned, so the deferred volume alone costs more than the whole event made. This is the profit killer nobody puts in the deck: scanner data routinely shows promo-week gains fully reversed within 4 to 6 weeks, and the bridge is where you would have seen it coming.
  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** on a **$52,068** investment, ROI = **-55.6%**. The absolute loss is ~1.85x the 2-week loss; the return improves slightly (from -57.4%) because the fixed dip cost becomes a smaller share of the now larger investment, but the underlying P&L damage is much bigger. Running a weak template for longer just multiplies the loss it was already making. 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 counter-proposal, then see how much better it can get

    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 push uplift to 3.0x AND incremental‑of‑uplift to 75% at 12% depth to see what a genuinely strong template looks like.

    Expected outcome: Counter-proposal at 15% / 2.5x / 60 slider: Net Incremental Profit = **+$5,130** on a **$20,880** investment, a return of **+24.6%**, 36% of everything sold genuinely new. Grid = **SCALE**. That is a loss turned into a gain on the same SKU in the same slot. Push to 12% / 3.0x / 75 slider: **+$23,219** on a **$20,131** investment, a return of **+115.3%**, and half of everything sold was new. Look at the two investments: the stronger template puts LESS money on the table and returns about four and a half times as much, because the shallower cut shrinks the give-away on every case while the mechanic gating grows the pool that earns anything. Templates this strong exist in real calendars and are rare, so the realistic ambition is a plan with several like the first and one or two like the second.
  7. Land on the Thursday recommendation

    Pin your preferred template, then pressure‑test three what‑ifs: incrementality drops 10 points because the mechanic underperforms, the dip extends a week because of a calendar overlap, and depth creeps 3 points because the retailer compresses you. Record the profit, the investment and the return for each. Then size it: if this single SKU clears +$5K an event on the counter‑proposal or +$23K on the stronger one, what does the calendar look like at 8 SKUs across 6 events a year?

    Expected outcome: Your recommendation should sound like this. 'The retailer's proposed 25% / 2.0x template is a CUT. It destroys $15K an event on a $27K investment. The counter-proposal at 15% / 2.5x with multi-buy gating delivers +$5K an event and lands in SCALE; pushing to 12% / 3.0x with stronger gating delivers +$23K on a smaller investment. Downside cases keep both profit-positive. Ten points off the slider takes the counter-proposal to +$795 and the shallower one to +$17,439, and 3 points of depth creep takes the counter-proposal to +$1,387. Annualised across 8 SKUs and 6 events, the swap out of the proposed plan is worth roughly +$990K, and the stronger template adds about +$870K on top of that.' Six numbers, one paragraph, decision-ready. Note that both downside cases stay above zero and one of them drops out of SCALE into HOLD, which is a different conversation rather than a worse one. Cross-reference Pricing Lesson 2: **a 1% list-price improvement flows to roughly +11.1% operating profit**, and that is the bar every trade dollar has to clear somewhere else.
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 x full margin) - (Subsidized units x discount per unit) - (Incremental units x discount per unit) - (Dip volume x 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 / (Discount on Subsidized Base + Discount on New Units + Dip Cost) x 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. The percentage is identical, so only the absolute profit tells you how much money is actually at stake.
Incremental Units(Total promo volume - Baseline volume in promo period) x Incremental %Units the promo ACTUALLY sold incrementally, which is the only volume the event can credibly take credit for. The rest is subsidized base (loyal buyers who would have bought at full price), and the gap between Total Promo Volume and Incremental Units is the size of the margin give-away you're funding.
Subsidized UnitsTotal promo volume - Incremental unitsUnits that would have been bought at full price and now get the discount anyway. Every unit here is money pushed across the table for nothing. The default scenario funds a discount on 16,000 of them to reach 4,000 genuinely new ones, four to one, which is why net profit reads -$15,558.
Performance Grid VerdictTwo questions and no others. Did the money come back (ROI above 0), and was the volume real (Incremental % of Uplift above 50). SCALE passes both. HOLD passes the money question only. FIX passes the volume question only. CUT fails both.The call to take into a trade review. The volume cut reads the SLIDER, the share of the uplift that is genuinely new, which is the same cut TPO Lesson 4 applies so an event scored here gets the same verdict there. The Incremental Units tile also shows the share of everything sold on deal, always the smaller number, and that is the diagnostic that explains why a template struggles rather than a threshold. SCALE means replicate it and give it more weeks and more customers. HOLD means it pays on volume that was largely coming anyway, so buy reach rather than depth. FIX means it is recruiting genuinely new shoppers and still does not pay, so change the funding rather than cancel a template doing the hard part. CUT means cancel it and move the budget. There is no banding beyond zero, and any table of green-amber-red cut-offs handed to you is a company convention rather than an industry standard.

Read the four tiles and the ribbon as a stack. Net Incremental Profit answers did this make money. Promo ROI answers how much money it took to find out, and it divides by the three red bars so you can check it yourself. Incremental against Subsidized Units answers where the money went, and tells you whether the lever is depth, uplift or a mechanic change. The grid verdict answers what to do next.

The pre‑review check is to read all five together, then stress‑test by sliding incrementality 10 points either way around your assumption. If the verdict holds through both, the recommendation is committee‑ready. If a 10‑point swing flips it, you need scanner‑data calibration before signing the JBP. Benchmark to keep handy: McKinsey, on Nielsen data, puts the share of trade promotions that lose money at around 59 percent. The bridge is how you tell which of yours are in that 59 and which only looked good on the volume line.

5.55 common mistakes to avoid

Diagnostic patterns that catch the most common misuse of this calculator.

  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 came back as a cancel at a negative return. The data never changed, only what the numerator counted and what the denominator divided by, and that alone turned a headline win into a loss.
    Fix: The return is **net incremental profit over everything that left the business**, and both halves have to be right. The numerator counts only genuinely new volume, valued at the REGULAR gross profit per unit. The denominator carries the discount funded on EVERY promoted unit plus any fee money plus the margin the dip takes back, not just the discount on the subsidised ones. The default 25% / 2.0x scenario here: -$15,558 over $27,118 is -57.4%, which is what the event actually returned. Leaving the discount on the new units out of the denominator flatters exactly the high-incrementality events worth rescuing, and the 'sales spike x margin per unit' shortcut overstates the return by a factor of two to five.
  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 subsidized loyal buyers.
    Fix: Volume uplift is **necessary and nowhere near sufficient**. The grid needs the money back AND more than half the uplift genuinely new, and uplift on its own answers neither. A 2.5x uplift at 25% incrementality is a cancel; the same 2.5x at 60% on a shallower cut is a template worth replicating. Always pair the uplift number with the incrementality estimate before anyone celebrates.
  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 x Dip Duration** in the bridge. Heavy-promotion categories (biscuits, snacks, canned goods, cleaning) see 15-25% dips lasting 1-3 weeks. Light-promotion categories see 5-10% lasting 1 week. The default 15% x 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-3x 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 costs you margin on every discounted unit, while uplift only pays back on the share of it that is genuinely new.
  5. Mistake 5Repeating losing templates because the cosmetic ROI metric looks 'okay'
    Symptom: The retailer scorecard showed an average return near break-even and the Customer Marketing team read it as 'roughly fine, optimise around the edges'. The bridge math run by Commercial Finance showed the average was concealing a barbell: most of the calendar under water, a thin group returning very well, and an average that described neither. The losing events were destroying enough to cancel out everything the strong ones earned.
    Fix: Track **distribution, not average**, because an average is the wrong statistic for a shape like this. Build a grid summary every quarter, give every event a verdict, and treat the cancel list as a list rather than a percentage. In the worked calendar on this lesson, 59% of events lose money, 18% pay back thinly, and 23% pay back properly, with a mean of +0.7% that would have told you to leave the whole thing alone. Read the verdicts and the medians. The Net Incremental Profit Bridge is the per-event diagnostic; the grid is the portfolio-level decision.
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.

Unlock the full Promo ROI Fundamentals lesson

Or see what a team rollout includes