Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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.

export price calculator excel


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.
  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: 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.
=SUM(C9:C11)
  • Afterward, press Enter to get the Cost of the Insurance and Freight.

Use Sum formula to determine Cost of the Insurance and Freight to Create an Export Price Calculator in Excel

Read More: How to Calculate Selling Price in Excel (4 Easy Methods)


Similar Readings


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.

Insert percentage of 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.

Apply formula to estimate  custom duties to Create an Export Price Calculator in Excel

  • Similarly, use the following formula to calculate Import taxes.
=D15*C12

Apply formula to estimate 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.
  1. Cost of import Customs formalities
  2. Cost of carriage after

Add cost of import customs and 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.

Apply SUM formula to calculate Delivered Duty Paid to Create an Export Price Calculator in Excel

Read More: How to Calculate Selling Price from Cost and Margin in Excel


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.

Practice Section

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.

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

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo