If you need to calculate the export price of your products, using Excel can be very handy. If you have to do it on a regular basis, you might need your own calculator to keep track of your export log. In this article, we will walk you through four easy steps to create an export price calculator in Excel. Here’s an overview of the export price calculator.
Download Practice Workbook
Download this practice workbook to exercise while reading this article.
Step-by-Step Procedure to Create an Export Price Calculator in Excel
In this article, we will demonstrate four easy steps to create an export price calculator in Excel. We will discuss the steps in detail in the following section.
Step 1: Calculate Free on Board
- First of all, insert the price of the following four types of expenses.
- Value of the goods
- Cost of handling carriage before
- Export Customs formalities fixed cost
- Handling costs in originating terminal
- Then, to calculate the Free on Board expenses, select cell C9 and write down the following formula with the SUM function.
Read More: How to Calculate Unit Price in Excel (3 Quick Methods)
Step 2: Determine Cost of Insurance and Freight
- In the second step, we will determine the Cost of the Insurance and Freight. To do so, add the cost of main transportation.
- Next, input the cost of insurance of main transport.
- Then, select cell C12 and type the formula given below.
- Afterward, press Enter to get the Cost of the Insurance and Freight.
Read More: How to Calculate Selling Price in Excel (4 Easy Methods)
- How to Calculate Price Per Pound in Excel (3 Easy Ways)
- Calculate Cost per Unit in Excel (With Easy Steps)
- How to Calculate Coupon Rate in Excel (3 Ideal Examples)
- Calculate Retail Price in Excel (2 Suitable Ways)
- How to Calculate Weighted Average Price in Excel (3 Easy Ways)
Step 3: Estimate Custom Duties and Import Taxes
- In this step, we will estimate the taxes. First, insert the handling cost on arrival at the port.
- Then, insert the percentages of Custom duties and Import taxes.
- Now, to calculate the value of custom duties, click on cell C14 and insert the following formula.
- Hit Enter to get the result.
- Similarly, use the following formula to calculate Import taxes.
Read More: How to Calculate Selling Price Per Unit in Excel (3 Easy Ways)
Step 4: Determine Delivered Duty Paid
- In the final step, we will determine the Delivered Duty Paid. To begin with, insert two types of expenses.
- Cost of import Customs formalities
- Cost of carriage after
- Then, select cell C18 and write the formula given below.
- Finally, press Enter on your keyboard, and you will get the value of Delivered Duty Paid.
Read More: How to Calculate Selling Price from Cost and Margin in Excel
We have provided a practice section on the right side of the first sheet so you can practice yourself. Follow the steps and try to do it by yourself.
- Don’t forget to give proper cell references or you won’t get the desired results.
- You can insert additional rows to add more types of expenses as per your need.
Thanks for making it this far. I hope you find this article useful. Now you know four easy steps to create an export price calculator. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.
- How to Create Fuel Cost Calculator Using Excel Formula
- Calculate Price Per Square Meter in Excel (3 Handy Methods)
- How to Calculate Variable Cost Per Unit in Excel (with Quick Steps)
- Calculate Bond Price in Excel (4 Simple Ways)
- How to Calculate Projected Cost in Excel (4 Effective Ways)
- Calculate Discount Price in Excel (4 Quick Methods)
- How to Calculate Price Increase Percentage in Excel (3 Easy Ways)