How to use the margin calculator
- Choose the two numbers you know: cost and price, or cost and the margin or markup you want, and so on.
- Enter them. Margin and markup are percents; cost and price are dollars.
- Read the margin, markup, cost, price and profit, with the formula written out underneath.
- Try other prices: change one number at a time and the answers update as you type, so you can test a price before you set it.
Margin vs markup: the formulas
- Profit = price - cost
- Margin = profit / price x 100
- Markup = profit / cost x 100
- Price from margin = cost / (1 - margin)
- Price from markup = cost x (1 + markup)
A worked example
A candle costs $60 to make and sells for $100. The profit is $40. Against the price that's a 40% margin; against the cost it's a 66.67% markup. Both describe the same sale.
Now suppose costs rise to $66 and you want to keep a 40% margin. The price is $66 / 0.60 = $110. If instead you kept the same 66.67% markup, you'd also land on $110, because the same margin always means the same markup. Where people go wrong is adding a 40% markup when they meant a 40% margin: $66 x 1.40 = $92.40, a margin of only 28.57%.
Markup vs margin chart
| Margin | Markup needed | Price for a $100 cost |
|---|---|---|
| 5% | 5.26% | $105.26 |
| 10% | 11.11% | $111.11 |
| 15% | 17.65% | $117.65 |
| 20% | 25% | $125.00 |
| 25% | 33.33% | $133.33 |
| 30% | 42.86% | $142.86 |
| 33.33% | 50% | $150.00 |
| 35% | 53.85% | $153.85 |
| 40% | 66.67% | $166.67 |
| 45% | 81.82% | $181.82 |
| 50% | 100% | $200.00 |
| 55% | 122.22% | $222.22 |
| 60% | 150% | $250.00 |
| 65% | 185.71% | $285.71 |
| 70% | 233.33% | $333.33 |
| 75% | 300% | $400.00 |
| 80% | 400% | $500.00 |
| 85% | 566.67% | $666.67 |
| 90% | 900% | $1000.00 |
How discounts eat into margin
A discount comes straight out of profit, so it cuts margin faster than it looks. The $60 candle sold at $100 has a 40% margin. Put it on sale at 20% off, $80, and the profit falls from $40 to $20: a 25% margin. You would need to sell twice as many candles at the sale price to earn the same profit.
Before running a sale, enter the cost and the sale price here to see the margin that's left. If it's below what covers your overhead, a smaller discount or a bundle may work better.
Margin and markup in Excel or Google Sheets
With the cost in column A and the price in column B, starting in row 2:
- Margin:
=(B2-A2)/B2 - Markup:
=(B2-A2)/A2 - Price for the margin in C2:
=A2/(1-C2)
Format the margin and markup cells as percentages, and fill the formulas down for the whole product list.
Margin on services and hourly work
The same math works for services. If an hour of a technician's time costs you $40 in wages and payroll costs and you bill $85 an hour, the profit is $45 an hour: a 52.94% margin and a 112.5% markup. To find the hourly rate for a target margin, enter the hourly cost and the margin you want. Agencies and freelancers can do the same with a project: the cost of the hours and outside spend against the fee.
Retailers sometimes talk about keystone pricing, which means doubling the cost. That's a 100% markup and a 50% margin: a $25 item sold for $50.
Using margin to set prices
Margin is the better number for planning because it ties straight to revenue: a 30% margin means 30 cents of every sales dollar is left to cover overhead and profit. Markup is handy at the counter because it starts from the cost you know. Pick one, use it consistently, and recheck prices whenever costs change. To see what your sales actually brought in, the bank statement converter turns statements into a spreadsheet you can total, and the invoice template bills at the prices you set.