Free · Works in FLYNT Sheets

Product Profit Margin Calculator Template

A real spreadsheet for pricing a product correctly, not a rule-of-thumb guess. Enter a product's unit cost and markup percentage, and it calculates selling price, gross profit per unit, and gross margin automatically — plus monthly gross profit at your expected sales volume. Gross profit and gross margin here cover cost of goods only; they do not account for shipping, payment-processing fees, advertising, returns, or any other selling expense, so treat the result as your product-level gross profit, not your net business profit.

Try it free
Unit Cost ($)$12.00
Markup (%)60%
Selling Price ($)$19.20
Gross Profit per Unit ($)$7.20
Gross Margin (%)37.5%
Units Sold per Month150
Monthly Gross Profit ($)$1,080.00

Green rows calculate automatically from the values above them — change any number in FLYNT Sheets and they update.

Who it's for

Small online retailers and e-commerce sellers who want to see markup (against cost) and gross margin (against price) as two distinct, correctly-labeled numbers before setting a price.

Key features

  • Unit cost and markup percentage fields
  • Selling price calculated automatically from cost and markup
  • Gross profit per unit calculated at your actual selling price
  • Gross margin calculated correctly — against price, not cost, so it's never confused with markup
  • Monthly gross profit calculated automatically at your expected sales volume
  • Exports to a real .xlsx file

How to use it

  1. Click "Use this template" to open it in FLYNT Sheets
  2. Enter the product's real unit cost
  3. Enter the markup percentage you're applying (or considering)
  4. Enter your expected units sold per month
  5. Review the selling price, gross profit per unit, and gross margin — then duplicate the sheet for every other product

What's included

  • Unit cost, markup percentage, and units sold per month fields with example numbers
  • Selling price, gross profit per unit, gross margin, and monthly gross profit formulas already wired up

Common use cases

  • Pricing a new product before it launches
  • Re-checking a product's gross margin after a cost increase
  • Comparing two products to see which one actually has a better margin, not just a higher markup

Frequently asked questions

What's the difference between markup and gross margin?
Markup is profit as a percentage of cost; gross margin is profit as a percentage of selling price. They're never the same number — a 60% markup on a $12 cost gives a $19.20 price, but that's only a 37.5% gross margin. This template calculates both correctly so you don't confuse them.
Does this calculate my net business profit?
No — gross profit and gross margin here cover cost of goods only. They don't account for shipping, payment-processing fees, advertising, returns, or other selling expenses, so this is your product-level gross profit, not your net business profit.
Is this free to use?
Yes, on FLYNT's free plan — no credit card required.
Try it free

Related