Inputs
Formula used
How to use
- Enter your original price, cost, and per-order variable costs.
- Select a discount type and set the discount value.
- Estimate baseline units and promo units for the same time window.
- Add marketing and fixed campaign costs, plus return rates.
- Click Calculate, then review ROI, incremental profit, and breakeven.
Example data table
| Scenario | Discount | Promo Units | Marketing | Incremental Profit | ROI |
|---|---|---|---|---|---|
| Conservative | 15% | 170 | 350 | 420 | 70% |
| Expected | 20% | 210 | 450 | 560 | 101% |
| Aggressive | 25% | 260 | 650 | 510 | 68% |
Insights
Margin mechanics behind every promotion
Discount ROI starts with contribution margin: price minus cost of goods and variable fulfillment costs. When price drops, margin shrinks dollar-for-dollar, so volume must rise to compensate. The calculator separates baseline and promo net units using return rates, which is critical for categories where returns erase profit after shipping and handling. Use the “unit margin after” figure as the constraint: if it is near zero, small forecast errors can flip results negative.
Demand lift, cannibalization, and timing shifts
Promo units should represent incremental demand for the same time window, not total sales inflated by pull-forward. Compare baseline units with promo units and sanity-check lift against historical elasticity. If you expect cannibalization, reduce promo units or raise baseline to reflect sales you would have earned anyway. The incremental profit line shows whether the lift is large enough to cover campaign costs and discount dilution.
Marketing spend and blended acquisition costs
Treat marketing spend as the variable investment tied to the offer. If paid traffic is used, estimate a blended cost per incremental order and validate it against your channel performance. A promotion that boosts conversion but increases paid share can look profitable on revenue while losing on margin. The ROI percentage is most meaningful when campaign costs include media, creative, and operational work.
Breakeven units as an operational guardrail
Breakeven promo units translate financial feasibility into a practical target for inventory and pacing. If your expected promo units are below breakeven, reduce discount depth, lower marketing spend, or bundle to protect margin. If expected promo units exceed breakeven, you can set caps to avoid overspending while still securing positive incremental profit. Use breakeven to negotiate affiliate rates and coupon eligibility.
Scenario planning for safer decisions
Run at least three scenarios: conservative, expected, and aggressive. Increase return rate assumptions for impulse-driven discounts and adjust variable costs if you subsidize shipping. Track the sensitivity of incremental profit to small changes in promo units and discounted price; these two inputs dominate outcomes. Export results to compare offers across products, then standardize assumptions to keep decisions consistent across teams at scale consistently.