Markup Calculator

Sets a selling price from a cost and a markup or target margin, and shows the same profit both as a markup and as a margin. Enter any two of cost, price, markup, margin and profit to get the rest.

How to use

1. Enter any two of "Cost", "Selling price", "Markup", "Margin" and "Profit"; the rest are worked out. The two fields you typed in last are used.
2. Under "Margin left after a discount", enter a "Discount" to see the discounted price and margin, or a "Margin to keep" to see the largest discount allowed.
3. For many products, paste a list into "Costs" under "Many products at once", then choose "Apply as", "Rate" and "Price ending".
4. Press "Copy table" to paste the prices into a spreadsheet.

How it works

• Profit = price − cost. Markup = profit ÷ cost. Margin = profit ÷ price.
• From a markup, price = cost × (1 + markup). From a target margin, price = cost ÷ (1 − margin).
• The "Markup to margin table" converts markups from 10% to 200% and margins from 5% to 80%.
• The pasted list is saved only in this browser on this device.

Questions and answers

What is the difference between markup and margin?

Both divide the same profit, markup by the cost and margin by the price. An item that costs 100 and sells for 150 has a 50% markup and a 33.33% margin, so the markup is always the larger number.

How do I add a 30% margin to a cost?

Divide the cost by 0.7: a cost of 70 gives a price of 100. Adding 30% to the cost is a 30% markup, which is a margin of about 23.08%.

What margin is a 100% markup?

50%. When you sell at twice the cost, half of the price is profit.

How much margin is left after a discount?

The discount comes straight out of the profit, so the margin falls faster than the discount rate. The largest discount without a loss is equal to the current margin.