A 50% markup is not a 50% margin. Here's the math and why confusing them costs businesses real money.
A product costs $40 to make and sells for $60. The profit is $20. Now:
The denominator changes. Markup divides by cost; margin divides by sell price.
| Markup | Margin |
|---|---|
| 10% | 9.1% |
| 25% | 20% |
| 33.3% | 25% |
| 50% | 33.3% |
| 100% | 50% |
| 200% | 66.7% |
Notice: margin is always lower than markup for the same dollar profit, and they only converge as both approach zero.
Imagine a manager says “we need 40% margin on every product”, but the buying team interprets it as “mark up cost by 40%”. They buy at $60, sell at $84. The actual margin is 24 ÷ 84 = 28.6%, not 40%. To hit 40% margin, sell price would need to be $100 (a 66.7% markup).
No. A 50% margin requires a 100% markup. A 50% markup yields a 33.3% margin. Always confirm which term someone is using.
Margin = markup ÷ (1 + markup/100). A 50% markup becomes 50 ÷ 1.50 = 33.3% margin.
The four percentage formulas in Excel: percentage of a number, percentage change, percent of total, and formatting cells...
The same formulas work in Google Sheets as in Excel, with a few keyboard shortcut and formatting differences.
The percent key on different calculators does different things — here's what to expect on phone, desktop, and four-funct...