CPM Cost Calculator

Excel workbook · $19 one-time

Ad Profit Planner (.xlsx)

Know before you spend: the ROAS, cost per order and cost per click your products can afford, and which campaigns are making or losing money.

$19Not available to buy online at the moment.

Sold to US buyers only, as a one-time purchase in US dollars, by Valcenra, LLC. Instant download after payment. Works in Excel, Google Sheets, Numbers and LibreOffice.

What's in the workbook

  • Unit economics: contribution per order and margin, break-even ROAS, target ROAS, break-even and target CPA, lifetime CAC, break-even CPC and max CPC.
  • Campaigns (up to 30): CPC, conversion rate, CPA, ROAS and profit after ads per campaign, with a status that flags "Losing money", "Profitable, below target" or "Above target".
  • Budget plan: the clicks, orders, revenue, ROAS and profit a monthly budget buys at seven different costs per click.

Every number is a live formula; the yellow cells are the inputs. It uses the same formulas as the free break-even ROAS and max CPC calculators.

Before you buy

It's a spreadsheet template, not an app or a subscription, and it gives planning estimates, not advertising, accounting or tax advice. If the file doesn't download or doesn't work, we'll fix it or refund you (see refunds); your rights under consumer law are not affected.