Break-Even ROAS Calculator: The Formula and Your Real Margin per Product
A ROAS of 3 sounds healthy until fees, shipping and returns take most of each sale. The break-even number is the one that tells you whether a campaign is making money, and it changes product by product.
Break-even ROAS = selling price ÷ contribution per order, where contribution is the price minus every cost that scales with the order: product cost, shipping and fulfillment, payment fees and an allowance for returns. Ad spend is left out, because it is what the ROAS measures. Any campaign that returns more than this multiple of its spend makes money on that product. The figure differs by product, and a store-wide average can hide the ones that lose money.
The formula, with a worked example
The example below is illustrative. It uses one product at a $60 selling price.
Selling price 60.00 - Product cost -18.00 - Shipping and fulfillment -9.00 - Payment fees (2.9% + $0.30) -2.04 - Returns allowance (5% of price) -3.00 = Contribution before ads 27.96 Break-even ROAS = 60.00 / 27.96 = 2.15x
At 2.15x, each dollar of ad spend returns exactly a dollar of contribution. Below it, the order loses money after the ad is paid for.
| Campaign ROAS | Ad spend per order | Profit per order after ads |
|---|---|---|
| 2.0x | $30.00 | -$2.04 |
| 2.15x (break-even) | $27.91 | $0.05, rounding |
| 2.5x | $24.00 | $3.96 |
| 3.0x | $20.00 | $7.96 |
A 3.0x ROAS looks strong, and this product does make money at it. But the margin is only $7.96 per order before overhead, and a small drop in conversion can take the campaign under break-even.
Why one store-wide number hides the problem
Most calculators ask for one price and one cost, then return one figure. That works for a single product. A store with a range of products has a range of break-even points. A premium item with a 55% contribution margin breaks even near 1.8x; a small accessory with heavy shipping and a higher return rate can need 3x or more. Average them, and the number looks fine while the accessory quietly eats the profit from the premium item.
So the useful version of the calculator runs per product, with the real order costs, and compares each product's break-even with the ROAS that product gets in the ad account.
Three things that move the number
- Discounts. A 20% code on a $60 product drops the price to $48. Fees and the returns allowance fall with it, but product cost and shipping do not, so contribution drops to about $16.91. Break-even rises to about 2.84x. Discounted orders need their own figure.
- Returns. Count the refunded revenue as lost, not just the cost of the return shipping. Your returns rate is probably higher for some products than others.
- Stale product costs. A supplier increase you have not entered makes every break-even figure too low, and the campaign looks better than it is.
The same calculation in a spreadsheet
Put one product per row with columns for price, product cost, shipping, a payment fee rate, a fixed payment fee and a returns rate. Then:
Contribution G2: =B2-C2-D2-(B2*E2+F2)-(B2*G2)
Break-even H2: =B2/I2
Here B is price, C product cost, D shipping, E the percentage payment fee, F the fixed fee, G the returns rate and I the contribution, so the break-even formula should read =B2/I2. Check the cell references against your own layout before you fill down.
Asking for it per product
The per-product version needs order-level data from the store: price after discount, product, fees and refunds. Quiriz reads a Shopify export or the Shopify connector, and it keeps the margin definition in Company Context, so the same calculation is used every time. In Excel with the Excel add-in:
=QUIRIZ.ASK("break-even ROAS by product this quarter, using contribution after fees and refunds", "table")
In Google Sheets, the same question uses the Sheets add-in with the function written without the dot. Check the products with the highest break-even first. The answer lists the inputs it used, so you can see which cost moved.
Where this stops. The answer is only as good as the cost data. If product costs were never entered, the calculation has nothing to work from, and it will say so rather than guess. Pair this with gross margin by SKU for the cost side, and with ROAS by channel to compare campaigns.
Break-even ROAS for every product
Try the questions on sample store data with no signup, then connect your Shopify store and ask for break-even by product.
Try Quiriz free →