# How to Create an Export Price Calculator in Excel: 4 Methods

### Method 1 – Calculate Free on Board

• 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 the originating terminal

• To calculate the Free on Board expenses, select cell C9 and write the following formula with the SUM function.
`=SUM(C5:C8)`

### Method 2 – Determine Cost of Insurance and Freight

• Determine the Cost of the Insurance and Freight. Add the cost of main transportation.
• Input the cost of insurance of main transport.

• Select cell C12 and type the formula given below.
`=SUM(C9:C11)`
• Press Enter to get the Cost of the Insurance and Freight.

### Method 3 – Estimate Custom Duties and Import Taxes

• We will estimate the taxes. Insert the handling cost on arrival at the port.
• Insert the percentages of Custom duties and Import taxes.

• Calculate the value of custom duties, click cell C14 and insert the following formula.
`=D14*C12`
• Hit Enter to get the result.

• Use the following formula to calculate Import taxes.
`=D15*C12`

### Method 4 – Determine Delivered Duty Paid

• Determine the Delivered Duty Paid. Insert two types of expenses.
1. Cost of import Customs formalities
2. Cost of carriage after

• Select cell C18 and write the formula given below.
`=SUM(C12:C17)`
• Press Enter on your keyboard, and you will get the value of Delivered Duty Paid.

## Related Articles

<< Go Back to Cost Calculator Finance TemplateExcel 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