How to Create an Export Price Calculator in Excel

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.

How to Create an Export Price Calculator in Excel: Step-by-Step Procedures

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.

=SUM(C5:C8)

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.

=SUM(C9:C11)

Afterward, press Enter to get the Cost of the Insurance and Freight.

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.

=D14*C12

Hit Enter to get the result.

Similarly, use the following formula to calculate Import taxes.

=D15*C12

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.

=SUM(C12:C17)

Finally, press Enter on your keyboard, and you will get the value of Delivered Duty Paid.

Practice Section

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.

Notes

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.

Download Practice Workbook

Download this practice workbook to exercise while reading this article.

Export_Price_Calculator.xlsx

Conclusion

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.

<< Go Back to Cost Calculator | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!