Gross Margin Calculator: The Formula
Gross margin is gross profit as a percentage of the selling price. The formula is:
Gross margin % = (selling price - cost) / selling price x 100
Gross profit is the money left from a sale after the cost of the goods: gross profit = selling price - cost. To set a price that hits a target margin, divide the cost: price = cost / (1 - margin). Multiplying cost by (1 + margin) is the most common pricing mistake, because that applies a markup.
Worked example: a wholesale case
Case cost from the supplier: $36.00Selling price to your customer: $48.00Gross profit = 48.00 - 36.00 = $12.00Gross margin = 12.00 / 48.00 x 100 = 25%
A $36 case sold at $48 earns a 25% gross margin (a 33.3% markup).
Worked example: pricing a retail unit to a target margin
Unit cost: £12.00 ex VAT, target margin: 45%Price ex VAT = 12.00 / (1 - 0.45) = £21.82Shelf price with 20% VAT = 21.82 x 1.2 = £26.18
Price the unit at £26.18 inc VAT (or round up to £26.99) to keep a 45% margin.
Margin and markup describe the same profit against different bases, so a 50% margin is a 100% markup. If you set prices from cost, see markup vs margin on the markup calculator, with conversion tables in both directions.
Profit Margin Calculator: Gross vs Net
"Profit margin" can mean either of two numbers, and this calculator works out the first. Gross profit margin is price minus the cost of the goods. Net profit margin also takes off overheads such as wages, rent, delivery and software, so it is always lower. A distributor can run a healthy 25% gross margin and still make 3% net. Use gross margin to price products and net margin to judge the business.
To get a net figure for a whole month, enter total sales as the selling price and total costs (goods plus overheads) as the cost. The margin the calculator shows is then your net profit margin for that month.
Margin With VAT (UK and EU)
VAT is collected for the tax authority, so it is never part of your margin. If your selling price includes VAT, divide by 1.2 (at 20%) before you work out margin: a £120 shelf price is £100 net. If you are VAT registered you reclaim the VAT on purchases, so enter cost ex VAT too. Pick GBP or EUR above and tick "Selling price includes VAT" to do this automatically.
Margin Math on Real Invoices
Distributors and retailers run this math on every line of every vendor invoice. A price change of a few cents per case moves the margin on thousands of units. When freight or duty is involved, work from landed cost, not invoice cost, or your margin will look better than it is. To turn a cost into a shelf price with .99 endings, use the retail price calculator. And if you key those invoice lines by hand, you can extract every line from a vendor invoice automatically.