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