The supplier quoted $4.10 a unit. The real landed cost came in at $6.80. By the time the math caught up, the container was already on the water.

Landed cost is the true, all-in price of importing from China: the FOB price plus duties, Section 301 tariffs, ocean or air freight, MPF, and HMF. This unlocked Excel model stacks every cost into one honest per-unit figure and compares China against Vietnam, India, Mexico, Thailand, and Indonesia side by side.

The FOB quote looked great. You ran the margin in your head, it worked, you moved. Then the bills started landing one at a time: the tariff line you didn't price in, the ocean freight that doubled since last quarter, the customs broker fee, the duty rate that came in higher than the supplier swore it would. Each one took a bite. By the time the goods cleared, the margin you sold the deal on was gone — and the order was already done.

I price landed cost on my own China orders before I move on anything, because the FOB number is the smallest part of what you actually pay. This is the exact model I use, built out for you. You drop in your unit price, your duty and tariff rates, your freight, and it hands you the real per-unit cost and the real margin — six countries side by side, sea against air, before the wire goes out instead of after the surprise lands.

• •Full Excel model — every cell live, nothing locked, edit it for any product or order size
• •You enter your own duty and tariff rates and HS-code numbers, so the figure you see is built on your real order, not a generic estimate
• •6-country side-by-side comparison so you can see what China actually costs against Vietnam, India, Mexico, Thailand and Indonesia before you commit
• •Sea vs air freight toggle that shows the real per-unit cost difference, not a guess
• •Duties plus tariffs stacked into one true landed-cost number, so the figure you see is the figure you pay
• •Annual projection that multiplies your per-order difference across a full year of orders, so you can see what switching countries is actually worth on your volume
• •One-click PDF export — a clean cost sheet you can send your partner, your bank, or your own files
• •The complete paid version of the free lite calculator on the site — every input unlocked, no caps

Whether it's your first China order or your hundredth — for importers, Amazon FBA and private-label sellers, and procurement leads who need the real landed number before they commit.

"I'll just build my own spreadsheet." Sure, you can — and most people do, badly, leaving out the exact lines that cost them. The tariff stacked on top of the duty. Sea against air at your real volume. The annual number that tells you whether to switch countries at all. This is already built, already structured the way an operator actually prices an order, and it costs less than the freight on a single pallet. You can spend an afternoon rebuilding it from memory, or you can run your first real number in the next ten minutes.

Built by Cengiz Gündüz — 25 years in cross-border trade, on the ground in Shanghai, walking supplier floors every week. He sells industrial equipment out of China himself, so there's no vendor agenda and no supplier to push. It's the same cost model he runs on his own money, handed to you.

One mispriced order — a tariff line you forgot, a freight rate you guessed — can quietly erase the entire margin on a $50,000 shipment. This is $27. Less than the freight on a single pallet, and you run it on every order you ever place. The price is paid once; the number it protects compounds for years. Cheap insurance on an expensive mistake.

The "Don't Get Burned" Guarantee

Use it on your next order. If it doesn't save you a headache — or a dollar — email me within 7 days and I'll refund you in full. No forms, no hoops. I'm one operator in Shanghai, and I answer every email myself. — Cengiz

What's inside

• •A full Excel landed-cost model — type your numbers, it returns your true cost per unit. No guessing, no napkin math
• •Duties and tariffs stacked into one real number: base duty rate, Section 301 tariffs, MPF and HMF, freight, insurance, and fees — combined into the cost that actually hits your bank account
• •Sea vs. air freight comparison so you can see what speed really costs per unit before you choose
• •A 6-country comparison tab — line up China against alternative sourcing countries side by side on landed cost, not just FOB quote
• •Annual projection: roll a single order's true cost into a full-year volume so you can see the real margin on the program, not just one shipment
• •Suggested selling price and projected profit margin, per unit and per order
• •One-click PDF export to drop the true number into a deck, a lender packet, or an email to your boss
• •A pre-loaded worked example so it makes sense in under a minute. The complete paid version of the free lite tool.
• •Works in Microsoft Excel, Google Sheets (free), and Apple Numbers. No macros. Keep it forever, reuse on every order.

Why it matters

The costly mistake this prevents is pricing your product off the FOB quote your supplier gave you — and discovering later that duties, Section 301 tariffs, and freight quietly added 30 to 60 percent on top. The price a supplier quotes is not your cost. Your true cost of importing from China is the landed cost: FOB plus the China import duty, plus stacked tariffs, plus ocean or air freight, plus MPF, HMF, customs, and brokerage. Most importers run a tariff calculator once, eyeball the duty rate, and skip the rest — then find out at the end of the quarter they've been underpricing, or worse, importing at a loss. This is a real landed cost calculator for China imports: you enter your numbers and get one honest figure you can price against, compare across six countries, and project across a year. It costs a fraction of one mispriced order.

FAQ