Margin Percent Calculator: Formula & How to Use

This margin percent calculator works out the percentage profit margin on a sale. You enter the cost price and the selling price, and it returns the margin as a percentage, along with the profit amount. The result tells you what share of each sales dollar (or pound, euro, etc.) is left after covering the cost of the item.

Formula

The margin percent formula is:

Margin % = ((Selling Price − Cost Price) ÷ Selling Price) × 100

Where:

• Selling Price – the amount the customer pays (in your currency).
• Cost Price – what you paid to acquire or produce the item (same currency).
• Margin % – the profit expressed as a percentage of the selling price.

This is different from markup, which uses the cost price as the denominator. Margin is always based on the selling price, so it directly answers “how much of my revenue is profit?”

Worked Example

Using the calculator defaults: cost price = $80, selling price = $100.

1. Subtract cost from selling price: $100 − $80 = $20 profit.
2. Divide profit by selling price: $20 ÷ $100 = 0.20.
3. Multiply by 100 to get percent: 0.20 × 100 = 20%.

The calculator shows a margin of 20.00% and a profit of $20.00. This matches the formula exactly.

When to Use Margin Percent

Margin percent is used in retail, wholesale, and any business that resells products. It helps you:

• Set selling prices that achieve a target profit.
• Compare profitability across different products or services.
• Evaluate discounts – a 10% discount reduces margin more than you might think.
• Track whether your pricing covers overhead and still leaves profit.

For example, if you sell handmade goods and your materials cost $15, and you sell for $25, your margin is (25−15)/25 = 40%. That means 40% of the selling price is profit before other expenses like shipping or fees.

How to Read the Result

A higher margin percent means more profit per sale relative to the price. A margin of 0% means you sell at cost – no profit. A negative margin means you lose money on each sale. For instance, if you buy for $50 and sell for $40, your margin is (40−50)/40 = −25%, a loss.

Margin percent is not the same as markup. A 50% markup (cost + 50% of cost) equals a 33.3% margin. Many beginners confuse the two, which leads to pricing errors. Use this calculator for margin, not markup.

Common Mistakes and Pitfalls

• Using cost instead of selling price – the most common error. Margin is always divided by selling price, not cost.
• Mixing units or currencies – both prices must be in the same currency and unit (e.g., dollars, not one in dollars and one in euros).
• Ignoring other costs – this calculator only uses the two numbers you enter. If you have shipping, fees, or overhead, subtract them from the selling price first or include them in the cost.
• Rounding too early – keep at least two decimal places during calculation to avoid rounding errors in the final percent.

For example, if you enter cost = $33 and selling price = $55, the margin is (55−33)/55 = 40%. If you round 55−33 to 22 and then divide, you still get 40%, but with more complex numbers rounding early can shift the result by a few tenths of a percent.

Limitations of This Calculator

This calculator gives a pure mathematical result based on the two numbers you provide. It does not account for:

• Variable costs like shipping, transaction fees, or labor.
• Fixed costs like rent, utilities, or salaries.
• Taxes, which vary by jurisdiction.
• Discounts or bulk pricing that change the effective selling price.

To get a true profit margin for your business, include all costs associated with selling the item. For a simple product margin, this calculator is accurate and sufficient.

Frequently Asked Questions

What is the difference between margin and markup?

Margin is profit as a percentage of the selling price. Markup is profit as a percentage of the cost price. For example, if cost is $80 and selling price is $100, margin is 20% and markup is 25%. They are related but not interchangeable.

How do I calculate margin percentage in Excel?

In Excel, if your cost is in cell A1 and selling price in B1, use the formula: =(B1-A1)/B1*100. Format the cell as a percentage if you prefer, but the formula gives the numeric percent.

Can margin percent be over 100%?

Yes, if the selling price is more than double the cost. For example, cost $10, selling price $30 gives a margin of (30−10)/30 = 66.7%, which is under 100%. To exceed 100%, the selling price must be more than twice the cost, but the margin approaches 100% as the selling price grows relative to cost.

What is a good margin percent?

It depends on the industry. Grocery stores often work on 1-3% margins, while software or luxury goods can have 80%+ margins. There is no universal “good” number – it depends on your costs, volume, and market.

How do I set a selling price to get a target margin?

Rearrange the formula: Selling Price = Cost ÷ (1 − Target Margin %). For example, if cost is $80 and you want a 30% margin, selling price = 80 ÷ (1 − 0.30) = 80 ÷ 0.70 = $114.29.

Does margin percent include tax?

No, margin is typically calculated on pre-tax amounts. Sales tax is collected on top of the selling price and remitted to the government, so it is not part of your profit margin.

Related

• Tube Curve Calculator: Bending Guide & Formula
• Unit Learning Curve Calculator: How to Use It
• Test Curve Calculator: Grade Scaling Explained

in cost | Cost price | $ | 80 | 0
in sell | Selling price | $ | 100 | 0
out margin | Margin percent | % | (sell - cost) / sell * 100 | 2
out profit | Profit amount | $ | sell - cost | 2