Margin and VAT Calculator
Print| Net Selling Price (Excl. VAT) | $0.00 |
| Gross Profit Amount | $0.00 |
| VAT Amount Collected | $0.00 |
The Margin and VAT Calculator helps UK, European, and international businesses, retailers, and e-commerce sellers calculate product selling prices, gross profit margins, dollar profit, and Value Added Tax (VAT) totals. Compute net prices and tax-inclusive retail shelf prices effortlessly.
The Margin & VAT Formulas
In VAT jurisdictions, retail display prices include VAT. Computing target gross margins requires calculating net revenue before adding local VAT rates:
Net Selling Price (Excl. VAT) = Cost of Goods Sold / ( 1 - ( Target Gross Margin % / 100 ) )
VAT Amount = Net Selling Price × ( VAT Rate % / 100 )
Gross Customer Price (Incl. VAT) = Net Selling Price + VAT Amount
To extract Net Selling Price and VAT from a VAT-inclusive shelf price:
Net Selling Price = Gross Customer Price / ( 1 + ( VAT Rate % / 100 ) )
Extracted VAT Amount = Gross Customer Price - Net Selling Price
Retail Pricing Benchmarks Across Common VAT Rates
Compare net selling prices, gross profit, VAT amounts, and total customer shelf prices for an item costing £40.00 COGS with a 40% target gross margin:
| Jurisdiction & VAT Rate | Net Price (Excl. VAT) | Gross Profit (£) | VAT Amount (£) | Total Shelf Price (Incl. VAT) |
|---|---|---|---|---|
| UK Standard VAT (20%) | £66.67 | £26.67 | £13.33 | £80.00 |
| Germany / France (19% / 20%) | £66.67 | £26.67 | £12.67 | £79.34 |
| Spain / Italy (21% / 22%) | £66.67 | £26.67 | £14.00 | £80.67 |
| Sweden / Denmark (25%) | £66.67 | £26.67 | £16.67 | £83.34 |
Step-by-Step Margin & VAT Calculation Example
Here is an example calculating net price, gross profit, and VAT for an item costing £60.00 COGS targeting a 50% gross profit margin under UK 20% VAT:
- Calculate Net Selling Price:
£60.00 / ( 1 - 0.50 ) = £120.00 net price (excl. VAT). - Calculate Gross Profit Amount:
£120.00 - £60.00 = £60.00 gross profit. - Calculate 20% Standard VAT:
£120.00 × 0.20 = £24.00 VAT. - Compute Total Customer Shelf Price:
£120.00 + £24.00 = £144.00 gross shelf price.
Frequently Asked Questions
Why must VAT be excluded when calculating gross profit margin?
VAT is an indirect sales tax collected on behalf of tax authorities. Because VAT is remitted to the government, it cannot be counted as business revenue when calculating profit margins.
What is the VAT Margin Scheme?
The VAT Margin Scheme is a specialized tax rule for second-hand goods, antiques, and artwork where VAT is calculated on the difference between purchase price and resale price rather than total selling price.
How do I calculate VAT from a VAT-inclusive price?
Under 20% VAT, divide the total VAT-inclusive price by 6 (or multiply by 20 / 120 = 1/6) to extract the exact VAT portion.
What is the difference between input VAT and output VAT?
Output VAT is VAT collected from customers on sales. Input VAT is VAT paid to suppliers on business purchases. Businesses remit net VAT (Output VAT minus Input VAT) to tax authorities.