Financial
ROI, ROAS, Break-Even ROAS, and Annualized ROI formulas
Distinguish Return on Ad Spend (Revenue / Spend) from true Gross-Profit ROI, solve for Break-Even ROAS (1 / GrossMargin), and annualize multi-year returns.
Why a 3.0x ROAS can still lose money (Break-Even ROAS = 1 / Margin)
ROAS=Revenue/AdSpend measures revenue per advertising dollar, not profit. At a constant 25% gross margin, a 4x ROAS covers advertising spend in this simplified contribution model.
Gross-profit ROI here is (Revenue*GrossMargin-AdSpend)/AdSpend. Annualized terminal-value return is (EndingValue/InitialCost)^(1/Years)-1 when there are no interim cash flows.
| Metric ($10k Spend, $40k Rev, 50% GM) | Formula | Result |
|---|---|---|
| Top-Line ROAS | =40,000 / 10,000 | 4.00x |
| Break-Even ROAS | =1 / 0.50 | 2.00x (Profitable!) |
| Gross-Profit ROI | =(40,000 * 0.50 - 10,000) / 10,000 | +100.0% (1.00) |
| Annualized ROI ($10k -> $17.28k in 3 yrs) | =(17280 / 10000)^(1/3) - 1 | +20.0% / yr |
Gross-Profit ROI, Break-Even ROAS, and Annualized ROI formulas
Compare these ratios alongside attribution quality and all relevant costs; they do not alone justify a budget decision.
=ROUND((B2 * C2 - A2) / A2, 4)Annualized ROI over N years
Compounds multi-year total return onto an apples-to-apples annual rate.
=ROUND((E2 / A2) ^ (1 / D2) - 1, 4)Additional worked calculation
Using the same initial input cells:
=ROUND(B2 / A2, 2)Additional worked calculation
Using the same initial input cells:
=ROUND(1 / C2, 2)Inputs and interpretation
Gross-profit ROI here assumes attributed revenue and a constant gross margin, and excludes any costs not in the model. ROAS is a revenue multiple, not profit. Break-even ROAS covers only the specified contribution and advertising costs. Annualization requires positive initial capital, nonnegative terminal value, positive years and no interim cash flows; it is nominal, not inflation-adjusted.
Try the example
Use the original values or change them to test your understanding.