# 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.
1. Value of the goods
2. Cost of handling carriage before
3. Export Customs formalities fixed cost
4. 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)

Read More: Opportunity Cost Calculator in Excel

### 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.
1. Cost of import Customs formalities
2. 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.

## 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.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF