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%
|
||||