Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Business | Northwind Outdoor (sample) | Currency | $ | |||
|---|---|---|---|---|---|---|
| Product on Calculator | Trail jacket | Ad spend logged | 21,350.00 | |||
| Order value | 60.00 | Revenue logged | 79,189.00 | |||
| Contribution margin per order | 25.96 | Overall ROAS | 3.71 | |||
| Contribution margin % | 43.3% | Breakeven ROAS for what you spent | 2.70 | |||
| Breakeven ROAS | 2.31 | Profit after ads | 8,930.49 | |||
| Breakeven CPA | 25.96 | Log rows below breakeven | 7 | |||
| Target ROAS | 3.54 | Log rows below target | 9 | |||
| Target CPA | 16.96 | Products below breakeven | 1 | |||
| Your current ROAS | 2.90 | Lowest breakeven ROAS | Wool beanie | |||
| Verdict at your current ROAS | Above breakeven, below target | Highest breakeven ROAS | LED lantern | |||
| Product | Breakeven ROAS | Actual ROAS | ||||
| Insulated bottle | 2.19 | 3.38 | ||||
| Canvas backpack | 2.51 | 3.93 | ||||
| Wool beanie | 2.10 | 2.26 | ||||
| LED lantern | 4.04 | 3.91 | ||||
| Camp mug set | 2.66 | 4.68 | ||||
| Daypack bundle | 2.74 | |||||
| Week starting | Ad spend | Revenue | ROAS | Breakeven ROAS | Profit after ads | |
| 46300 | 3,360.00 | 13,695.00 | 4.08 | 2.70 | 1,872.77 | |
| 46307 | 3,550.00 | 14,095.00 | 3.97 | 2.70 | 1,835.11 | |
| 46314 | 3,680.00 | 13,752.00 | 3.74 | 2.70 | 1,583.75 | |
| 46321 | 3,630.00 | 13,059.00 | 3.60 | 2.70 | 1,374.84 | |
| 46328 | 3,580.00 | 12,717.00 | 3.55 | 2.70 | 1,276.55 | |
| 46335 | 3,550.00 | 11,871.00 | 3.34 | 2.70 | 987.47 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: Breakeven and target ROAS and CPA for the product on Calculator, the verdict at your current ROAS, ad spend and revenue from the log, overall ROAS against the breakeven for what you actually spent, profit after ads and the count of log rows below breakeven. Four charts: breakeven vs actual ROAS by product, the weekly ROAS trend against breakeven, where one order's value goes, and profit by monthly budget.
- Calculator: One product, per order. Type order value, product cost, shipping and packaging, payment fee % and fixed fee, returns % and other variable costs. It returns variable cost, contribution margin and margin %, breakeven ROAS, CPA and ACoS, profit per order at your target, target ROAS and CPA, breakeven and target CPC at your conversion rate, and a verdict on the ROAS you are running now.
- Scenarios: Four grids of 6 conversion rates by 8 CPC values: cost per order, ROAS, profit per order and profit per 1,000 clicks. Cells turn red below breakeven, yellow below target and green at or above it.
- Products: Up to 30 products with the same cost inputs. Each row returns margin, breakeven ROAS and CPA, target ROAS and CPA, the ad spend, revenue and ROAS from your log, a status (Below breakeven, Below target, On target, No ad data) and a rank from lowest to highest breakeven ROAS.
- Budget: Pick a product, a base budget, a CPC and a conversion rate, and list up to 8 monthly budgets. Each row shows clicks, orders, revenue, CPA, ROAS, contribution before ads and profit after ads, with CPC rising as you scale beyond the base budget. It names the budget where profit is highest.
- Actuals: A weekly log, 300 rows: week, product, channel, ad spend, orders and revenue. The grey columns give ROAS, CPA, the product's breakeven and target ROAS, the revenue needed to break even, profit after ads and an Alert for rows below breakeven or below target.
- Settings: Business name, currency symbol, your target profit margin after ads, the Monday of your latest reporting week and a list of up to 10 ad channels for the dropdown.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most breakeven ROAS calculators take one number, a gross margin, and divide one by it. This one builds the margin from the costs that really come with an order, then keeps going: it compares every product, tests conversion rate and CPC together, shows what happens when CPC climbs as you raise the budget, and checks your real weekly results against the breakeven of the product that earned them. The sample is a small outdoor shop over six weeks in October and November 2026, with one product below breakeven so you can see the alerts.
How do I calculate breakeven ROAS in Excel?
Work out the contribution margin per order first: order value minus product cost, shipping and packaging, payment fees, returns and other variable costs, leaving ad spend out. Breakeven ROAS is order value divided by that margin, which is the same as one divided by the margin percent. Breakeven CPA is the margin itself, the most you can pay for an order and still break even.
In the sample, a 60.00 order costs 34.04 to fill before ads: 21.00 product, 6.50 shipping and packaging, 1.74 plus 0.30 in payment fees, 3.00 in returns and 1.50 other. That leaves a contribution margin of 25.96, or 43.3% of the order. Breakeven ROAS is 60.00 / 25.96 = 2.31 and breakeven CPA is 25.96. Run ads at 2.31 or less and each order loses money.
What is a good target ROAS, and how is it different from breakeven?
Breakeven only covers the ads. A target ROAS leaves profit after them. Take the profit margin you want as a share of revenue, subtract it from the contribution margin percent and divide one by the result. Equivalently, target CPA is the contribution margin less the profit you want per order.
With a 15% target margin on the sample order, you keep 9.00 per order, so target CPA is 16.96 and target ROAS is 60.00 / 16.96 = 3.54. At the 2.9 ROAS typed on the sheet the verdict reads Above breakeven, below target, and each order earns about 5.27 after ads. Your target margin sits on Settings, so you can see how the answer moves when you ask for more or less profit. Fixed costs such as rent and salaries are not in the margin, so treat breakeven as a floor.
How do conversion rate and CPC change profit?
ROAS and CPA both depend on the pair. CPA is CPC divided by conversion rate; ROAS is order value times conversion rate divided by CPC. The Scenarios sheet works every pair out for you. In the sample, a 1.00 CPC with a 2.5% conversion rate costs 40.00 per order, over the 25.96 breakeven, and loses money. At 0.60 CPC and a 3% conversion rate the CPA is 20.00, ROAS is 3.00 and 1,000 clicks earn 178.80 after the clicks are paid for.
The Calculator also turns the CPA limits into CPC limits at your conversion rate: 0.65 to break even and 0.42 to hit the 15% target. Use these as the ceiling in your bidding. For the break-even volume of a whole business see the break-even calculator, and to split a budget across channels try the media plan budget template.
How to use it
- On Settings type your business name, the profit margin you want after ad spend (as a percent of revenue), the Monday of your latest reporting week, and your ad channels.
- On Calculator type the numbers for one product, per order: average order value, product cost, shipping and packaging you pay, payment fee, returns and other variable costs. Read breakeven ROAS, breakeven CPA, target ROAS and the maximum CPC.
- On Scenarios change the conversion rates across the top and the CPC down the side to see CPA, ROAS and profit for every pair. Red cells lose money.
- On Products list every product you advertise (up to 30) with the same cost inputs. The grey columns rank products by breakeven ROAS and compare it with what the product really returned.
- On Budget pick a product, a conversion rate and a CPC, then list monthly budgets to see the orders, revenue and profit you can expect, and the budget where profit peaks.
- On Actuals add one row per product per week: spend, orders and revenue. The Alert column flags every row below breakeven or below target, and Dashboard shows the totals, the weekly trend and the charts.
Before you start:
- Capacity: 30 products, 300 weekly log rows, 10 ad channels, 6 conversion rates x 8 CPC values in the scenario grid and 8 budget levels.
- Contribution margin per order = order value less product cost, shipping and packaging, payment fees, returns and other variable costs. Ad spend is not included: it is what the margin pays for.
- Breakeven ROAS = order value / contribution margin. Breakeven CPA = contribution margin per order. Below them the ads lose money on the first order.
- Target ROAS = order value / (contribution margin - order value x target profit margin). Target CPA is the contribution margin less the profit you want per order.
- Returns are treated as a percent of order value lost (refund less any stock you resell). Use your own figure, and one currency throughout.
- Fixed costs (rent, salaries, software) are not in the margin. Breakeven here means the ads pay for themselves; a business still needs profit above it to cover fixed costs.
- The budget what-if raises CPC by the percentage you set for every +100% of spend above the base budget. It is a planning assumption, not a forecast.
- Weekly log dates should be the Monday of the week. The dashboard trend shows the six weeks ending with the week on Settings.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this breakeven ROAS calculator free?
Yes. Download it, use it for your own shop or your clients and change anything you like. There is nothing to sign up for to open the file.
Does it work in Google Sheets?
Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS and INDEX/MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. Upload the file to Google Drive and open it with Sheets.
What is the formula for breakeven ROAS?
Order value divided by contribution margin per order, or one divided by the contribution margin percent. Contribution margin is order value less product cost, shipping, payment fees, returns and other variable costs, with advertising left out.
What is the difference between breakeven ROAS and target ROAS?
Breakeven ROAS is the return at which the ads exactly pay for themselves. Target ROAS is the return you need to also keep the profit margin you chose on Settings, so it is always higher. Aim campaigns at the target and treat breakeven as the floor that triggers an alert.
Why use contribution margin and not gross margin?
Gross margin usually counts only product cost. Shipping, payment fees and returns also rise with every order, so leaving them out makes breakeven look easier to reach than it is. If you prefer a plain gross-margin view, set those inputs to zero.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for paid ads: budget, performance and reports
More free templates for: Marketing and advertising
More free templates
- Ad budget media plan across platforms
- Ad campaign performance tracker
- Ads A/B test log
- Ad agency client management and reports
- UTM link builder and campaign naming
- Ad account audit checklist
- Ads creative production calendar
- Ads lead quality tracker
- Media buyer rules sheet: ad formulas, scaling rules and testing discipline
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Construction Project Tracker for Excel
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Student attendance sheet