Profit Margin with VAT Calculator
Calculate the selling price including VAT needed to achieve your target profit margin, plus the VAT amount and net profit. Useful for businesses that must charge VAT on top of their margin.
How to use this tool
- Enter cost price (ex-vat), desired profit margin and vat rate in the fields above.
- Results update instantly as you type β or click Calculate.
- Read your selling price (inc-vat) and the full breakdown beneath it.
β This tool provides general estimates for education only and is not financial, tax or legal advice. Figures may not reflect your situation β verify with a qualified professional.
Formula
Price (ex-VAT) = Cost / (1 β Margin)
VAT Amount = Price (ex-VAT) Γ VAT Rate
Price (inc-VAT) = Price (ex-VAT) + VAT Amount
How it works
To achieve a desired gross margin, the selling price before tax must be set to Cost divided by (1 minus the margin rate). VAT is then added on top of this ex-VAT price as a pass-through charge to the customer β it does not affect the seller's margin, which is calculated on the ex-VAT selling price versus cost.
Worked example
Cost $500, target margin 30%, VAT 20%
- Price (ex-VAT) = 500 / (1 β 0.30) = 500 / 0.70 = 714.29
- VAT Amount = 714.29 Γ 0.20 = 142.86
- Price (inc-VAT) = 714.29 + 142.86 = 857.14
- Gross Profit = 714.29 β 500 = 214.29; Actual Margin = 214.29/714.29 Γ 100 = 30.00%
Selling price inc. VAT = $857.14; Gross Profit = $214.29; Margin = 30.00%
Common mistakes to avoid
- Calculating the margin on the VAT-inclusive price rather than the ex-VAT price β VAT is collected on behalf of the government and is not revenue, so margin must be based on net selling price only.
- Confusing the VAT-exclusive target with the VAT-inclusive price when setting a retail price, which results in collecting too little VAT and understating the liability to the tax authority.
- Forgetting that the margin percentage is applied to the selling price (ex-VAT), not to the cost; using cost as the base gives markup, not margin.
Key terms
- What is VAT?
- VAT (Value Added Tax) is a consumption tax collected at each stage of production and sale. Businesses charge VAT to customers and remit it to the government β it is not part of the seller's profit.
- Does VAT affect my profit margin?
- No. VAT is a pass-through tax paid by the end consumer. Your gross margin is calculated on the ex-VAT selling price versus your cost. VAT simply increases the total price the customer pays.
- Why divide by (1 β margin) to find selling price?
- If margin = profit/price, then price Γ (1βmargin) = cost. Rearranging: price = cost/(1βmargin). This ensures the resulting margin equals exactly your target.
- What is ex-VAT vs inc-VAT?
- Ex-VAT (exclusive of VAT) is the price before tax. Inc-VAT (inclusive of VAT) is the final price paid by the consumer including the tax component.
Frequently asked questions
- Does VAT affect my actual profit margin?
- No, if you are VAT-registered. VAT is a pass-through: you collect it from customers and remit it to the government. Your profit is calculated on the net-of-VAT selling price, so VAT neither increases nor decreases your margin.
- What if my business is not VAT-registered?
- If you are not VAT-registered, you cannot reclaim input VAT on purchases. This means your costs include VAT, which effectively reduces your margin. You should include the VAT-inclusive cost when calculating margin in this scenario.
- How do I find the ex-VAT price from an inclusive price?
- Divide the VAT-inclusive price by (1 + VAT rate). For a 20% VAT rate: ex-VAT price = inclusive price / 1.20. For example, a price of 120 including 20% VAT has a net price of 100.