Open calculator ↗

Import duty cascade with excise and VAT · Calculation guide

Scenario uses ad valorem duty on customs value, excise on value plus duty, and VAT on all three.

Calculation guide

Enter local rates only if this sequence applies.

tax = value*((1+dutyRate/100)*(1+exciseRate/100)*(1+vatRate/100)-1) · duty = value*dutyRate/100 · excise = (value+duty)*exciseRate/100 · vat = (value+duty+excise)*vatRate/100

Inputs

Customs value

Example entry 10000.0 (in the selected currency).

Duty rate (%)

Example entry 10.0 %. Allowed range 0 to 100.

Excise rate (%)

Example entry 20.0 %. Allowed range 0 to 100.

Import VAT rate (%)

Example entry 10.0 %. Allowed range 0 to 100.

Worked example

InputValue
Customs value10,000
Duty rate (%)10%
Excise rate (%)20%
Import VAT rate (%)10%
ResultValue
Total import taxes4,520
Import duty1,000
Excise tax2,200
Import VAT1,320

Calculation steps

Total import taxes = (Customs value × ((((1 + (Duty rate (%) ÷ 100)) × (1 + (Excise rate (%) ÷ 100))) × (1 + (Import VAT rate (%) ÷ 100))) − 1))

(10,000 × ((((1 + (10 ÷ 100)) × (1 + (20 ÷ 100))) × (1 + (10 ÷ 100))) − 1)) = 4,520

Import duty = ((Customs value × Duty rate (%)) ÷ 100)

((10,000 × 10) ÷ 100) = 1,000

Excise tax = (((Customs value + Import duty) × Excise rate (%)) ÷ 100)

(((10,000 + 1,000) × 20) ÷ 100) = 2,200

Import VAT = ((((Customs value + Import duty) + Excise tax) × Import VAT rate (%)) ÷ 100)

((((10,000 + 1,000) + 2,200) × 10) ÷ 100) = 1,320

Interpreting the result

Compare VAT with the customs value to see how earlier taxes increase its taxable base.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Customs value10,00011,000Total import taxes4,5204,972
Duty rate (%)10%11%Total import taxes4,5204,652
Excise rate (%)20%22%Total import taxes4,5204,762
Import VAT rate (%)10%11%Total import taxes4,5204,652
Import duty cascade with excise and VAT →

Sources