Calculate the margin from your cost and selling price, with or without VAT. You see the gross profit, the margin percentage and the markup, and you can work out a selling price for the margin you want.
The margin is the gross profit as a percentage of the selling price. Subtract the cost price from the selling price, divide the result by the selling price and multiply by 100. If you buy something for € 60 and sell it for € 100 excluding VAT, the gross profit is € 40 and the margin is € 40 ÷ € 100 × 100 = 40%. This is also called the gross margin or profit margin.
Both are about the same profit, but you divide by something different. For the margin you divide by the selling price, for the markup by the cost price. In the example from € 60 to € 100, the margin is 40% and the markup is € 40 ÷ € 60 × 100 = 66.67%. Two people talking about "40 percent" can therefore mean very different things. You convert a margin to a markup with margin ÷ (100 − margin) × 100.
| Margin | Markup | Cost € 60 becomes |
|---|---|---|
| 10% | 11.11% | € 66.67 |
| 20% | 25% | € 75.00 |
| 25% | 33.33% | € 80.00 |
| 30% | 42.86% | € 85.71 |
| 40% | 66.67% | € 100.00 |
| 50% | 100% | € 120.00 |
Always calculate the margin on amounts excluding VAT. The VAT your customer pays goes to the tax authority, so it is not revenue. A selling price of € 121 including 21% VAT is € 100 excluding VAT. Tick the box in the first sum to say the selling price includes VAT, and the calculator takes the VAT off first. To convert VAT only, use the Dutch VAT calculator.
This calculator works out the gross margin: selling price minus cost price. From that gross profit you still pay your fixed costs, such as rent, staff and software. What is left after that, as a percentage of revenue, is the net margin. If you sell services rather than products, you are more likely to work with an hourly rate; for that there is the hourly rate calculator.
Burg Media builds custom software. We build tools like this one with the same technology as our client projects: custom web applications, websites and web shops and content and campaigns.