The Ecommerce Profit & ROAS Calculator Pack — Eight linked calculators, every formula checked by recalculation

Eight calculators for what an online order really leaves you and what your ads have to do to keep it. Start with sheet 1 -- every fee is a blue cell, so enter your own plan's rates rather than trusting anyone's list. Sheet 2 gives your break-even ROAS: on the worked example it is 1.92, so a reported ROAS of 1.6 loses money on every order. Every formula in this workbook was recalculated and checked against an independent implementation before it shipped; see the Verification sheet.

What is in it

8 calculators, one per sheet. Overwrite the blue cells with your own numbers and everything else follows — nothing is locked, there are no macros, and it opens in Excel, Numbers, LibreOffice and Google Sheets.

• Contribution per order — What does one order leave you before advertising?
• Break-even ROAS and CPA — What ROAS do your ads need just to stop losing money?
• Target ROAS for a profit — What ROAS leaves the profit you want on each order?
• Returns and refunds — How much do returns raise the ROAS you need?
• Discount codes — What does a discount code do to margin and the ROAS you need?
• Free-shipping threshold — Is your free-shipping threshold high enough to pay for itself?
• First order and repeats — Can repeat orders pay back a first order bought at a loss?
• Ad budget to profit — What does a month of ad spend at your ROAS actually earn?

Every formula was checked

This pack contains 45 formulas. Before it was published, every one of them was recalculated by a spreadsheet engine and compared against an independent implementation of the same arithmetic written in Python. All 45 agreed to within a cent, and the workbook carries a Verification sheet saying so.

That is an unusual thing to be able to claim about a spreadsheet, and it is the main reason to buy this one rather than download a free template. A formula that looks right and is wrong is worse than no formula at all, because you will act on it.

What each calculator assumes

There is a sheet listing this, because a calculator that hides its assumptions is just a number generator:

• Fees are entered, not looked up: plans and processors differ and change their rates. Fees are charged on the whole order including the shipping charge.
• ROAS is measured on the same order revenue as sheet 1. If your ad platform counts revenue differently -- before shipping, or after discounts -- use the matching revenue here.
• Profit here is per order before overheads such as apps, subscriptions and your own time. Sheet 8 adds those.
• A return is refunded in full, including the shipping charge. Goods you can resell go back into stock at cost.
• Every order uses the code. If only some do, the effect is proportional to the share that does.
• Shipping cost does not change with the bigger order. Orders already above the threshold simply lose the charge, and orders that stay below it are unchanged -- weigh both against the share of orders that actually move up.
• Repeat orders arrive without further ad spend and contribute the same as the first. Use a repeat rate measured from your own past customers, over a period you are willing to wait.
• Every order in the period came from ads, and ROAS holds steady as the budget changes. If a bigger budget brings a lower ROAS, rerun this at the lower figure before scaling.

What this is not

Not financial, tax or legal advice, and not a recommendation to buy, sell, borrow or sign anything. These are calculators: they show what a choice costs, not which choice is right for you. Where a published rate or threshold is used it is the one current when the pack was built — those change, the arithmetic does not.

Honest about the format

One .xlsx workbook, 8 calculator sheets plus Start Here, Assumptions and Verification. Not a PDF, not a physical product, not a Notion template. Available immediately after purchase; nothing ships.

Refunds

If this isn't what you expected, email me within 30 days and I'll refund you in full — no need to explain. Because it's an instant download I can't take the file back, so I'd rather you just had your money back.