Profit Margin Calculator Spreadsheet, Product Pricing, Cost and Markup Calculator, Excel and Google Sheets Template, Digital Download

Excel and Google Sheets tool. Not a printable, not party decor.

Compare up to 5 supplier quotes side by side and see which one actually makes money after duty, freight, platform fees and ad spend. Instant Excel download.

WHAT THIS SOLVES

You have three quotes from three factories. One is FOB, one is EXW, one is DDP. Different MOQs, different lead times. The cheapest unit price is almost never the cheapest landed cost, and you find that out after the money is gone.

This sheet puts all five suppliers on one screen and tells you which one to order from.

WHAT IT CALCULATES

•⁠ ⁠Landed cost per unit (freight, duty, insurance, inspection)

•⁠ ⁠Net profit per unit after platform fee, fulfilment, returns and advertising

•⁠ ⁠ROI and net margin

•⁠ ⁠Break-even sell price

•⁠ ⁠Break-even ROAS

•⁠ ⁠Maximum purchase price you can accept and still hit your target

•⁠ ⁠Automatic BUY / CAUTION / DON'T BUY status per supplier

WHAT MAKES IT DIFFERENT

•⁠ ⁠Duty basis switch: FOB for US customs, CIF for the EU, UK, Australia and Canada. Most calculators only do one and never tell you which.

•⁠ ⁠Any supplier whose MOQ is above your order quantity is excluded from the ranking automatically, so the top-ranked supplier is always one you can actually order from.

•⁠ ⁠The dashboard gives you one answer, not twenty numbers.

WHAT YOU GET

•⁠ ⁠1 Excel file (.xlsx) with 3 tabs: instructions, calculator, dashboard

•⁠ ⁠Works in Excel on Windows and Mac, and in Google Sheets

•⁠ ⁠No add-ins, no macros, no subscription

•⁠ ⁠Sample data included. Clear it and enter your own.

HOW IT IS SET UP

Blue text on yellow cells are yours to edit. Formula cells are locked so you cannot break them by accident, with no password if you want to change the structure.

DELIVERY AND REFUNDS

Digital download only. No physical item will be shipped. Your file is available immediately after payment. Because files are delivered instantly, all sales are final.

If something does not work the way you expected, message me. I will fix it and send you the updated file

---

Built with AI assistance, then tested and corrected by me.

Every formula in this file was recalculated and stress-tested

before it shipped, including blank-sheet and partial-data

scenarios.