Understanding the margin and VAT price calculator — concept and principle
This calculator turns a unit cost into a selling price in two steps: first it adds the gross margin you want on the net price, then it adds VAT. It shows the net price, the VAT in the price, profit per unit, the markup on cost and, if you round the shelf price up, the margin after rounding. Online sellers and shop owners in VAT countries use it to set prices that keep the intended margin.
How it is calculated
- Net price (excl. VAT) = cost ÷ (1 − margin %)
- Price incl. VAT = net price × (1 + VAT rate %)
- VAT in the price = price incl. VAT − net price
- Profit per unit = net price − cost; markup on cost = profit ÷ cost × 100
- Rounded price = price incl. VAT rounded up to the chosen step
- Margin after rounding = (rounded price ÷ (1 + VAT) − cost) ÷ (rounded price ÷ (1 + VAT)) × 100
VAT rates on the page: Korea 10%, UK 20%, Germany 19%, Japan 10% consumption tax.
The principle
Margin is profit as a share of the selling price, so to reach a 35% margin the net price must be cost ÷ 0.65, not cost × 1.35. VAT is a tax the seller collects for the government: it is added on top of the net price and passed on, so it never forms part of the margin. Markup and margin describe the same profit with different bases; a 35% margin equals a 53.8% markup on cost. Rounding the price up slightly raises the margin, so it is recalculated from the rounded price.
Worked example
Defaults: cost 12,000; margin 35%; VAT 10%; round up to 100.
- Net price = 12,000 ÷ 0.65 = $18,461.54; profit = $6,461.54.
- Price incl. VAT = 18,461.54 × 1.10 = $20,307.69; VAT = $1,846.15.
- Markup on cost = 6,461.54 ÷ 12,000 = 53.8%.
- Rounded up to the next 100 = $20,400.00.
- Net of VAT 20,400 ÷ 1.10 = 18,545.45; margin after rounding = 35.3%.
| Unit cost (excl. VAT) | Selling price incl. VAT |
|---|---|
| 3,000 | $5,076.92 |
| 6,000 | $10,153.85 |
| 9,000 | $15,230.77 |
| 12,000 | $20,307.69 |
| 15,000 | $25,384.62 |
| 18,000 | $30,461.54 |
| 24,000 | $40,615.38 |
How to read the result
Use the rounded VAT-inclusive price as the shelf price where consumer prices must include VAT, as in Korea and the EU. Check the margin after rounding against your target. If a competitor's price incl. VAT is lower, divide it by 1 + VAT and compare that net figure with your cost to see what margin you could actually earn.
Common mistakes
- Calculating margin on the VAT-inclusive price, which overstates profit.
- Multiplying cost by (1 + margin), which gives a markup, not a margin.
- Using a VAT rate that does not apply to the product; reduced rates and exemptions exist.
- Forgetting fees, shipping and returns that reduce the real margin.
Frequently asked questions
How do I calculate price from cost and margin?
Divide cost by (1 − margin). For 35%, price = cost ÷ 0.65.
Is VAT part of my margin?
No. VAT is collected for the tax authority and paid over, so it is excluded from margin.
What is the difference between markup and margin?
Markup is profit ÷ cost; margin is profit ÷ net price.
Sources: OpenStax, Contemporary Mathematics, section 6.2 "Discounts, Markups, and Sales Tax" · Korea Value-Added Tax Act, Article 30 (10% rate)