ROAS vs break-even ROAS
ROAS is revenue from ads divided by what you spent on them. A ROAS of 4 means $4 of sales for every $1 of ads. But revenue is not profit: product cost, shipping and payment fees come out first.
Break-even ROAS is 1 divided by your contribution margin, the share of each sale left after those costs. With a 50% contribution margin you break even at a ROAS of 2. Anything above it is profit; anything below it loses money, however good the ROAS looks.
What is not included
Returns, discounts and your fixed costs such as software and salaries are left out. If your return rate is high, lower the revenue figure by it. Repeat customers who come back without ads make each paid order worth more over time; the E-commerce Financial Model handles that.
The formulas behind it
Every result cell is a plain spreadsheet formula, so you can check the math or rebuild it yourself.
| Cell | Result | Formula |
|---|---|---|
| B10 | Your ROAS | =B3/B2 |
| B11 | Contribution margin | =1-B5%-B7%-B6/B4 |
| B12 | Break-even ROAS | =1/B11 |
| B13 | Orders | =B3/B4 |
| B14 | Cost per order (CPA) | =B2/B13 |
| B15 | Break-even CPA | =B4*B11 |
| B16 | Profit after ad spend | =B3*B11-B2 |
