Templates / Promo P&L / ROI Calculator
Promo P&L / ROI Calculator
Eight inputs, one honest answer: does the promotion make money — and what uplift would it need to break even?
Download the template (.xlsx) Free · live formulas · no macros · no email required
Why this exists
Most promo evaluations flatter the promo, because they forget one line: the discount is paid on every unit sold during the promo, not only the extra ones. This calculator has that line built in — which is why its sample promo, at a 65% uplift, still loses money.
What's inside
- Eight inputs: baseline volume, duration, expected uplift, list price, discount, retailer funding, unit cost, fixed costs
- The full P&L: incremental margin, the discount cost on baseline volume, fixed costs, net promo profit
- ROI and breakeven uplift — the number to compare your expected uplift against before you sign
- A verdict cell that says it plainly: pays, or destroys value
The same analysis, computed live
Orkestar computes baseline, uplift and incremental profit per promotion from your actual sales file — measured after the fact, not assumed before it.
