To help you with computing duty, I have created a user-friendly calculator (Excel file) which you can download for free on OneDrive.
It’s very easy to use. Just read the instruction beside each field so you’ll know what to do. The most important thing to prepare is the total dutiable amount of a shipment.
The file is in .xlsx format. It can be opened using Excel version 2007, 2010 and 2013. Just make sure that Calculation Option is set to Automatic so Excel will compute the fees automatically. Calculation option is under Formulas tab in Excel 2013.
Note: To download the file, click the OneDrive link then click on File > Save As
“Republic Act No. 1937” Official Gazette. Retrieved on March 28, 2014 from gov.ph/1957/06/22/republic-act-no-1937
“Tax Computation” Department of Finance: Bureau of Customs. Retrieved on March 30, 2014 from customs.gov.ph/references/tax-computation
“Exchange Rates” Department of Finance: Bureau of Customs. Retrieved on March 30, 2014 from customs.gov.ph
Various Contributors (October 16, 2001) “Microsoft Excel” Wikipedia. Retrieved on March 29, 2014 from en.wikipedia.org/wiki/Microsoft_Excel#File_formats
Various Contributors (October 26, 2005) “Duty (economics)” Wikipedia. Retrieved on March 29, 2014 from en.wikipedia.org/wiki/Duty_(economics)
“Duty” Merriam-Webster. Retrieved on March 29, 2014 from merriam-webster.com/dictionary/duty