Skip to content

Margin and markup calculator

Enter any two of cost, price, profit margin and markup to get the rest, with the profit and the formula shown. Use it to price a product for a target margin, or to check what margin a price really gives.

Margin and markup calculator

Not uploaded.

$
$

Margin 40%, markup 66.67%.

Margin

40%

Markup

66.67%

Cost
$60.00
Selling price
$100.00
Profit
$40.00

Margin = profit / price = $40.00 / $100.00 = 40%
Markup = profit / cost = $40.00 / $60.00 = 66.67%

How to use the margin calculator

  1. Choose the two numbers you know: cost and price, or cost and the margin or markup you want, and so on.
  2. Enter them. Margin and markup are percents; cost and price are dollars.
  3. Read the margin, markup, cost, price and profit, with the formula written out underneath.
  4. 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

The markup needed for each margin
MarginMarkup neededPrice 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.

Questions

What's the difference between margin and markup?

Both compare profit with a price, but against different numbers. Margin is profit as a percent of the selling price; markup is profit as a percent of the cost. A product that costs $60 and sells for $100 has a $40 profit: a 40% margin, but a 66.67% markup.

How do I find the price for a target margin?

Divide the cost by one minus the margin. For a 40% margin on a $60 cost: $60 / (1 - 0.40) = $100. Choose Cost and the margin I want in the calculator to get the price directly.

What markup gives a 50% margin?

A 100% markup. Doubling the cost makes the profit equal to the cost, which is half the price. In general, markup = margin / (100 - margin), so a 40% margin needs a 66.67% markup and a 25% margin needs 33.33%.

How do I calculate margin in Excel?

With the cost in A2 and the price in B2, margin is =(B2-A2)/B2 and markup is =(B2-A2)/A2. Format the cells as percentages. The price for a target margin in C2 is =A2/(1-C2).

Is this gross margin or net margin?

Gross margin, when the cost you enter is the cost of the product or service itself. Net margin also subtracts overhead such as rent, wages and marketing, which you would work out across the whole business rather than per item.

Can margin be more than 100%?

No. Margin is profit divided by price, and profit can't be more than the price, so margin stays under 100%. Markup has no ceiling: selling a $10 item for $50 is a 400% markup but an 80% margin.

Last updated by Muhammad Yahya. How the tools are tested.