Landed Cost Formula Explained (With a Free Spreadsheet Layout)
Every line item that belongs in a landed cost calculation, a worked example, and how to lay it out in a spreadsheet if you're not ready for a calculator.
"Landed cost" shows up in a lot of search results as a single formula, but the real work is knowing which line items to include and where the numbers come from. Here's the full breakdown, a worked example, and a layout you can drop straight into a spreadsheet.
The Formula
Landed cost = product cost + freight + insurance + duties + other fees. Divide by quantity to get a per-unit landed cost — the number that actually determines your margin, not the supplier's unit price.
What Belongs in Each Line
- Product cost — the supplier's invoice amount, converted to your base currency at a consistent rate.
- Freight — ocean, air, or road freight to the named place, including any fuel or peak-season surcharges.
- Insurance — cargo insurance premium, if you're covering it rather than the seller.
- Duties — import duty, calculated as a percentage of a customs (usually CIF) value; the rate depends on the HS code.
- Other fees — customs clearance, port or terminal handling, inland haulage, documentation fees, and any broker charges.
Worked Example
Cost component Amount (USD)
Product cost (1,000 units × $4): $4,000
Freight: $600
Insurance: $40
Duty (12% of product + freight): $552
Clearance, handling & haulage: $180
Total landed cost: $5,372
Landed cost per unit: $5.37
Laying This Out in a Spreadsheet
If you're not ready to use a calculator, six columns get you most of the way: Item, Product Cost, Freight, Insurance, Duty, Fees, and a Total column that sums them (=SUM()). Add a Quantity column and a final Landed Cost per Unit column (=Total/Quantity) so you can compare directly against your selling price. Keep one row per shipment or per SKU, so the sheet doubles as a running record.
When a Spreadsheet Isn't Enough
A spreadsheet works fine for one or two shipments a month. It gets error-prone once you're tracking multiple SKUs, currencies, or suppliers — formulas break, someone overwrites a cell, and last quarter's rate stays hardcoded. Our free landed-cost calculator handles the per-unit math without that risk; the full walkthrough covers the duty-basis detail this piece only summarizes.
Estimate only — confirm HS classification, duty rate, and valuation basis with your customs broker before relying on any landed-cost figure for pricing. See how Bilexor keeps shipment records consistent.
Informational only — not legal, banking, tax, or customs advice. Always verify document and LC requirements with your bank, CHA / customs broker, and buyer before presentation.