Simple Customs Duty Calculator (example)
Create custom duty calculator in Excel with % formulas as applicable and get percentage of duty on assessable value
Customs Duty Calculator (example)
|
|||||
create worksheet and give formulas with ref. to % as applicable and enter the values
|
|||||
CIF Value (Cost Insurance & Freight) in Rupees
|
10,000.00
|
||||
Landing Cost
|
1.00%
|
100.00
|
|||
Assessable Value
|
10,100.00
|
||||
BCD (Basic Custom Duty)
|
7.50%
|
757.50
|
|||
CVD (Counter Veiling Duty)
|
8.00%
|
868.60
|
|||
CVD Cess (Educational Cess 2% + Higher Educational Cess 1%)
|
3.00%
|
26.06
|
|||
BCD Cess (Educational Cess 2% + Higher Educational Cess 1%)
|
3.00%
|
49.56
|
|||
Special Additional Duty
|
4.00%
|
472.07
|
|||
Total Duty Paid
|
2,173.79
|
||||
Percentage of Duty Paid on CIF Value
|
21.74%
|
||||
Percentage of Duty Paid on Assessable Value (AV)
|
21.52%
|
||||