Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
E-commerce 3 Excel tabs included 9 min read Updated Jan 2026

Break-even ROAS & target CPA calculator

Find the exact ROAS where paid acquisition stops losing money, the CPA ceiling for your profit target, and the spend level where diminishing returns take over.

Typical profitable ROAS
2.5–4.0x
Target LTV:CAC
3:1
Marginal ROAS decay
4–9% per step
Advertisement
Advertisement

The break-even ROAS formula

Break-even ROAS is the revenue-to-ad-spend ratio at which you make exactly zero profit. It is not a benchmark you copy from an industry report — it is a function of your own unit economics, and it changes when your COGS, shipping or payment fees change.

The formula is deceptively simple: average order value divided by contribution margin per order. The subtlety is in what counts as contribution margin. It is price minus every variable cost — COGS, shipping, fulfilment, payment processing, marketplace fees — but before advertising and before fixed overhead.

Break-even ROAS and target CPAlive formula
Contribution margin = AOV − COGS − Shipping − (AOV × Fee%) − Other variable

Break-even ROAS = AOV ÷ Contribution margin
Target ROAS     = AOV ÷ (Contribution margin − Target profit per order)
Max CPA        = Contribution margin − Target profit per order
A ROAS below your break-even number means every incremental order destroys cash. There is no volume at which that improves.
Break-even ROAS at different contribution margins on a $68 AOV
Contribution marginCM per orderBreak-even ROASMax CPA at $12 target profit
70%$47.601.43x$35.60
58%$39.441.72x$27.44
45%$30.602.22x$18.60
35%$23.802.86x$11.80
25%$17.004.00x$5.00

Adjusting the threshold for repeat purchases

The day-one break-even ROAS is the right threshold for a business with no repeat purchases. For a business where customers come back, the correct threshold is lower — because the first order does not have to pay for the acquisition on its own.

The adjustment is straightforward: divide the break-even ROAS by your twelve-month repeat multiplier. If the average customer places 1.35 orders in the first year, your effective break-even ROAS falls by 26%. This is why subscription and consumable businesses can profitably run ROAS figures that would bankrupt a one-off product brand.

  • A 1.35x repeat multiplier lowers break-even ROAS from 1.72x to 1.27x in the example above.
  • LTV-adjusted thresholds require trusting your retention curve — do not adjust on hope.
  • Cash flow still follows day-one economics: you fund ads now and collect repeat revenue later.
Advertisement

Diminishing returns and the profit-maximising spend level

Every ad account has a point where additional spend buys worse returns. Audience saturation, frequency caps and competition for the same impressions all push marginal ROAS down as spend increases. The third tab of the workbook models this explicitly with a decay rate per spend increment.

The practical consequence: the spend level that maximises revenue is almost never the level that maximises profit. The right question is not "how much can I spend?" but "at what spend does the next dollar of ads earn less contribution than it costs?"

Marginal decay example — $25,000 baseline spend, 2.80x ROAS, 6% decay per step
SpendMarginal ROASMonthly profit
$25,0002.80x$6,800
$31,2502.63x$7,900
$37,5002.47x$8,400
$43,7502.32x$8,300
$50,0002.18x$7,600

Profitable on paper, insolvent in practice

Ad platforms charge daily or weekly. Revenue arrives from the payment processor two to five days later, and inventory must be purchased before any of it. A business with a positive contribution margin can still run out of cash while growing, because growth consumes working capital.

The scaling tab quantifies this: it multiplies the incremental spend by thirty days to estimate the working capital the growth requires, and flags when that exceeds half your current monthly spend. If you cannot fund it, the constraint is financing, not advertising.

  • Cash gap = (ad spend + inventory cost) − collections, measured over your payment terms.
  • A 30-day buffer on incremental spend is a reasonable planning assumption for most DTC brands.
  • Slow-paying channels (marketplaces with 14-day remittance cycles) widen the gap further.

Reading the campaign model: where to cut and where to scale

The second tab breaks a monthly budget across six channel archetypes — brand search, non-brand search, Meta prospecting, Meta retargeting, short-form video and affiliate — each with a typical ROAS profile.

Two patterns show up almost universally. Brand search carries the highest ROAS and the least incremental value, because those customers were already searching for you. Prospecting carries the lowest ROAS and the most incremental value, because those customers did not know you existed. Judging both by the same ROAS threshold leads to starving prospecting and over-funding brand search — a slow path to a shrinking business.

Typical channel ROAS profiles
ChannelTypical ROASIncrementalityRole in the mix
Brand search6–10xLowHarvest demand, protect the brand
Non-brand search2.5–4xMedium–highCapture active intent
Meta prospecting1.6–2.4xHighCreate demand
Meta retargeting4–7xMediumConvert known interest
Short-form video1.4–2.2xHighCheap reach, variable quality
Affiliate / influencer2–4xMediumBorrowed credibility

How to use this tool

  1. Enter your real order economics. AOV, COGS, shipping and payment fees per order. Pull these from your last 90 days of orders rather than from a price list — refunds and discounts change the effective numbers.
  2. Set a profit target per order. This converts break-even ROAS into target ROAS. A common starting point is 10–15% of AOV, which leaves room for fixed costs and profit.
  3. Compare against your current blended ROAS. If your current ROAS is below break-even, the answer is to pause and fix creative or pricing — not to spend more. The tool says so explicitly.
  4. Download and model the scaling ceiling. The workbook includes a spend ladder with marginal decay, so you can see where additional budget stops adding profit and start funding a new channel instead.

What is inside the download

A threshold tab with the ROAS-to-profit matrix, a campaign-level profit model across six channel archetypes, and a scaling ladder that models marginal ROAS decay to find the profit-maximising spend level.

  • ROAS & CAC Matrix — a separate worksheet in break-even-roas-model.xlsx.
  • Campaign Model — a separate worksheet in break-even-roas-model.xlsx.
  • Scaling Limits — a separate worksheet in break-even-roas-model.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
CAC payback targetUnder 12 months keeps growth largely self-funding; beyond 18 months it requires external capital.≤ 12 months (6 ideal)Market surveyBenchmarkitSaaS metrics benchmarksOpen source
Card processing feeStandard online card rate. The fixed component makes sub-$20 price points structurally harder.2.9% + $0.30Vendor rate cardStripePricingOpen source
Target net margin (marketplace)Below 10% leaves no resilience to a fee change or a returns spike.15–25%Rule of thumbNo authoritative source — industry convention
LTV:CAC targetVenture-standard threshold. Measured in contribution dollars, never in revenue.3:1Market surveyNo authoritative source — industry convention

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Divide average order value by contribution margin per order. Contribution margin is revenue minus all variable costs (COGS, shipping, fulfilment, payment and marketplace fees) but before advertising and fixed overhead. On a $68 AOV with $39.44 of contribution margin, break-even ROAS is 1.72x.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models