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%


Leave a Reply

Your email address will not be published. Required fields are marked *