# Breakeven ROAS Calculator Excel (Free Template)

> Free breakeven ROAS calculator for Excel and Google Sheets: contribution margin, breakeven CPA, target ROAS, CPC scenarios, budget what-if and ROAS alerts.

Source: https://softwiro.com/templates/ad-breakeven-roas-calculator
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Breakeven ROAS Calculator for Excel

A free breakeven ROAS calculator that starts from your product economics, not from a rule of thumb. You type what an order is worth and what it costs you: product cost, shipping and packaging, payment fees, returns and any other variable cost. The sheet returns your contribution margin per order, your breakeven ROAS and breakeven CPA, and the target ROAS and CPA that leave the profit margin you choose. Then it goes further: a conversion rate by CPC grid shows which pairs make money, a product sheet compares breakeven ROAS across your range, a budget what-if projects orders and profit as you scale, and a weekly log flags every week where your real ROAS fell below breakeven. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-ad-breakeven-roas-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-ad-breakeven-roas-calculator-blank.xlsx)

Excel file (.xlsx) · 84 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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](https://softwiro.com/tools/break-even), and to split a budget across channels try the [media plan budget template](https://softwiro.com/templates/ads-media-plan-budget).

## How to use it

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-ad-breakeven-roas-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-ad-breakeven-roas-calculator-blank.xlsx)

Excel file (.xlsx) · 84 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One product's economics at a time, typed by hand | Every product and variant costed from your real catalog and supplier prices |
| You paste ad spend and revenue into the log each week | Ad platforms and your store connected, with results up to date |
| The Alert column is something you have to open the file to see | Alerts sent to the owner or media buyer by message or email when ROAS crosses breakeven |
| One file edited by one person at a time | A shared program with a login and permissions for each user |
| Scenarios and what-ifs use the formulas as built | Rules for your own fee structure, bundles, discounts and customer lifetime value |

### Extra features in the app

- Margins read from your store orders, with product cost, shipping and fees filled in for you
- Ad spend and revenue pulled in from each ad platform with no typing
- An alert to the team the moment a campaign's ROAS drops below its breakeven
- A breakeven for every product, variant and bundle, updated when costs change
- Budgets per campaign with pacing against the plan
- Logins for each team member, so media buyers see their accounts and owners see everything

[Ask for your custom system](https://softwiro.com/contact)

## 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](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](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](https://softwiro.com/templates/for-ads)

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

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
