A margin and vat calculator works out the selling price you need to reach a target margin, then adds UK VAT to give the price the customer pays. It can also run backwards, from a price that already includes VAT to the net price, the VAT and your margin and markup.
How to use the margin and vat calculator
- Choose what you know: a target margin, a markup, or a VAT-inclusive price.
- Enter the cost, before VAT, and the other figure.
- Pick the VAT rate.
- Press Calculate.
Margin and markup are different
Margin is profit as a share of the selling price, while markup is profit as a share of the cost. Xero's guide gives the formulas as markup equal to selling price minus cost, divided by cost, and margin equal to selling price minus cost, divided by selling price [2]. A product that costs 70 pounds and sells for 100 pounds has a markup of 42.86 percent and a margin of 30 percent [2]. The same profit always gives a smaller margin than markup.
Finding the price from a target margin
To reach a margin you need the cost divided by one minus the margin. Xero gives the selling price from a target margin as cost divided by (1 minus target margin) [2]. With a cost of 70 pounds and a margin of 30 percent, the price is 70 divided by 0.7, which is 100 pounds. A common slip is to multiply the cost by 1.3, which gives 91, a markup of 30 percent and a margin of only 23.1 percent.
Finding the price from a markup
A markup is applied to the cost, so the price is cost multiplied by one plus the markup. A cost of 70 pounds and a markup of 42.86 percent gives 100 pounds. The calculator then shows the margin that this markup produces. Xero gives the conversion as margin equal to markup divided by (100 plus markup) [2], which is how a 42.86 percent markup becomes 30 percent.
The UK VAT rates
GOV.UK lists three rates. The standard rate is 20 percent and applies to most goods and services. The reduced rate is 5 percent for some goods and services, such as children's car seats and home energy. The zero rate is 0 percent for zero-rated goods and services, for example most food and children's clothes [1]. The tool offers these three rates. Check the page for which one applies to your product.
Adding VAT
VAT is charged on the selling price before VAT. At the standard rate, 100 pounds becomes 120 pounds: 20 pounds of VAT plus the net price. At 5 percent, it is 105 pounds, and at 0 percent it stays at 100 pounds. The multiplication is our own working, as the GOV.UK page lists rates and does not set out the sum. The calculator shows the net price, the VAT and the gross price on separate lines.
Working backwards from a VAT-inclusive price
Retail prices are usually shown with VAT included. To find the price before VAT, divide by one plus the VAT rate. A price of 120 pounds at 20 percent is 120 divided by 1.2, which is 100 pounds, so the VAT is 20 pounds. You do not take 20 percent off 120, which would give 96 pounds and understate the net price. The reverse mode does the division and then finds your profit from the cost you enter.
Why margin is worked out on the price without VAT
VAT is collected on behalf of HMRC, so it is not your income. A margin worked out on the price with VAT would look better than the real one. The calculator therefore works margin and markup on the price before VAT. If you are VAT registered you can normally reclaim VAT on your costs, so enter the cost without VAT. If you cannot reclaim it, enter the cost with VAT included.
A worked example
A product costs 70 pounds, and you want a 30 percent margin at the standard rate. The price before VAT is 100 pounds, the VAT 20 pounds and the customer pays 120 pounds. Your profit is 30 pounds, a margin of 30 percent and a markup of 42.86 percent. At the reduced rate the customer would pay 105 pounds for the same net price. At a margin of 20 percent on a cost of 50 pounds, the price would be 62.50 pounds.
Choosing a margin
The right margin depends on your costs, which include rent, wages, fees and returns, not just the price you paid. Work out your overheads first, then choose a margin that covers them and leaves a profit. Compare the price with competitors' prices that already include VAT, and remember to compare like with like by using the reverse mode on their prices.
What the tool does not cover
The tool does not handle the VAT margin scheme for second-hand goods, the flat rate scheme, partial exemption or mixed supplies. It also does not decide which rate applies to your product, nor does it include discounts, delivery or card fees. For those, ask HMRC or an accountant, or see the GOV.UK pages on VAT.
Common mistakes
- Adding the margin as a markup. Divide by one minus the margin.
- Taking 20 percent off a VAT-inclusive price. Divide by 1.2 instead.
- Working margin on the price with VAT. VAT is not your income.
- Using a cost that includes reclaimable VAT. Enter the cost without VAT.
What next
Use this often? Add Margin and V to your Home screen.
Frequently asked questions
What is a margin and vat calculator?
A tool that finds the selling price for a target margin, adds VAT, or works back from a price that already includes VAT.
What are the UK VAT rates?
GOV.UK lists 20 percent standard, 5 percent reduced and 0 percent zero rates.
What is the difference between margin and markup?
Margin is profit divided by the selling price. Markup is profit divided by the cost.
How do I take VAT out of a price?
Divide the price including VAT by one plus the VAT rate, for example by 1.2 at 20 percent.
Is VAT included in the margin?
No. The margin is worked out on the price before VAT, because VAT is passed to HMRC.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.