Use this calculator to add 15% GST to a tax-exclusive price, remove GST from a tax-inclusive price, or find the included GST amount.
The standard GST rate in New Zealand is 15%.
How to calculate 15% GST manually
To calculate the GST amount, multiply the tax-exclusive price by 0.15.
For a tax-exclusive price of $200.00:
- GST amount: $200.00 × 0.15 = $30.00
- GST-inclusive price: $200.00 + $30.00 = $230.00
To extract GST from a tax-inclusive price, multiply the inclusive price by 15 and divide it by 115.
For a tax-inclusive price of $230.00:
- GST amount: $230.00 × 15 ÷ 115 = $30.00
- GST-exclusive price: $230.00 − $30.00 = $200.00
Alternatively, divide the GST-inclusive price by 1.15:
- $230.00 ÷ 1.15 = $200.00
Respected Sir,
i want how to calculate to GST AND IN EXCEL AND CALCULATOR TO ME
You can write a formula in Excel by examples provided above.