Landed Cost Excel Template — Free, With Working Formulas
Enter seven numbers — product cost, units, freight, insurance, delivery, your duty rates and broker fee — and the template calculates the full 2026 duty stack (MFN + §301 + forced-labor tariff), MPF with its min/max bounds, HMF, VAT and your true per-unit landed cost. No email wall, no locked cells.
Download the Template (.xlsx)
Two sheets: the calculator (blue cells = inputs, everything else auto-calculates) and a notes sheet documenting every assumption and 2026 rate bound.
Free Download — no email requiredWorks in Excel, Google Sheets and LibreOffice. Free to use and share.
The Formulas Inside — Line by Line
Every formula in the template, explained. Build your own version or audit ours.
| Line | Formula | Why |
|---|---|---|
| Customs value (US = FOB) | = product cost (invoice total) | US duty base excludes freight; EU/UK use CIF instead |
| Total duty | = customs value × (MFN% + §301% + forced-labor%) | Stack all applicable tariff layers |
| MPF | = MIN(MAX(value × 0.3464%, $34.58), $670.86) | US MPF, FY2027 bounds |
| HMF | = value × 0.125% (sea only) | Zero for air freight |
| VAT / GST | = (value + duty) × VAT% | 0% for US; ~20% EU/UK — charged on duty-inclusive base |
| Total landed cost | = product + freight + insurance + local delivery + duty + VAT + fees + brokerage | The number that belongs in your margin math |
| Per-unit landed cost | = total landed cost ÷ units | Compare against your selling price, not the invoice price |
Worked Example (the template's default numbers)
| Product cost — 500 units from China | $10,000.00 |
| Freight + insurance + local delivery | $1,200.00 |
| Duty stack: 5% MFN + 25% §301 + 12.5% forced-labor | $4,250.00 |
| MPF + HMF + broker | $172.14 |
| Total landed cost | $15,622.14 |
| Per-unit landed cost (vs $20 invoice price) | $31.24 |
| Effective uplift on invoice | +56.2% |
A $20/unit product that actually costs $31.24 to land is the classic margin killer — if you priced at $35 thinking "75% margin," your real margin is about 11%.
Where the Template Ends and the Calculator Begins
The template is right for
- Modeling scenarios before supplier negotiations
- Quick per-unit math on a known lane
- Sharing assumptions with your accountant
- Learning how the duty stack actually works
You need live rates when
- You don't know the duty rate for your HS code
- China origin — §301 list membership matters
- Anti-dumping exposure is possible
- Rates changed since you built the sheet (they did)
Check Your Rates Live
Fill the template's rate cells with confidence — look up the current duty stack for your product and lane here, then paste the percentages into Excel.
Free landed-cost calculator
PDF · PNG · JPG · max 15MB. Make sure the invoice shows totals clearly.
Example: Static converters (chargers, power supplies) — other
The rate that applies is the one in force on the day the goods are entered.
3/3 free analyses remaining today · No signup required
Frequently Asked Questions
Total landed cost = product cost + international freight + insurance + local delivery + customs duty + VAT/GST + entry fees + brokerage. The duty line is customs value × the sum of applicable tariff rates (MFN + Section 301 for China origin + the forced-labor tariff, or Section 232). In the US, customs value is FOB (freight excluded from the duty base); in the EU, UK and Canada it's CIF (freight and insurance included). Our free template implements all of this with working formulas — enter seven numbers and every layer calculates automatically.
Everything it takes to get the product onto your warehouse shelf: supplier invoice price, international freight, cargo insurance, customs duty and tariff surcharges, VAT/GST (if not reclaimable), customs entry fees (MPF/HMF in the US), broker fees, port and handling charges, and final-mile delivery. Commonly forgotten: currency conversion spreads, pallet/repacking charges, and compliance testing. Marketing and warehousing after arrival are NOT landed cost — they're operating expenses.
Yes — direct download, no email required, use and share it freely. The honest catch: a spreadsheet uses the rates YOU type in. Duty rates change (Section 301 lists get revised, new programs like the forced-labor tariff appear, anti-dumping orders appear), and a template can't warn you. That's the gap our live calculator fills — it pulls current rates per HS code. Use the template for modeling and the calculator for verification before you commit to a PO.
Two standard methods: by value (each SKU carries freight proportional to its share of invoice value) or by weight/volume (proportional to kg or CBM — better when products have very different densities). For duty purposes the allocation doesn't matter in the US (FOB base), but for per-unit landed cost it changes everything: a heavy cheap item under value-allocation looks artificially profitable. Most importers use weight-based allocation for ocean freight and value-based for insurance.
The usual suspects: (1) customs used a different HS classification with a higher duty rate; (2) an anti-dumping duty applied that you didn't know about; (3) demurrage/detention charges from port delays; (4) your freight quote excluded destination charges (THC, documentation, chassis fees) that appeared on the final invoice; (5) currency moved between PO and payment. Build a 3–5% contingency line into the template for the first shipments on any new lane.
Excel works fine to ~20 SKUs on 1–2 lanes. The breaking points: multiple origins with different tariff stacks, rate changes you can't track manually (a §301 revision can silently invalidate every row), team members overwriting formulas, and needing landed cost at PO time rather than after the fact. That's the graduation point to automated tools that recalculate on live rates — which is exactly what Zentria Flow does.
Related Guides
Keep reading
- Profit Margin on Imported Products (2026) — Formula
- Landed Cost vs COGS (2026) — What Goes Where
- Is Your Import Business Profitable? Unit Economics (2026)
- What Is Landed Cost? Definition, Formula & Calculator 2026
- Shopify Landed Cost 2026 — Import Duty Calculator
- Tariff API vs Spreadsheet: The Real Cost of DIY Duty Math
- Landed Cost Calculator — Duty, Tariffs, VAT & Freight
- Landed Cost Software for US Importers — 2026 Tariffs
- Landed Cost Software for Importers — Duty, Tariffs & VAT
- All guides and tools →