Excel Template · Ecommerce & Sellers
Product Profit Calculator
Most products don't fail because they don't sell. They fail because they're not profitable. Know your real numbers before you launch.
What's included
- →
Profit per unit calculator — see exactly what you earn after every cost
- →
Real profit margin (%) — calculated automatically from your numbers
- →
Break-even calculator — know how many units you need to cover all costs
- →
Scenario analysis (Conservative / Realistic / Optimistic) — test pricing before launch
- →
Total cost breakdown (product, shipping, platform fees, packaging)
- →
Clean dashboard with key metrics — one view, no clutter
- →
Beginner-friendly "Start Here" guide — no Excel skills required
Who it's for
- ·
Etsy sellers launching a new product and unsure if it's actually profitable
- ·
Shopify and Amazon sellers who want to validate pricing before committing to inventory
- ·
Small business owners who suspect their margins are thinner than they thought
- ·
Product creators pricing for the first time and not sure where to start
- ·
Anyone who wants a clear answer to "will this product make money?" before they sell
About this template
Pricing a product by feel is how you end up losing money at scale. Most sellers set a price, start selling, and only discover the margin problem months later — after inventory, ads, and time are already committed. This spreadsheet reverses that order. Before you launch, it shows you your real profit per unit, your actual margin percentage, and exactly how many units you need to sell to break even. Enter your product cost, shipping, platform fees, and selling price — and in under a minute you'll know whether the product is worth pursuing. Includes scenario analysis (Conservative / Realistic / Optimistic) so you can stress-test your pricing before committing. Built for Etsy sellers, Shopify store owners, and anyone selling physical or digital products online.
What the data shows
Most small product sellers set prices based on competitor research, not their own cost structure — which means they often underestimate total costs and end up with margins below 20%, where small fluctuations in fees or shipping can eliminate profit entirely.
A 10% increase in price has more impact on profit than a 10% reduction in costs. Most sellers focus on cutting costs when the faster lever is pricing correctly from the start.
Platform fees on Etsy, Shopify, and Amazon typically range from 8% to 20% of the sale price when you include listing fees, transaction fees, payment processing, and shipping labels. Most sellers estimate 5–8% and are surprised by the real number.
Source: Etsy Seller Handbook — Fee structure 2024
Break-even analysis is the single most skipped step in product launches. Sellers who run the numbers before launch are significantly less likely to discount aggressively after launch — because they know exactly what margin they have to work with.
Spreadsheet vs mental math vs pricing apps — what actually works
| Method | Profit per unit | Break-even calc | Scenario testing | Works offline | Cost |
|---|---|---|---|---|---|
| Mental math / guessing | ⚠️ Rough | ❌ | ❌ | ✅ | Free |
| Pricing apps / tools | ✅ | ⚠️ Partial | ❌ | ❌ | Monthly fee |
| This spreadsheet | ✅ | ✅ | ✅ | ✅ | $7.99 |
Common questions about this topic
How do you calculate profit margin on a product?
Profit margin is calculated as: (Selling Price − Total Costs) ÷ Selling Price × 100. Total costs include the product cost (or cost of goods), packaging, shipping, and platform fees. For example, if you sell a product for $30 and total costs are $18, your profit margin is ($30 − $18) ÷ $30 × 100 = 40%. A common mistake is forgetting to include platform fees (Etsy, Shopify, Amazon) and payment processing — which together typically add 8–15% of the sale price to your cost structure.
What is a good profit margin for an Etsy or Shopify product?
For physical product sellers, a gross profit margin of 40–60% is generally considered healthy, though this varies by category. Below 30% leaves very little room for marketing spend, returns, or price adjustments. Digital product sellers often achieve margins of 80–95% since there are no manufacturing or shipping costs. The right target depends on your sales volume — high-volume, low-margin products can work at 20–30% if you're moving significant units.
How do I calculate break-even point for my product?
Break-even point (in units) = Fixed Costs ÷ (Selling Price − Variable Cost Per Unit). Fixed costs are costs you pay regardless of how much you sell (e.g., Etsy listing fees, software subscriptions). Variable costs change per unit sold (product cost, shipping, transaction fees). The break-even point tells you how many units you need to sell before you start generating profit — it's the minimum viable sales target for any product launch.
What costs should I include when pricing a product for Etsy or Shopify?
A complete product cost calculation should include: (1) cost of goods or manufacturing cost per unit, (2) packaging materials, (3) shipping costs (outbound, and returns if applicable), (4) platform fees — Etsy charges a $0.20 listing fee, 6.5% transaction fee, and ~3% payment processing; Shopify charges 2.9% + $0.30 per transaction on basic plans, (5) any advertising spend attributed to the sale, and (6) your time, if you're handmaking products. Most sellers underestimate costs by 15–25% by missing platform fee details.
How do you price a product for the first time?
Start with cost-plus pricing: calculate all costs per unit, add your target profit margin, and set the price. Then validate against the market — check 5–10 competitors selling similar products and see where your price lands. If your cost-plus price is above market rate, you have three options: reduce costs, accept a lower margin, or differentiate the product to justify a premium. If it's below market rate, you have room to capture more margin. Never set a price before knowing your full cost structure.
What is the difference between profit margin and markup?
Profit margin is calculated as a percentage of the selling price: (Profit ÷ Selling Price) × 100. Markup is calculated as a percentage of the cost: (Profit ÷ Cost) × 100. A product that costs $10 and sells for $15 has a 33% profit margin and a 50% markup. The distinction matters because platform fees and sales targets are usually expressed relative to selling price — so margin is more useful for product sellers than markup.
Should I use Excel or a pricing app for product calculations?
A spreadsheet gives you more control and flexibility than most dedicated pricing apps. You can customize it to your exact fee structure, add scenario analysis for different price points, and use it offline without a subscription. Most pricing apps show a simplified calculation without accounting for all your specific cost inputs. A well-designed spreadsheet that's already set up — formulas included — is faster to use and more accurate for your specific setup.
Frequently asked questions
Does this work for digital products?
Yes. If you sell digital products (printables, templates, presets), just enter $0 for shipping and manufacturing costs. The margin and break-even calculations work the same way.
Can I use this for multiple products?
Yes. The calculator is designed to be used per product — enter numbers for one product, read the result, then clear and repeat for the next. It's a decision tool, not a tracking database.
Are the platform fees accurate for Etsy?
The fees are simplified estimates based on Etsy's current published rates. You can adjust them in the spreadsheet to match your actual setup — including your country's VAT, Etsy offsite ad fees, or any other charges specific to your account.
Does it work with Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open with Google Sheets. All formulas and calculations work correctly.
Do I need any Excel skills to use this?
No. Just enter your numbers in the yellow input cells and the spreadsheet calculates everything automatically. A "Start Here" guide is included.
Is this a one-time purchase?
Yes. Pay once, download immediately, use forever. No subscriptions.
From the blog
Guide
How to Calculate Your Product Profit Margin Before You Launch
The math most sellers skip — and why it costs them after launch.
Read the guide →
Ready?
Product Profit Calculator · $7.99 one-time
Keep building your system
More templates that work well alongside this one.
Personal Finance
Budget & Personal Finance Tracker
Stop wondering where your money goes. Track every euro, every month — and finally take control of your finances.
$16.99
Personal Finance
The $1,000 Leak Detector
Find every hidden subscription draining your budget. See the real yearly cost. Cut what you don't need. It takes 30 minutes.
$2.99