Expeditors International logo
Expeditors International Financial Model

Transportation Company Financials Example (Free Excel Download)

Expeditors International of Washington, Inc. is a non-asset-based global logistics provider headquartered in Seattle, Washington.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive equity valuation and scenario analysis framework for Expeditors International (EXPD), enabling an analyst to forecast earnings and cash flows based on global trade volumes, freight rate volatility, and the company's highly variable, asset-light cost structure.

Expeditors International of Washington, Inc. is a non-asset-based global logistics provider headquartered in Seattle, Washington. The company purchases cargo space from airlines and ocean carriers in bulk and resells it to customers, while also providing customs brokerage and supply chain management services.

  • Business Segments:
  • Airfreight Services (~35% of gross revenues)
  • Ocean Freight and Ocean Services (~30% of gross revenues)
  • Customs Brokerage and Other Services (~35% of gross revenues)
  • Key Geographies: Truly global, with significant revenue originating in Asia (North Asia and South Asia combined represent >40% of revenues), followed by the United States, Europe, and the Middle East/Africa.
  • Business Model Type: Asset-light freight forwarder. The company does not own the aircraft or ships it uses to transport customer cargo.
  • Competitive Position: A top-tier global freight forwarder and customs broker, competing with Kuehne+Nagel, DHL Global Forwarding, DSV, and C.H. Robinson.
  • Recent Major Events: The company experienced massive volatility during the pandemic and subsequent Red Sea disruptions, which temporarily drove freight rates and net revenues to record highs, followed by a normalisation period in 2024 and 2025.

The downloadable Expeditors International financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsExpeditors International financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$16.52B$17.07B$9.30B$10.60B$11.07B
Total operating expenses$14.61B$15.25B$8.36B$9.56B$10.02B
Operating income$1.91B$1.82B$939.9M$1.04B$1.05B
Net income$1.42B$1.36B$752.9M$810.1M$810.3M

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
4.0%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
0.3%
D&A % of revenue
0.5%
Effective tax rate
26.1%
See 8 more
Capex % of revenue
0.4%
Net working capital % of revenue
17.1%
Other assets % of revenue
14.3%
Other liabilities % of revenue
24.7%
Annual debt paydown
0.0%
Interest rate on debt
4.5%
Dividend payout ratio
22.1%
Buybacks % of net income
90.3%

How to build a detailed financial model for Expeditors International

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

*Note: For freight forwarders, "Net Revenue" (Gross Revenue minus the cost of transportation) is the primary metric of value creation, acting effectively as gross profit.*

Airfreight Services

  • Segment Name: Airfreight services
  • Revenue Driver Formula: Airfreight Tonnage (kilos) x Average Sell Rate per Kilo
  • Historical Growth Rate: Highly volatile; 3-5 year CAGR is distorted by pandemic spikes, but normalised volume growth is typically 2-4%.
  • Key Growth Levers and Headwinds: Global technology product launches, e-commerce demand (de minimis shipments), and passenger airline belly capacity (which dictates supply).
  • Pricing Dynamics: Spot market driven. Expeditors benefits when rates are volatile because their buy-rates (cost) and sell-rates (revenue) decouple, allowing for margin expansion.
  • Seasonality: Q4 is historically the strongest due to the holiday retail peak season and consumer electronics launches.

Ocean Freight and Ocean Services

  • Segment Name: Ocean freight and ocean services
  • Revenue Driver Formula: Ocean Container Volume (FEU - Forty-foot Equivalent Units) x Average Sell Rate per FEU
  • Historical Growth Rate: Normalised volume growth of 2-5%.
  • Key Growth Levers and Headwinds: Global GDP growth, inventory restocking cycles, and geopolitical disruptions (e.g., Red Sea transit diversions, port strikes) which constrain capacity and drive up rates.
  • Pricing Dynamics: A mix of contractual and spot rates.
  • Seasonality: Q3 is typically strong as retailers import goods ahead of the holiday season.

Customs Brokerage and Other Services

  • Segment Name: Customs brokerage and other services
  • Revenue Driver Formula: Number of Customs Declarations x Fee per Declaration + Warehousing/Distribution Fees
  • Historical Growth Rate: 5-8% CAGR (more stable than freight forwarding).
  • Key Growth Levers and Headwinds: Trade tariff complexity (which drives demand for brokerage advice) and nearshoring trends.
  • Pricing Dynamics: Fee-based and highly sticky. This is the highest-margin segment.
  • Seasonality: Less seasonal than freight, generally tracks overall trade volumes.

Cost Structure

Variable Costs / COGS

  • Line Item: "Directly related cost of transportation and other expenses"
  • What it includes: The cost of buying space from airlines, ocean carriers, and trucking companies.
  • Gross Margin (Net Revenue Margin) Range:
  • Airfreight: 20-25%
  • Ocean Freight: 15-22%
  • Customs Brokerage: 45-55%
  • Scaling: Scales directly with gross revenue, but the *spread* (Net Revenue) expands during times of capacity shortage and contracts when capacity is abundant.

Operating Expenses

  • Salaries and Related Costs: The largest operating expense. Expeditors uses a unique compensation structure where a significant portion of branch management and executive compensation is paid as a strict percentage of pre-bonus operating income. This makes salaries highly variable and protects margins during downturns.
  • Other Operating Expenses: Rent and occupancy, IT/communications, depreciation, and amortisation.
  • R&D: Not material; IT development is capitalised or expensed in other operating expenses.
  • Stock-Based Compensation: Relatively low compared to tech, typically 1-2% of net revenues.

Margin Profile

  • Operating Margin: Expeditors measures this as Operating Income / Net Revenue (not Gross Revenue). The historical target and typical achievement is ~30%.
  • Net Margin: 6-8% of Gross Revenue, but more meaningfully ~22-25% of Net Revenue.

Balance Sheet Structure

  • Total Assets: ~$4.5 - $5.0 billion.
  • Key Asset Categories: Cash and cash equivalents (very high, often >$1.0 billion), Accounts Receivable (highly correlated with gross revenues and freight rates).
  • Goodwill & Intangibles: Extremely low. Expeditors is famous for organic growth and almost never does M&A.
  • Working Capital Profile:
  • DSO: 45-55 days.
  • DPO: 35-45 days.
  • DIO: N/A (no physical inventory).
  • Net Working Capital: Positive. Because they pay carriers slightly faster than they collect from shippers, rapid revenue growth consumes cash, while revenue contraction releases cash.
  • PP&E: Very light. Mostly warehouse equipment, office build-outs, and IT hardware.
  • Right-of-use Assets: Material due to leased warehouse and office space globally.

Capital Expenditure & Investment

  • Capex as % of Net Revenue: 1.5% - 2.5% (extremely low).
  • Maintenance vs. Growth: Mostly IT infrastructure and software development, plus warehouse facility upgrades.
  • M&A Pattern: Strictly organic. The company has a long-standing cultural aversion to acquisitions.

Debt & Capital Structure

  • Total Debt: $0. Expeditors carries no long-term debt.
  • Cash Balance: Typically $1.0B - $1.5B.
  • Credit Rating: Unrated (no debt).
  • Share Repurchase Programme: Highly active. The company routinely returns excess cash via buybacks, often repurchasing 3-5% of outstanding shares annually (e.g., ~$1.1 billion returned in 2024).
  • Dividend Policy: Consistent dividend payer (Dividend Aristocrat). Payout ratio is typically 25-35% of net income.

Cash Flow Characteristics

  • OCF / Net Income: Typically 1.0x - 1.2x. However, during periods of rapidly rising freight rates, working capital expansion can temporarily drag this below 1.0x.
  • Free Cash Flow Margin: Very high due to negligible capex. FCF roughly equals Net Income in steady-state environments.
  • Cash Tax Rate: ~26-28%, generally tracking the GAAP effective tax rate.

Sheet Structure

  1. Assumptions: Hardcoded drivers for volumes, buy/sell rates, net revenue margins, and capital return policies.
  2. Income Statement: Gross revenues, cost of transportation, net revenues, salaries, other opex, operating income, net income.
  3. Balance Sheet: Cash, AR, AP, ROU assets, lease liabilities, equity.
  4. Cash Flow Statement: Net income, D&A, working capital changes, capex, dividends, share repurchases.
  5. Segment Build: Detailed volume and yield assumptions for Airfreight, Ocean Freight, and Customs Brokerage.
  6. Working Capital Schedule: AR and AP driven by DSO and DPO against gross revenues and transportation costs.
  7. Shareholders' Equity & Shares: Tracking retained earnings, dividend payouts, and the shrinking share count from buybacks.
  8. DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value.

Key Financial Relationships

  1. `Airfreight Gross Revenue = Airfreight Tonnage x Average Airfreight Sell Rate`
  2. `Ocean Freight Gross Revenue = Ocean FEU Volume x Average Ocean Sell Rate`
  3. `Total Gross Revenue = Airfreight Gross Revenue + Ocean Freight Gross Revenue + Customs Brokerage Gross Revenue`
  4. `Net Revenue (by segment) = Gross Revenue x Net Revenue Margin %`
  5. `Directly Related Cost of Transportation = Total Gross Revenue - Total Net Revenue`
  6. `Salaries and Related Costs = Fixed Base Salaries + (Pre-Bonus Operating Income x Historical Bonus Payout %)`
  7. `Operating Income = Total Net Revenue - Salaries and Related Costs - Other Operating Expenses`
  8. `Operating Margin = Operating Income / Total Net Revenue`
  9. `Accounts Receivable = (Total Gross Revenue / 365) x DSO`
  10. `Accounts Payable = (Directly Related Cost of Transportation / 365) x DPO`
  11. `Share Count = Prior Period Share Count - (Share Repurchase $ / Average Share Price)`
  12. `Dividends Paid = Share Count x Dividend per Share`

Cross-Sheet Dependencies

  • The Segment Build is the foundation. It calculates Gross Revenues and Net Revenues, which feed directly into the top lines of the Income Statement.
  • The Income Statement generates Net Income, which feeds the top of the Cash Flow Statement and Retained Earnings on the Balance Sheet.
  • The Working Capital Schedule uses Gross Revenues and Cost of Transportation from the Income Statement to calculate AR and AP, which feed the Balance Sheet and the operating cash flow section of the Cash Flow Statement.
  • The Shareholders' Equity & Shares sheet uses cash flow available for buybacks to reduce the share count, which feeds back into the EPS calculation on the Income Statement.

Sign Convention

  • Revenues and Net Revenues: Positive.
  • Expenses (Cost of Transportation, Salaries, Opex): Positive in their specific schedules, subtracted in the Income Statement to yield profit.
  • Assets: Positive.
  • Liabilities and Equity: Positive.
  • Cash Flow: Cash inflows are positive; cash outflows (capex, dividends, buybacks) are negative.

Things Most Likely to Go Wrong

  1. Focusing on Gross Margin instead of Net Revenue Margin: Freight forwarders pass through the cost of freight. Margins must be modelled as a percentage of *Net Revenue*, not Gross Revenue.
  2. Modelling Salaries as Fixed: Expeditors' compensation is highly variable. If revenues drop, bonuses drop mechanically. Modelling salaries as a fixed % of revenue will understate their downside margin protection.
  3. Assuming M&A Growth: Expeditors does not acquire companies. All forecasted growth must be organic.
  4. Adding Debt: The company has zero debt. Do not model interest expense or debt paydown schedules.
  5. Working Capital Disconnect: AR is tied to *Gross Revenue*, but AP is tied to *Cost of Transportation*. If freight rates spike, working capital will consume massive amounts of cash.
  6. Overestimating Capex: This is an asset-light business. Capex should rarely exceed 2% of Net Revenue.
  7. Ignoring Share Count Reduction: The company aggressively buys back stock. Failing to model the shrinking share count will severely understate EPS growth.
  8. Misunderstanding Customs Brokerage: This segment has much higher Net Revenue margins (~45-55%) than the freight segments. Mix shifts toward Customs will expand overall company margins.

Validation Checks

  1. "Operating Income / Total Net Revenue should be approximately 28-32%; flag if outside this band."
  2. "Total Debt must equal $0 in all forecast periods."
  3. "Capex as a % of Net Revenue should be between 1.5% and 2.5%."
  4. "Free Cash Flow should be roughly equal to Net Income (FCF conversion ~95-105%)."
  5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  6. "Effective tax rate should be 26-28%."
  7. "DSO should remain in the 45-55 day range; DPO should remain in the 35-45 day range."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Airfreight Volume Growth3.0%Long-term historical organic growth trend
Ocean Freight Volume Growth3.0%Long-term historical organic growth trend
Customs Brokerage Revenue Growth5.0%Sticky, fee-based business with steady growth
Airfreight Net Revenue Margin23.0%Historical average spread
Ocean Freight Net Revenue Margin18.0%Historical average spread
Customs Brokerage Net Revenue Margin50.0%High-margin, fee-based service
Salaries as % of Net Revenue52.0%Reflects base pay plus highly variable bonus structure
Other Opex as % of Net Revenue18.0%Rent, IT, and administrative costs
DSO (Days Sales Outstanding)50DaysBased on recent balance sheet receivables vs gross revenue
DPO (Days Payable Outstanding)40DaysBased on recent balance sheet payables vs cost of transportation
Capex as % of Net Revenue2.0%Asset-light business model
Effective Tax Rate27.0%Recent historical average
Annual Share Repurchases800$ MillionsConsistent return of capital policy
Dividend Payout Ratio30.0%Historical average payout of net income
WACC8.5%Zero debt capital structure, standard equity risk premium
Terminal Growth Rate2.0%Aligned with long-term global GDP growth

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Expeditors Investor Relations website.
  • Key Peers for Benchmarking: Kuehne+Nagel (KNIN.SW), DSV A/S (DSV.CO), C.H. Robinson (CHRW), DHL Group (DHL.DE).
  • Industry Data Sources: Drewry (for ocean freight rates and container volumes), TAC Index or Baltic Exchange (for airfreight rates), and IATA (for global air cargo demand).
  • Consensus Estimates: FactSet, Bloomberg, or Zacks Investment Research for near-term EPS and Net Revenue estimates.

Sources

Frequently asked

What is Expeditors International's business model?+

Expeditors International is an asset-light global logistics provider headquartered in Seattle, Washington. The company purchases cargo space from airlines and ocean carriers in bulk and resells it to customers, while also providing customs brokerage and supply chain management services.

How does Expeditors International generate its revenue?+

Expeditors generates revenue primarily through its Airfreight Services, Ocean Freight and Ocean Services, and Customs Brokerage and Other Services segments. For freight forwarders like Expeditors, "Net Revenue" (Gross Revenue minus the cost of transportation) is the primary metric of value creation.

What are the key assumptions in the Expeditors International financial model?+

The financial model for Expeditors International includes key assumptions such as Revenue Growth at approximately 4%, COGS as 55% of Revenue, and a Tax Rate of about 26%. Other significant assumptions cover SGA, DA, and Capex as percentages of revenue.

How does Expeditors International's working capital profile impact its cash flow?+

Expeditors International maintains a positive Net Working Capital, characterized by a DSO of 45-55 days and DPO of 35-45 days. This profile means that rapid revenue growth consumes cash because the company pays carriers slightly faster than it collects from shippers, while revenue contraction releases cash.

What is the purpose of the financial model for Expeditors International?+

The financial model provides a comprehensive equity valuation and scenario analysis framework for Expeditors International (EXPD). It enables an analyst to forecast earnings and cash flows based on global trade volumes, freight rate volatility, and the company's asset-light cost structure.

Can I download an Excel financial model for Expeditors International?+

Yes, a downloadable Excel financial model is available for Expeditors International (EXPD). This model offers a forecast horizon from FY2026 to FY2030, providing a detailed framework for financial analysis and valuation.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Transportation Company Financial Models

Browse another company in the same sector.

Explore more Manufacturing financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview