Landed Cost Calculator

The Landed Cost Calculator builds the true per-unit cost of imported goods. You enter the invoice value, freight and insurance, the duty basis and rate, and any additional fee items, and it returns the total landed cost, the cost per unit, and a breakdown showing what share each component contributes.

It also shows how much the landed cost exceeds the invoice price, and what the duty would have been on the other customs-value basis, so the effect of that choice is visible rather than buried.

Amounts are in the supplier's currency, converted to your home currency by the exchange rate you supply.

Use it to price imported goods and to see where the cost actually goes. The customs value basis it defaults to is not the rule everywhere. Read the methodology before relying on the duty figure.

Purpose and model boundary

This model assembles the cost of an imported shipment from goods value, freight, insurance, customs duty, additional fees, exchange rate, and shipment units. It reports total and per-unit landed cost, the contribution of each cost family, and the effect of the selected customs-value basis.

It is an estimating model, not customs, tax, tariff-classification, or legal advice. The workbook does not determine a commodity code, origin treatment, trade-agreement eligibility, or the applicable duty rate.

Inputs and units

Governing relationships

The duty rate r is the selected illustrative category rate or r_custom / 100 for the custom path. The customs-value basis is:

V_customs = G + F + I for the goods/freight/insurance option

V_customs = G for the goods-only option

The remaining relationships are:

Duty = V_customs × r

Other fees = sum(additional cost item amounts)

Supplier-currency landed total = G + F + I + Duty + Other fees

Total landed cost = supplier-currency landed total × x

Landed cost per unit = total landed cost / N

Goods cost per unit = G × x / N

Uplift over invoice price = landed cost per unit / goods cost per unit - 1

The workbook calculates goods, freight-and-insurance, duty, and other-fee shares by dividing each supplier-currency component by the supplier-currency landed total. The four shares therefore add to one. Exchange conversion occurs once, after the supplier-currency total has been assembled.

For comparison, the workbook also calculates G × r as duty on goods alone and subtracts it from the selected-basis duty.

Calculation sequence

1. Resolve the selected duty category and whether the custom-rate input applies.
2. Resolve the selected customs-value basis.
3. Sum the six fixed additional-cost rows, treating blank amounts as zero.
4. Calculate duty, the supplier-currency landed total, and its component shares.
5. Apply the exchange rate once to the total and derive per-unit and uplift measures.
6. Return the goods-only duty comparison and evaluate Model_Status.

Outputs and interpretation

Landed_Cost_Per_Unit is the primary decision figure for margin, purchasing, and pricing comparisons. Total_Landed_Cost is in home currency, while duty, customs value, and other-fee totals are shown in supplier currency as declared by the input rules. The cost-breakdown donut is a composition of the supplier-currency components; hover or keyboard focus exposes its values.

The Duty_Difference_Between_The_Two_Bases isolates only the basis choice. It does not determine which basis is lawful for a shipment.

Validation and status logic

The duty-rate warning takes precedence over the uplift warning.

Assumptions and limitations

• Preset duty categories and rates are illustrative only. Actual duty can depend on tariff code, product description, origin, valuation rules, quotas, anti-dumping measures, and trade agreements.
• The user must choose the customs-value basis applicable to the jurisdiction and transaction. The model does not make that legal determination.
• All monetary inputs before conversion are assumed to use the same supplier currency. Freight or fees already stated in home currency must be converted before entry.
• A single exchange rate is applied to the full total. The model does not handle different booking dates, hedges, spreads, bank charges, or multi-currency line items.
• VAT/GST, sales tax, excise, brokerage rules, recoverable tax, demurrage, and other charges are excluded unless the user adds them to the six-row fee grid.
• The model does not test duplicate fees, taxability, invoice accuracy, or whether a charge is already included in freight.

Restrictions and non-computing states

This calculator requires at least one shipment unit, constrains duty-rate inputs to 0 through 100 percent, and rejects negative monetary and additional-cost amounts. The additional-cost grid has six editable rows; blank rows are allowed, but the page cannot add a seventh fee. The workbook does not compute a usable result when goods value or exchange rate is nonpositive. Duty presets and the two customs-value bases are the fixed workbook choices; only the custom-rate path exposes an editable duty rate.

Errors and warnings

Input checking can reject an out-of-range duty rate, nonpositive unit count, or invalid grid amount before calculation. Workbook NOT VALID means the monetary basis cannot be computed. Workbook CHECK retains the result but flags an unusually high duty rate or overall uplift. A connection or calculation-service failure is a service error, not a customs conclusion.

The workbook derives its relations rather than reproducing any tariff schedule, table or figure. The duty rate categories are illustrative sample rates and carry no relationship to any real tariff line.

• U.S. Customs and Border Protection. Deductions from transaction value, the guidance under which international freight and insurance may be excluded from the dutiable value when separately identified. https://www.help.cbp.gov/s/article/Article1126
• U.S. Customs and Border Protection. Freight charges and customs value. https://www.help.cbp.gov/s/article/Article-1162?language=en_US
• World Customs Organization. Harmonized System, the classification framework duty rates hang from. https://www.wcoomd.org/en/topics/nomenclature/overview.aspx
• Wikipedia. Incoterms, for who bears which cost; note that these do not themselves determine the dutiable value. https://en.wikipedia.org/wiki/Incoterms

The customs value rules, duty rates and additional charges that apply to a real import come from the customs authority of the importing country. Nothing here is customs advice and no trademark or organisation name appearing in this tool implies endorsement by its owner.

Additional source notes migrated from Methodology

The workbook implements component roll-up and the two explicitly selected customs-value bases; it does not reproduce a tariff schedule. The delivered reviewer packet points to Freightos freight resources for comparison and requires confirmation with the applicable customs authority, tariff, commodity code, and country-of-origin rules.