Gross-to-net sales bridge and incremental promotional ROI example

Separate a sales bridge from accounting recognition and campaign attribution

Subtract discounts, returns and rebates from gross sales for this simplified management bridge. The result is not automatically GAAP or IFRS recognized revenue: contract obligations, timing and other accounting judgments are outside this arithmetic example. All bridge inputs here represent the same reporting scope and deductions are positive amounts.

For the campaign scenario, incremental contribution is (campaign units - baseline units) × contribution per incremental unit. Subtract the separately entered campaign cost, then divide by that cost. Use a defensible counterfactual baseline; before/after growth alone does not demonstrate that the promotion caused the increase.

The unit contribution must be defined consistently with campaign cost: do not subtract discounts twice. Campaign cost B9 is independent of the bridge discount B3, though both happen to equal 30000 in the initial scenario. The example omits taxes, capital costs and long-term effects.

Net sales after the listed deductions

SUM(B3:B5) aggregates all contra-revenue deductions in a single auditable step.

=IF(OR(COUNT(B2:B5)<>4,MIN(B2:B5)<0),"Invalid inputs",B2 - SUM(B3:B5))

Incremental Promotional Lift ROI formula

With unit contribution 30 and campaign cost 30000, 1500 incremental units produce estimated ROI 50%; 500 incremental units produce -50%. A zero campaign cost makes percentage ROI undefined.

=IF(OR(COUNT(B6:B9)<>4,B6<0,B7<0,B8<0,B9<=0),"Invalid inputs",ROUND(((B7 - B6) * B8 - B9) / B9, 4))

Further reading

• Microsoft Support — SUM function
• IFRS Foundation — IFRS15 Revenue from Contracts with Customers