Trade Investment ROI: How to Score Every Customer's Trade Spend at the Portfolio Level

Trade Investment ROI is the customer-portfolio cousin of Promo ROI. Promo ROI lives at the event level: one TPR, two weeks, single SKU, single retailer. Trade Investment ROI lives one floor up. It scores every dollar of trade money flowing to a customer across a year, against every dollar of incremental gross profit that customer delivered.

The frame matters because most of the trade dollar in FMCG is not promotional. The promotional accrual is the visible piece, the one commercial teams talk about every week. The off-invoice rebates, growth allowances, JBP funding, distribution support, listing fees, cash-discount cost, and the cost of capital tied up in extended payment terms together usually add up to more money than the promo line. None of that flows through a single event. All of it flows through the customer relationship. So all of it has to be scored at the customer level or it is never scored at all.

What goes in the numerator

The numerator is incremental gross profit, not total gross profit. The distinction is the same one you walk in the Promo ROI lesson, lifted to the annual customer level.

• Annual gross profit the customer actually delivered, after all trade deductions
• minus the gross profit you would have earned with no trade investment at all (the do-nothing baseline)
• equals incremental gross profit attributable to the trade dollar

The do-nothing baseline is the hard part. For a tier-one customer where you have run trade programmes for fifteen years, there is no clean counterfactual. Most teams approximate it with two methods: a small set of low-investment customers in the same channel as a comparison group, and a structural assumption that something like 60 to 75 percent of the customer's volume would have happened anyway. Both methods are imperfect. Both are better than scoring against zero.

What goes in the denominator

Every dollar that left the building because of this customer in the past twelve months. The trap is that these dollars sit in five or six different cost centres, and nobody owns the consolidated view by default.

• Off-invoice rebates and growth allowances, settled quarterly or annually
• Promotional funding, the sum of every TPR, display, and feature event run with this customer over the year
• Listing fees, distribution support, and JBP commitments paid against assortment or category obligations
• Cash-discount cost from early-payment terms (often 1 to 2 percent of net invoice value)
• The cost of capital on extended payment days (60 days payable instead of 30 is real money at any sensible cost of capital)

A fully-loaded customer denominator usually shocks the commercial team the first time it is built. The number is often 30 to 60 percent larger than the promotional accrual the team had been quoting in trade reviews.

The pattern that breaks every portfolio review

The canonical RGM finding, repeated across dozens of FMCG portfolios: the top ten customers by revenue are rarely the top ten by Trade Investment ROI. Almost always, the relationship is concave. The largest customer extracts the deepest off-invoice terms because they have the negotiating leverage, so they sit closer to a 1.5x to 2x ROI even though they are 20 percent of revenue. The genuine high-ROI customers tend to be mid-tier accounts in the 2 to 5 percent revenue band, where trade investment is lighter and the customer is still growing on a smaller base.

This is uncomfortable because it implies the portfolio is being subsidised by a long tail of mid-tier accounts that finance the headline customer's deal. Once the TIER scatterplot is on the wall, that subsidy becomes visible, and the conversation about resetting top-customer terms stops being theoretical.

How it links to the rest of trade terms

Trade Investment ROI sits on top of the bridges you have already built. The G2N waterfall (TT Lesson 2) gives you the per-customer pocket price, which is the input to the customer's incremental gross profit. The customer-tiering work (TT Lesson 3) sets the strategic ROI bar each customer should clear (a tier-one strategic partner can run at 1.5x, a tier-three opportunistic account should clear 3x or more). The TIER quadrants in this concept are how you decide which of the bottom-quadrant customers gets a reset versus a renegotiation versus a graceful exit.

The headline calculation is one line. The discipline is in what counts as incremental in the numerator and what counts as fully-loaded in the denominator.

Headline formula

Trade Investment ROI = Annual Incremental Gross Profit from Customer / Annual Trade Investment to Customer

Both numbers are dollars per year. The ratio is dimensionless. A score of 2.5x means every dollar of annual trade investment returned $2.50 of incremental gross profit.

Numerator build

Annual Incremental GP = (Annual Net Sales × Customer Gross Margin %) − Do-Nothing Baseline GP

Where:

• Annual Net Sales is the customer's total revenue after all trade deductions, taken from the P&L
• Customer Gross Margin % is the customer-specific blended gross margin after channel mix, often 2 to 5 percentage points lower than the company average for tier-one accounts
• Do-Nothing Baseline GP approximates what you would have earned without the trade investment, either via a matched comparison group of low-investment customers or via a structural assumption (typical: 60 to 75 percent of current volume)

Denominator build

Annual Trade Investment = Off-Invoice Rebates + Promotional Funding + Listing & JBP Fees + Cash-Discount Cost + Payment-Term Capital Cost

Each line is a real dollar leaving the company in the year. The cash-discount cost is often missed because it is buried in payment terms rather than in the trade ledger. The payment-term capital cost is a soft number (cost of capital × average days outstanding × annual revenue / 360) but it is real, and for accounts on 90-day terms it is meaningful.

Verification identity

The customer's annual trade investment, divided by their annual gross sales, should reconcile to that customer's total trade rate as seen in the G2N bridge. If the two numbers do not match within rounding, a deduction layer has been missed in one of the two builds.

Customer Total Trade Rate (%) = Annual Trade Investment / Annual Gross Sales

Annual scale

Once the per-customer ROI is sound, the portfolio numbers are mechanical and they are the numbers worth fighting over.

Portfolio Trade Investment = Sum of Annual Trade Investment across all customers

Portfolio Incremental GP = Sum of Annual Incremental GP across all customers

Portfolio Trade Investment ROI = Portfolio Incremental GP / Portfolio Trade Investment

Sub-1.0x Spend at Risk = Sum of Annual Trade Investment for customers with ROI below 1.0x

The "spend at risk" line is the one that lands in the C-suite. It is the dollar value of trade investment that, on the current scoring, is destroying gross profit rather than creating it. Even at conservative recovery assumptions (say, 30 percent of the at-risk spend reclaimable through term resets), the portfolio prize is usually a meaningful share of company operating profit.

A North American snacks manufacturer with $480M annual gross sales runs a portfolio of 14 named customers across grocery, mass, club, and foodservice. The new VP of customer strategy asked for a portfolio-wide Trade Investment ROI review in the first quarter on the job. The numbers below are illustrative but typical of what the first such review tends to surface.

What the team expected

The commercial review packs every quarter showed the top three customers as "anchor partners" worth defending. Trade investment with the top customer (Customer L, a big-box retailer) ran at 31 percent of their gross sales, against a portfolio average of 24 percent. The team's assumption: the elevated rate was the cost of doing business with a top-three retailer, and the relationship paid for itself in scale.

What the TIER chart revealed

When the team built the customer-level G2N bridges (per Lesson 2), classified each customer's full trade investment denominator (per the formula above), and approximated incremental gross profit using a matched-cohort baseline, the portfolio split into four very different groups:

Two findings landed hard.

First, Customer L (the "anchor" big-box) was a Question Mark, not a Star. Its ROI was 1.2x. The 31 percent trade rate had crept up over six JBP cycles as the buyer had asked for incremental support against weakening category growth. The customer was profitable on absolute gross profit but well below what the trade dollar should have been earning.

Second, the Cash Cows quadrant was carrying the portfolio. Four mid-tier customers, 17 percent of revenue, were running at 3.6x ROI on a small trade investment base. They were quietly funding the headline customer's deal.

What changed in the next JBP cycle

The team did not propose ending any relationships. They proposed three structural moves over two JBP cycles.

Customer L (top Question Mark): a 280 basis point trade-rate reset. Three legacy line items were retired: a "category captaincy" allowance from 2019 that had been auto-renewed, a "new product slotting" fee still being paid for products launched four years earlier, and a quarterly "growth bonus" that had been paying out regardless of actual growth. The customer pushed back hard. The reset went through at 220 basis points instead of the 280 proposed, which lifted Customer L's ROI from 1.2x to 1.7x. Not a Star yet, but no longer in the bottom-right corner.

Customers H and I (Drains): renegotiation with explicit walk-away. The smallest two Drains were renegotiated with the explicit option of exiting if terms could not be moved. One (Customer H) restructured. One (Customer I) chose to walk and went to a competitor. The team's revenue dropped 1.2 percent and the company's gross profit rose, because the trade investment freed up exceeded the lost gross profit on the volume.

Customers A and B (Cash Cows): selective uplift. Two of the strongest Cash Cows received increased distribution support to help them grow. Both moved into Star territory within two cycles, with the manufacturer earning a higher share of the customer's category growth than they had under flat support.

What changed in the operating model

After the first TIER review, three things became standard.

• Every customer's Trade Investment ROI was scored quarterly, not annually
• The TIER chart replaced the "top-five customer revenue" slide as the lead chart in the QBR pack
• Every JBP cycle opened with the customer's current quadrant and the target quadrant, agreed before the negotiation started

The portfolio-level Trade Investment ROI rose from 2.4x in year one to 2.9x in year three. The headline trade rate barely moved. The mix of trade dollars across customers changed completely.

The Trade Investment Efficiency Ratio (TIER) chart is the diagnostic that turns a column of customer ROIs into a portfolio decision. You plot every customer on two axes: revenue size on the x-axis, Trade Investment ROI on the y-axis. A horizontal line at 2.0x marks the healthy threshold. A vertical line at the median customer revenue splits the portfolio into "above the median" and "below the median" by size. Four quadrants appear, and each quadrant carries a different action.

The TIER scatterplot

Stars (top right): high revenue, high ROI

The customers worth fighting to keep. They are above median revenue and above the 2.0x bar. Trade investment with them is genuinely earning its keep, and the relationship is structurally healthy. The action here is protect: lock the JBP, defend the terms, watch for early signs of erosion as the customer scales further and starts asking for more.

The trap with Stars is complacency. A Star one year is a Question Mark two years later if the customer's growth slows and the terms keep ratcheting upward. The customer-level G2N bridge for every Star should be reviewed annually with finance to make sure the realised pocket price is still tracking.

Cash Cows (top left): low revenue, high ROI

The customers that quietly hold up the portfolio's overall ROI. Below median revenue but above 2.0x. These are usually mid-tier accounts that have not had the negotiating leverage to extract aggressive off-invoice terms, and they grow steadily on a smaller base. Action: invest selectively. A small uplift in distribution support or JBP funding can move a Cash Cow into Star territory at a much lower investment than fixing a Question Mark.

Question Marks (bottom right): high revenue, low ROI

The portfolio's strategic problem. Big customers with sub-2.0x ROI. Almost always the result of accumulated terms over many JBP cycles, where the customer kept asking for incremental support and the manufacturer kept saying yes. Action: reset. The reset agenda is term-by-term, run through the JBP, with the explicit aim of moving the customer above 2.0x within two cycles. Walk-away is rarely the right call (the revenue is real and replacing it is hard) but the current term envelope cannot stand.

The most common Question Mark is the largest customer in the portfolio. The conversation is uncomfortable because the customer knows their leverage. The TIER chart is the asset that makes the conversation possible: when a CFO sees that 22 percent of revenue is running at 1.4x ROI while the rest of the portfolio runs at 3.1x, the case for the reset writes itself.

Drains (bottom left): low revenue, low ROI

The accounts that should not be in the portfolio in their current form. Below median revenue and below 2.0x. Action: fix or exit. The fix path is one renegotiation cycle to remove the most expensive legacy terms. The exit path is graceful, multi-cycle, and prioritises retaining shelf where it matters. The Drains quadrant is where the easiest dollar wins live, because the relationships are smaller, the political stakes are lower, and the recovery is mechanical.