Profit Margin vs. Markup: The Exact Formulas, Differences & Conversion Tables
Why a 50% markup only yields a 33.3% margin, how to solve for retail price from target margin, and spreadsheet formulas.
- What is the formula difference between profit margin and markup?
- Why is a 50% markup not the same as a 50% profit margin?
- How do you calculate selling price based on a desired profit margin?
- How do you convert markup percentage to gross margin percentage?
- Can profit margin ever exceed 100%?
1. The Fundamental Mathematical Difference
The confusion between margin and markup causes substantial financial losses for new businesses. Both metrics measure gross profit, but they divide that profit by completely different baselines.
Profit Margin divides profit by the selling price (Revenue). Markup divides profit by the wholesale acquisition cost (COGS). Because selling price is almost always higher than acquisition cost, margin percentage is always mathematically lower than markup percentage for the same product.
2. The Core Formulas
Let Cost = wholesale acquisition cost, Revenue = retail selling price, and Profit = Revenue - Cost.
3. Markup to Margin Conversion Table
Use this reference table to instantly translate between retail markup applied to wholesale cost and the resulting gross margin realized on sales.
| Wholesale Cost | Markup % | Retail Selling Price | Dollar Gross Profit | Resulting Gross Margin % |
|---|---|---|---|---|
| $100.00 | 15.0% | $115.00 | $15.00 | 13.04% |
| $100.00 | 25.0% | $125.00 | $25.00 | 20.00% |
| $100.00 | 33.3% | $133.33 | $33.33 | 25.00% |
| $100.00 | 50.0% | $150.00 | $50.00 | 33.33% |
| $100.00 | 75.0% | $175.00 | $75.00 | 42.86% |
| $100.00 | 100.0% (Keystone) | $200.00 | $100.00 | 50.00% |
| $100.00 | 200.0% | $300.00 | $200.00 | 66.67% |
4. The $10,000 Retail Underpricing Trap
A business owner with $60,000 in inventory aims for a 40% gross margin. Confusing margin with markup, they multiply their costs by 1.40, setting total prices at $84,000 ($24,000 gross profit).
When calculating actual realized gross margin: $24,000 / $84,000 = 28.57% margin. They missed their target margin by over 11.4 percentage points, forfeiting $16,000 in gross profit due to an arithmetic syntax error.
5. Solving for Selling Price from Desired Margin
To achieve a target gross margin percentage, never multiply your cost by the margin. Instead, subtract the decimal margin from 1, and divide your cost by that result.
For a $50 cost with a target 40% margin: Price = Cost / (1 - Margin) = $50 / (1 - 0.40) = $50 / 0.60 = $83.33.
Frequently Asked Questions
Direct answers to the most common questions people ask online about this topic.
What is Keystone Pricing in retail?
Keystone pricing is a traditional retail convention of applying a 100% markup to wholesale cost, which doubles the purchase price and yields exactly a 50% gross profit margin.
Can gross profit margin ever be greater than 100%?
No. Since profit is revenue minus cost, even with $0 cost, profit equals revenue, resulting in 100% margin. Margin cannot mathematically exceed 100% unless costs are negative.
How do you convert markup directly into margin mathematically?
Margin % = (Markup % / (100% + Markup %)) * 100. For example, a 50% markup: 50 / (100 + 50) = 50 / 150 = 33.33% margin.