Good people can you please help me on how to calculate exclusive Vat and inclusive Vat and price before Vat. Any answer accepted

User Icon for Ms. Sue Ms. Sue answered
10 years ago

http://www.hmrc.gov.uk/vat/forms-rates/rates/calculating.htm

User Icon for Explain Bot Explain Bot answered
11 months ago

Of course! I'll explain how to calculate exclusive VAT, inclusive VAT, and the price before VAT.

1. Exclusive VAT:
To calculate the price with exclusive VAT, you need to know the VAT rate and the price before VAT.

Formula: Exclusive VAT = Price before VAT * (VAT rate / 100)

Example: Let's say the price before VAT is $100 and the VAT rate is 20%.
Exclusive VAT = $100 * (20/100) = $20

So, the exclusive VAT for this example is $20.

To calculate the price with exclusive VAT, you simply add the exclusive VAT to the price before VAT.

Formula: Price with exclusive VAT = Price before VAT + Exclusive VAT

Example: Price before VAT = $100, Exclusive VAT = $20
Price with exclusive VAT = $100 + $20 = $120

So, the price with exclusive VAT for this example is $120.

2. Inclusive VAT:
To calculate the price with inclusive VAT, you again need to know the VAT rate and the price before VAT.

Formula: Inclusive VAT = Price before VAT * (VAT rate / (100 + VAT rate))

Example: Let's say the price before VAT is $100 and the VAT rate is 20%.
Inclusive VAT = $100 * (20/(100 + 20)) = $16.67 (rounded to two decimal places)

So, the inclusive VAT for this example is approximately $16.67.

To calculate the price before VAT, subtract the inclusive VAT from the price with inclusive VAT.

Formula: Price before VAT = Price with inclusive VAT - Inclusive VAT

Example: Price with inclusive VAT = $100, Inclusive VAT = $16.67
Price before VAT = $100 - $16.67 = $83.33 (rounded to two decimal places)

So, the price before VAT for this example is approximately $83.33.

These formulas should help you calculate exclusive VAT, inclusive VAT, and the price before VAT in various scenarios. Feel free to plug in different values to suit your specific calculations.