Chapter 12
Export Pricing, Landed Cost and Trade Analytics
Bachelors Program in International Business
Import-Export Operations & Documentation
•
Bachelor
Export Pricing, Landed Cost and Trade Analytics
Introduction
An export sale is profitable only when its price covers the correct bundle of costs, taxes, risks and financing requirements. A quotation that appears profitable at the factory gate may become loss-making after freight surcharges, customs duties, destination charges or adverse exchange-rate movements. Conversely, overstating uncertain costs can make an otherwise viable offer uncompetitive.
Export pricing therefore requires more than converting a domestic price into a foreign currency. Managers must identify which party bears each cost under the agreed Incoterms® rule, distinguish accounting margin from contribution margin, model customs valuation and import taxes, and evaluate both economic cost and cash requirements. Trade analytics then converts transactional data into performance indicators, scenarios and decision dashboards.
Learning Objectives
After completing this chapter, students should be able to:
Construct export prices under different delivery terms.
Calculate freight, insurance, customs duties, import taxes and landed cost.
Distinguish gross margin, contribution margin, markup and net profit.
explain how recoverable import VAT affects cash flow and economic cost differently.
Assess foreign-exchange exposure and calculate break-even exchange rates.
Apply KPIs, sensitivity analysis and scenario modelling to export decisions.
Evaluate the governance, data and regulatory requirements of trade analytics.
1. The Architecture of an Export Price
An export quotation should identify the product, quantity, unit price, currency, delivery term, named place, Incoterms® version, payment terms and quotation validity. For example, “EUR 110 per unit, DAP Lyon Distribution Centre, Incoterms® 2020, payment within 30 days” is more informative than a price stated simply as “delivered.”
Incoterms® allocate specified costs, risks and operational responsibilities between seller and buyer. They do not determine ownership, payment timing, customs value, tax residence or dispute resolution. These matters require separate contractual and regulatory analysis.
1.1 Cost categories
Relevant export costs can be organized as follows:
Category
Examples
Typical analytical treatment
Cost of goods sold (COGS)
Materials, production labour, manufacturing overhead
Required under CIF and CIP; optional under other rules
Import charges
Duty, import VAT, excise and customs fees
Responsibility depends on term and law
Destination logistics
Port handling, brokerage, storage and final delivery
Included according to delivery term
Financing and risk
Credit insurance, bank fees, working capital and hedging
Included in transaction profitability
Costs must not be counted twice. If a carrier’s door-to-door quotation already includes destination handling, that charge should not be added separately.
1.2 Build-up pricing
Build-up pricing begins with cost and adds the costs associated with the seller’s contractual obligations:
Here, Pquote is the quoted price, Cgoods is product cost, the remaining C terms are costs borne by the seller, and Π is the required transaction profit. All terms must use the same currency and quantity basis.
A quotation may therefore rise progressively from EXW-like factory value to FCA, CPT/CIP, DAP and DDP levels as the seller assumes more obligations. Actual responsibilities must be verified against the selected Incoterms® rule and named place.
Export price and landed-cost waterfall
Figure: Export price and landed-cost waterfall
Figure: A landed-cost waterfall in which successive logistics and import components increase the acquisition cost.
1.3 Gross margin, contribution margin and markup
These measures answer different questions and must not be used interchangeably.
Gross margin uses revenue and cost of goods sold:
GM = (R - COGS) ÷ R
GM is the gross-margin rate, R is net sales revenue, and COGS is cost of goods sold. Gross margin does not deduct freight, commissions or other selling expenses unless accounting policy classifies them within COGS.
Contribution margin deducts all variable costs attributable to the sale:
CM = (R - COGS - VCs) ÷ R
VCs represents variable selling, logistics and transaction costs outside COGS. Contribution shows how much revenue remains to cover fixed costs and profit.
If the required gross-margin rate is g, the special-case price based only on COGS is:
P = COGS ÷ (1 - g)
If management instead targets contribution-margin rate c, and all transaction costs are variable, the required price is:
P = (COGS + VCs) ÷ (1 - c)
Both formulas assume that the denominator is positive and that costs and price relate to the same quantity and currency.
Markup is calculated on cost rather than revenue:
Markup = (P - C) ÷ C
For example, a product costing USD 80 and selling for USD 100 has a 25% markup but a 20% margin.
2. Freight and Cargo Insurance
2.1 Freight calculations
Freight may be based on mass, volume, container size, shipment distance, commodity class or a negotiated minimum. In air freight, chargeable weight is commonly the greater of actual and volumetric weight:
Wc = max(Wa, V ÷ D)
Wc is chargeable weight in kilograms, Wa is actual weight in kilograms, V is volume expressed in the units prescribed by the carrier, and D is the carrier’s volumetric divisor. Because divisors vary by carrier and unit convention, they must be taken from the applicable tariff.
If 12 cartons have dimensions 60 cm × 50 cm × 40 cm and the divisor is 5,000 cm³/kg, volumetric weight is:
Wv = 12 × 60 × 50 × 40 ÷ 5{,}000 = 288\ kg
If actual weight is 240 kg, the chargeable weight is 288 kg. At USD 4.20 per chargeable kilogram, base freight is USD 1,209.60 before fuel, security and handling surcharges.
2.2 Cargo insurance formula
Cargo insurance is usually calculated as a rate applied to an insured value. Policies often insure more than 100% of the shipment value to cover anticipated profit and incidental expenses. Under Incoterms® 2020, CIF normally requires minimum cover consistent with Institute Cargo Clauses (C), while CIP normally requires broader Institute Cargo Clauses (A), unless the parties agree otherwise.
Where the insured value includes the premium itself, the calculation is circular. Let B be the value before insurance, k the insured-value factor, r the premium rate, and I the premium. Then:
I = r × k × (B + I)
Solving for the premium gives:
I = (r × k × B) ÷ (1 - r × k)
This formula applies only where policy wording includes the premium in the insured base and r × k < 1. Otherwise, the insurer’s stated basis must be used.
Worked Example: Insurance Premium
Goods and freight before insurance total USD 53,000. The insurer requires coverage of 110% and charges 0.6% of insured value.
The premium of USD 352.13 is therefore consistent with a 0.6% rate applied to the insured value, subject to rounding.
3. Customs Value, Duties and Import Taxes
3.1 Customs value
Customs value is not automatically equal to the commercial invoice or Incoterms® price. Under transaction-value systems, authorities may adjust the price for items such as assists, royalties, packing, commissions, freight and insurance up to the border. Certain post-import costs may be deductible if separately identifiable. National law and the WTO Customs Valuation Agreement framework must be consulted.
For an ad valorem duty:
D = d × CV
D is customs duty in currency units, d is the duty rate, and CV is customs value. Specific duties use a monetary amount per physical unit, while compound duties combine ad valorem and specific components.
A common, but not universal, import-VAT structure is:
VATimport = t × (CV + D + E + A)
t is the VAT rate, E is excise duty, and A represents other amounts included by local law, such as incidental expenses to the first destination. The legally prescribed tax base always takes precedence over this general representation.
Worked Example: Duty, Excise and Import VAT
Assume the following rules in the importing country:
Invoice value: USD 40,000
Dutiable buyer-supplied assist: USD 2,000
Freight to border: USD 3,000
Insurance: USD 400
Ad valorem duty: 8%
Excise: 5% of customs value plus duty
Delivery to first destination included in the VAT base: USD 1,000
Total border taxes are USD 16,580.32, comprising duty of USD 3,632, excise of USD 2,451.60 and VAT of USD 10,496.72. If the importer is eligible to recover the VAT, the VAT is still normally an initial cash outflow, but it is not a permanent economic cost. Duty and excise are usually nonrecoverable.
4. Landed Cost and Cash Requirement
Landed cost measures the resources required to place goods at a specified destination in saleable condition. A general economic landed-cost model is:
LCe = Pg + O + F + I + D + Tnr + B + Ld + C + R
Pg is purchase price, O origin cost, F international freight, I insurance, D duty, Tnr nonrecoverable taxes, B brokerage, Ld destination logistics, C compliance cost, and R financing and risk cost. All values must relate to the same shipment and currency.
Recoverable tax is excluded from economic landed cost but included in initial cash requirement:
This distinction is essential for treasury planning.
Worked Example: DAP Purchase
A buyer imports goods under DAP for USD 60,000. Customs accepts a border value of USD 57,000 after deducting identifiable post-import delivery of USD 3,000. Duty is 6%, brokerage is USD 500, and import VAT is 19%. Local law includes the USD 3,000 delivery in the VAT base.
The recoverable VAT creates a USD 12,049.80 temporary funding requirement rather than disappearing from the cash-flow analysis.
4.1 DDP and import VAT responsibility
Under standard DDP, the seller is responsible for import clearance and applicable import duties and taxes, subject to mandatory local law. The seller must therefore determine whether it can legally act as importer, register for tax and recover import VAT. A buyer does not automatically recover import VAT paid in the seller’s name merely because it purchased the goods.
Consider a DDP transaction with:
Net sales revenue excluding separately accounted output VAT: USD 65,000
Customs value: USD 50,000
Duty rate: 10%
Import VAT rate: 20% on customs value plus duty
Seller’s other transaction costs: USD 46,000
Duty is USD 5,000 and import VAT is USD 11,000. The seller initially funds both amounts. If the seller is registered and legally entitled to recover the import VAT, transaction contribution before financing cost is:
Immediately before receiving the VAT refund, the same transaction may have generated only USD 3,000 of net cash after these stated outflows. If the USD 11,000 is recovered after 45 days and the annual funding rate is 9%, its approximate simple financing cost is:
11{,}000 × 0.09 × 45 ÷ 365 = USD\ 122.05
If the seller cannot recover import VAT, the VAT becomes an economic cost and contribution falls to USD 3,000. This demonstrates why DDP quotations require tax advice, importer-of-record capability and explicit cash-flow modelling.
5. Foreign-Exchange Exposure
Transaction exposure arises when a receivable or payable is denominated in a foreign currency. Let Qf be foreign-currency revenue and S the spot exchange rate expressed as home-currency units per foreign-currency unit. Home-currency revenue is:
Rh = Qf × S
The sensitivity of revenue to an exchange-rate change is:
∆Rh = Qf × ∆S
If a US exporter expects EUR 100,000, revenue is USD 108,000 at USD 1.08/EUR but only USD 102,000 at USD 1.02/EUR. With transaction costs of USD 98,000, contribution falls from USD 10,000 to USD 4,000.
A forward contract can lock in a rate. At a forward rate of USD 1.065/EUR, revenue is USD 106,500 and contribution is USD 8,500. The forward does not guarantee that this will be better than the future spot outcome; it reduces uncertainty.
Where home-currency costs are Ch and foreign-currency revenue is Qf, the simple break-even exchange rate is:
SBE = Ch ÷ Qf
This special case assumes no foreign-currency costs, taxes or nonlinear commissions. Those items require an expanded cash-flow model.
Common responses to currency risk include forward contracts, options, natural hedging, currency clauses, shorter quotation validity and matching foreign-currency receipts with payments. Hedging decisions should follow an approved treasury policy rather than speculative expectations.
6. Trade Analytics and Performance Indicators
Trade analytics integrates commercial, logistics, customs, tax and treasury data. Its purpose is not merely to report historical costs, but to identify cost leakage, test decisions and improve future quotations.
6.1 Core KPIs
KPI
Calculation or interpretation
Gross margin
(Revenue - COGS) ÷ Revenue
Contribution margin
Revenue less COGS and variable transaction costs, divided by revenue
Landed cost per unit
Economic landed cost divided by usable units received
Freight-to-sales ratio
Freight expense divided by net sales revenue
Duty rate realized
Duty paid divided by customs value
Duty leakage
Avoidable duty caused by errors or missed preferences
Quote conversion rate
Accepted quotations divided by valid quotations issued
On-time in-full (OTIF)
Complete orders delivered on or before the committed date
Demurrage per shipment
Demurrage expense divided by relevant shipments
Days sales outstanding
Average collection period for receivables
FX variance
Actual home-currency result compared with budget or hedged result
Forecast accuracy
Difference between forecast and actual volumes, costs or rates
A KPI requires a documented definition, owner, frequency, data source and threshold. For example, “freight cost” must state whether it includes fuel surcharges, terminal handling and inbound domestic transport.
6.2 Scenario and sensitivity analysis
Sensitivity analysis changes one input at a time to identify influential variables. Scenario analysis changes a coherent group of assumptions, such as an adverse case combining lower exchange rates, higher freight and delayed VAT recovery.
A useful model may include:
shipment volume and usable yield;
freight and fuel surcharges;
exchange rates and hedge ratios;
customs value and tariff classification;
preferential origin eligibility;
duty, excise and VAT rates;
delivery delay, storage and demurrage;
customer default probability and financing period.
Managers should not report a single landed-cost estimate without showing the assumptions and confidence range behind it.
7. Applied Case: Pricing Industrial Pumps for France
This is an illustrative case.
Background and problem
A US manufacturer is considering a DAP quotation for 1,000 industrial pumps delivered to Lyon. It proposes a price of EUR 110 per unit. The expected exchange rate is USD 1.10/EUR.
Seller costs are:
Cost
USD
COGS
72,000
Export packing and documents
4,000
Origin transport
2,000
Ocean freight
6,000
Insurance
700
Destination delivery
3,000
Total variable transaction cost
87,700
Profitability analysis
Revenue at the expected exchange rate is:
EUR\ 110{,}000 × 1.10 = USD\ 121{,}000
Gross margin, using COGS only, is:
GM = (121{,}000 - 72{,}000) ÷ 121{,}000 = 40.50\%
Contribution margin, after all listed variable costs, is:
CM = (121{,}000 - 87{,}700) ÷ 121{,}000 = 27.52\%
Buyer’s landed cost
Customs accepts EUR 104,000 as border value after deducting EUR 6,000 of identifiable post-import delivery from the DAP price. Duty is 5%. Import VAT is 20% and includes post-import delivery in its base. Brokerage is EUR 500.
Duty is EUR 5,200. The VAT base is EUR 115,200, comprising customs value of EUR 104,000, duty of EUR 5,200 and delivery of EUR 6,000. VAT is therefore EUR 23,040.
If the buyer can recover VAT, economic landed cost is:
The required unit price is approximately EUR 111.75.
Approach and outcome
Management decides to quote EUR 112 per unit, hedge 80% of the expected receivable, retain 20% for operational flexibility, and clearly state DAP Lyon, Incoterms® 2020. The dashboard will monitor contribution margin, freight variance, customs-value adjustments, OTIF performance and FX variance.
Learning points
The case demonstrates that gross margin can remain attractive while transaction contribution is exposed to logistics and exchange-rate movements. It also shows why recoverable VAT must be included in cash planning even when excluded from economic landed cost.
8. Governance, Technology and Contemporary Practice
Reliable analytics depends on accurate product masters, tariff codes, origin records, currency conventions and charge allocation. Poor master data can produce systematically incorrect quotations and customs declarations.
Trade compliance is also an ethical responsibility. Under-invoicing, false origin claims and deliberate tariff misclassification may reduce apparent landed cost but create penalties, shipment seizure, reputational damage and criminal exposure. Related-party prices must be consistent with customs and transfer-pricing requirements. Sanctions, export controls, forced-labour restrictions and environmental reporting obligations may affect both eligibility and cost.
Modern trade-management systems can combine enterprise-resource-planning data with carrier rates, tariff databases and customs records. Machine-learning tools may forecast freight or detect anomalies, but they should not autonomously determine legally binding tariff classifications or customs values without qualified review. Model assumptions, data lineage, access controls and override decisions should be auditable.
Best practice is to maintain a version-controlled quotation model, obtain current tariff and tax information, separate economic cost from cash flow, document Incoterms® assumptions, test adverse scenarios and reconcile estimated costs with actual shipment data.
Chapter Summary
Export pricing combines product cost, logistics, insurance, customs charges, taxation, financing and profit requirements. Gross margin must be calculated from revenue and COGS, whereas contribution margin also deducts variable selling and transaction costs. Freight and insurance depend on contractual rate structures, while customs value and import-tax bases are determined by applicable law rather than Incoterms® alone.
Economic landed cost excludes fully recoverable VAT, but initial cash requirement normally includes it. Under DDP, the seller handles import clearance and import taxes and must establish whether import VAT can be recovered in its own capacity. Exchange-rate scenarios, break-even analysis and hedging help control transaction exposure. Finally, well-defined KPIs and governed dashboards convert shipment data into better pricing, compliance and operational decisions.
Key Terms
Ad valorem duty: Customs duty calculated as a percentage of customs value.
Build-up pricing: Pricing method that adds relevant costs and required profit to a cost base.
Cash requirement: Funds needed to settle transaction outflows, including temporary recoverable taxes.
Chargeable weight: Weight used for freight billing, often the greater of actual and volumetric weight.
Contribution margin: Revenue remaining after COGS and variable transaction costs.
Customs value: Legally determined value used as a basis for customs duties.
DDP: Delivered Duty Paid; an Incoterms® rule under which the seller assumes import-clearance and tax obligations, subject to local law.
Duty leakage: Avoidable customs duty caused by errors or missed legal reliefs.
Economic landed cost: Permanent economic resources required to place goods at a destination.
Foreign-exchange exposure: Risk that currency movements alter home-currency cash flows or profit.
Gross margin: Revenue less COGS, expressed as a proportion of revenue.
Import VAT: Value-added tax collected at importation, potentially recoverable by an eligible importer.
Incoterms®: ICC rules allocating specified delivery costs, risks and responsibilities.
Insured value: Amount for which cargo is covered under an insurance policy.
Landed cost: Aggregate cost of obtaining goods at a specified destination and condition.
Markup: Profit increment expressed as a proportion of cost.
Scenario analysis: Evaluation of outcomes under coherent combinations of assumptions.
Transaction exposure: Currency risk associated with contracted foreign-currency receivables or payables.
Review Questions
Short Answer Questions
What information should appear in a complete export quotation?
How does gross margin differ from contribution margin?
Why may customs value differ from the commercial invoice value?
Why is recoverable import VAT included in initial cash requirement?
What responsibility does DDP place on the seller concerning import taxes?
Long Answer Questions
Explain how an exporter can construct prices for progressively broader delivery obligations.
Discuss the calculation and interpretation of economic landed cost and acquisition cash requirement.
Explain how customs duties, excise and import VAT interact in an import-tax calculation.
Evaluate the principal methods available for managing foreign-exchange transaction exposure.
Discuss how governance and data quality affect the reliability of trade analytics dashboards.
Analytical / Application Questions
A shipment has an invoice value of USD 80,000, dutiable freight and insurance of USD 5,000, duty of 7% and import VAT of 18% on customs value plus duty. Calculate customs value, duty, VAT and total border taxes.
An exporter expects to receive EUR 250,000 and has home-currency transaction costs of USD 255,000. Calculate the break-even USD/EUR rate and assess profitability at rates of 1.00, 1.08 and 1.15.
Design a dashboard for a company exporting refrigerated food. Select six KPIs and explain the managerial decision supported by each.
Multiple Choice Questions with Answers
Question 1
A firm reports net sales revenue of USD 200,000 and COGS of USD 120,000. What is its gross-margin rate?
A. 25%
B. 40%
C. 60%
D. 66.7%
Correct Answer: B. 40%
Question 2
Which formula correctly calculates contribution-margin rate when variable selling costs are outside COGS?
A. (R - COGS - VCs) ÷ R
B. (R - COGS) ÷ COGS
C. (R - VCs) ÷ COGS
D. (COGS + VCs) ÷ R
Correct Answer: A. (R - COGS - VCs) ÷ R
Question 3
Customs value is USD 20,000, duty is 10%, and import VAT is 20% of customs value plus duty. What are total duty and VAT?
A. USD 4,000
B. USD 4,400
C. USD 6,000
D. USD 6,400
Correct Answer: D. USD 6,400
Question 4
How should fully recoverable import VAT generally be treated in landed-cost analysis?
A. Excluded from both economic cost and initial cash requirement
B. Included permanently in economic cost only
C. Excluded from economic cost but included in initial cash requirement
D. Treated as customs duty
Correct Answer: C. Excluded from economic cost but included in initial cash requirement
Question 5
Under standard DDP, which party is responsible for import clearance and associated import taxes, subject to local law?
A. The seller
B. The buyer
C. The international carrier
D. The seller’s bank
Correct Answer: A. The seller
Question 6
Goods and freight before insurance are USD 10,000. Coverage is 110% and the premium is 1% of insured value, including the premium itself. What is the premium, rounded to cents?
A. USD 100.00
B. USD 110.00
C. USD 111.22
D. USD 121.00
Correct Answer: C. USD 111.22
Question 7
A US exporter receives EUR 50,000 when the rate is USD 1.08/EUR. What is the home-currency revenue?
A. USD 46,296
B. USD 50,000
C. USD 52,000
D. USD 54,000
Correct Answer: D. USD 54,000
Question 8
In the industrial-pump case, what is the buyer’s economic landed cost when import VAT is fully recoverable?
A. EUR 110,000
B. EUR 115,700
C. EUR 133,540
D. EUR 138,740
Correct Answer: B. EUR 115,700
Question 9
Which KPI most directly measures the proportion of valid quotations that become accepted orders?
A. OTIF
B. Duty rate realized
C. Quote conversion rate
D. Days sales outstanding
Correct Answer: C. Quote conversion rate
Question 10
An exporter expects foreign-currency revenue of EUR 100,000 and has home-currency costs of USD 88,000, with no foreign-currency costs. What is the simple break-even exchange rate?
A. USD 0.88/EUR
B. USD 1.00/EUR
C. USD 1.12/EUR
D. USD 1.88/EUR
Correct Answer: A. USD 0.88/EUR
Import-Export Operations & Documentation
Chapter 12
of 15