United Parcel Service Financial Model
Transportation Company Financials Example (Free Excel Download)
United Parcel Service (UPS) is one of the world's largest package delivery and supply chain management companies, providing integrated logistics solutions across more than 200 countries and territories.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for United Parcel Service (UPS), enabling an analyst to forecast the impact of macroeconomic shifts, union labour cost step-ups, and volume recovery on consolidated free cash flow and intrinsic value.
- What the company does: United Parcel Service (UPS) is one of the world's largest package delivery and supply chain management companies, providing integrated logistics solutions across more than 200 countries and territories.
- Business segments:
- U.S. Domestic Package (~65% of revenue)
- International Package (~20% of revenue)
- Supply Chain Solutions (~15% of revenue)
- Key geographies: Primarily the United States, followed by Europe, Asia-Pacific, and the Americas.
- Business model type: Asset-heavy, transaction-based logistics network.
- Competitive position: A dominant duopoly player in the US alongside FedEx (FDX), with significant global market share competing against DHL and increasingly Amazon Logistics.
- Recent major events: The 2023 Teamsters union contract negotiation which significantly increased labour costs; the 2024 divestiture of the Coyote Logistics truckload brokerage business; and the ongoing "Fit to Serve" and "Transformation 2.0" cost-reduction programmes.
The downloadable United Parcel Service 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 & AssumptionsUnited Parcel Service financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $97.29B | $100.34B | $90.96B | $91.07B | $88.66B |
| Income Before Income Taxes | $16.59B | $14.82B | $8.57B | $7.44B | $7.16B |
| Operating income | $12.81B | $13.09B | $9.14B | $8.47B | $7.87B |
| Net income | $12.89B | $11.55B | $6.71B | $5.78B | $5.57B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for United Parcel Service
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
U.S. Domestic Package
- Segment name: U.S. Domestic Package (Reported sub-lines: Next Day Air, Deferred, Ground)
- Revenue driver formula: `Average Daily Volume (ADV) x Operating Days x Average Revenue Per Piece (Yield)`
- Historical growth rate: (2.0%) to 2.0% CAGR (impacted by post-COVID normalisation and Amazon insourcing).
- Key growth levers and headwinds: E-commerce penetration, B2B volume recovery, SMB customer acquisition, offset by Amazon shifting volume to its own network.
- Pricing dynamics: Annual General Rate Increases (GRI) typically around 5.9%, plus dynamic fuel surcharges and peak season surcharges.
- Revenue recognition notes: Recognised over time as the delivery service is performed.
- Seasonality: Q4 is the strongest quarter by a wide margin due to the holiday peak season, requiring significant temporary labour and network flexing.
International Package
- Segment name: International Package (Reported sub-lines: Domestic, Export, Cargo & Other)
- Revenue driver formula: `Average Daily Volume (ADV) x Operating Days x Average Revenue Per Piece (Yield)`
- Historical growth rate: (3.0%) to 3.0% CAGR.
- Key growth levers and headwinds: Global trade flows, cross-border e-commerce, and macroeconomic conditions in Europe and Asia.
- Pricing dynamics: Premium pricing power due to complex customs brokerage and expedited cross-border air networks.
- Revenue recognition notes: Recognised over time as shipments transit the network.
- Seasonality: Similar to U.S. Domestic, Q4 is the peak, though slightly less pronounced than the US retail peak.
Supply Chain Solutions
- Segment name: Supply Chain Solutions (Reported sub-lines: Forwarding, Logistics, Other)
- Revenue driver formula: `Prior Year Revenue x (1 + Segment Growth Rate)` (Volume/Yield metrics are not uniformly reported for this segment).
- Historical growth rate: Highly volatile (declined ~10-15% recently due to the Coyote Logistics divestiture and freight market normalisation).
- Key growth levers and headwinds: Healthcare logistics expansion, complex supply chain outsourcing, offset by the loss of Coyote revenue.
- Pricing dynamics: Contractual logistics agreements and spot-market freight forwarding rates.
- Revenue recognition notes: Forwarding recognised over the transit period; logistics recognised as warehousing and fulfilment services are rendered.
- Seasonality: Less seasonal than package segments, driven more by industrial production and inventory restocking cycles.
Cost Structure
Variable Costs / COGS
*Note: UPS reports operating expenses by category rather than a traditional COGS / Gross Margin split.*
- Compensation and benefits: The largest expense (~50-55% of revenue), highly variable with volume but subject to strict union wage step-ups and pension obligations.
- Purchased transportation: Costs for third-party rail, truck, and air capacity (~15-18% of revenue).
- Fuel: Highly variable (~4-6% of revenue), largely offset by fuel surcharges on the revenue side.
- Other operating expenses: Maintenance, rent, and insurance.
- How costs scale: High operating leverage. The network requires a baseline of fixed routes and hubs; incremental volume drops through at a high margin, but volume declines cause severe margin deleverage.
Operating Expenses
- R&D: Not material / not separately disclosed.
- SG&A: Embedded within "Other operating expenses" and corporate allocations.
- Depreciation & Amortisation: ~3.5-4.5% of revenue, driven by heavy investments in aircraft, vehicles, and automated sorting facilities.
- Stock-Based Compensation: Relatively small as a % of revenue, typical for mature industrials.
- Restructuring / one-time charges: Frequent in recent years (e.g., "Fit to Serve" severance, multiemployer pension withdrawal charges, asset impairments).
Margin Profile
- Consolidated Operating Margin: 9.5% - 11.0%
- U.S. Domestic Operating Margin: 8.0% - 10.0% (lowest margin, highest volume).
- International Operating Margin: 18.0% - 21.0% (highest margin, premium services).
- Supply Chain Solutions Operating Margin: 7.0% - 9.5%.
- Margin trend: Compressing in 2023/2024 due to union wage increases and volume declines, but expected to expand back toward 10.5%+ as "Transformation 2.0" cost savings materialise and volume recovers.
Balance Sheet Structure
- Total assets: ~$65 - $70 billion.
- Key asset categories: Property, Plant and Equipment (PP&E) is the largest asset class (aircraft, package cars, automated hubs).
- Goodwill & intangibles: ~$7 - $9 billion, stemming from historical acquisitions (e.g., TNT Express routing, Bomi Group, MNX Global Logistics).
- Working capital profile:
- Days Sales Outstanding (DSO): ~35 - 40 days.
- Days Payable Outstanding (DPO): ~45 - 55 days.
- Net working capital as % of revenue: Typically negative or slightly positive. UPS collects receivables relatively quickly while stretching payables, providing a modest cash flow benefit during growth.
- PP&E: Depreciated over 15-30 years for aircraft and facilities, 5-10 years for vehicles and technology.
- Right-of-use assets / operating leases: Material (~$3 - $4 billion) due to leased aircraft, retail locations (The UPS Store), and warehouse space.
Capital Expenditure & Investment
- Capex as % of revenue: 4.0% - 5.5% (Targeting ~$3.5B - $4.5B annually).
- Maintenance capex vs. growth capex: Approximately 60% maintenance (fleet replacement, facility upkeep) and 40% growth (hub automation, new aircraft deliveries).
- Major capex programmes underway: "Network of the Future" automation initiatives, RFID tracking implementation, and fleet electrification.
- M&A pattern: Bolt-on acquirer focused on high-margin niches (e.g., healthcare logistics, reverse logistics like Happy Returns).
- Typical acquisition multiple paid: 10x - 14x EBITDA for specialised logistics assets.
Debt & Capital Structure
- Total debt: ~$25 - $28 billion (including finance leases).
- Debt/EBITDA ratio: 1.8x - 2.0x.
- Credit rating: A-tier (S&P: A, Moody's: A2).
- Key debt instruments: Unsecured senior notes across various maturities, commercial paper for short-term liquidity.
- Interest rate profile: Predominantly fixed-rate long-term bonds; weighted average cost of debt is historically low (~3.5% - 4.5%).
- Share repurchase programme: Active, typically ~$1.0 billion annually.
- Dividend policy: Very strong commitment to the dividend; ~$5.4 - $5.5 billion annual payout (yielding ~4.0%+ depending on share price).
Cash Flow Characteristics
- Operating cash flow conversion: Strong, typically $9.0B - $10.5B annually.
- Free cash flow margin: 5.0% - 7.0% of revenue (~$5.0B - $6.5B).
- Major non-cash items: D&A ($3.0B+), pension mark-to-market adjustments (can swing wildly by hundreds of millions based on discount rates).
- Working capital cash flow impact: Generally a minor source of cash in growing years, but a use of cash when volume declines.
- Capex intensity: High absolute dollars ($3.5B+) but manageable relative to massive OCF.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track the effective tax rate (~23.5%), though accelerated depreciation on equipment provides some deferred tax benefits.
Sheet Structure
- Assumptions: Hardcoded drivers for ADV, Yield, segment margins, CapEx, and capital return policies.
- Revenue Build:
- U.S. Domestic (Next Day Air, Deferred, Ground) driven by ADV x Yield.
- International (Domestic, Export, Cargo) driven by ADV x Yield.
- Supply Chain Solutions (Forwarding, Logistics, Other).
- Operating Expenses: Compensation & benefits, purchased transportation, fuel, other operating expenses, D&A.
- Income Statement: Consolidated P&L down to Net Income and EPS.
- Balance Sheet: Assets (Cash, A/R, PP&E, Goodwill, ROU Assets), Liabilities (A/P, Accrued Wages, Debt, Pension Liabilities, Leases), Equity.
- Cash Flow Statement: OCF (Net Income + D&A + Pension adjustments +/- NWC), CFI (CapEx, M&A), CFF (Debt issuance/repayment, Dividends, Buybacks).
- Debt & Interest Schedule: Tranches of senior notes, commercial paper, interest expense calculation.
- Working Capital Schedule: A/R, A/P, and Accrued Liabilities driven by DSO/DPO.
- PP&E & Depreciation Schedule: Base + CapEx - D&A.
- DCF Valuation: Unlevered free cash flow, WACC calculation, terminal value, implied share price.
Key Financial Relationships
- `U.S. Domestic Ground Revenue = U.S. Domestic Ground ADV x Operating Days x U.S. Domestic Ground Average Revenue Per Piece`
- `Total U.S. Domestic Revenue = Next Day Air Revenue + Deferred Revenue + Ground Revenue`
- `Total International Revenue = Domestic Revenue + Export Revenue + Cargo & Other Revenue`
- `Consolidated Revenue = Total U.S. Domestic Revenue + Total International Revenue + Supply Chain Solutions Revenue`
- `U.S. Domestic Operating Profit = Total U.S. Domestic Revenue x U.S. Domestic Operating Margin`
- `International Operating Profit = Total International Revenue x International Operating Margin`
- `Supply Chain Solutions Operating Profit = Supply Chain Solutions Revenue x Supply Chain Solutions Operating Margin`
- `Consolidated Operating Profit = U.S. Domestic Operating Profit + International Operating Profit + Supply Chain Solutions Operating Profit`
- `Compensation & Benefits Expense = Consolidated Revenue x Compensation % of Revenue (adjusted for union wage step-ups)`
- `Fuel Expense = Consolidated Revenue x Fuel % of Revenue (historically ~4-5%)`
- `Free Cash Flow = Cash from Operations - Capital Expenditures`
- `Dividends Paid = Shares Outstanding x Dividend Per Share`
Cross-Sheet Dependencies
- Revenue Build feeds the top line of the Income Statement.
- Segment Operating Margins from the Assumptions sheet drive the Operating Profit lines on the Income Statement.
- Income Statement Net Income feeds the top of the Cash Flow Statement and Retained Earnings on the Balance Sheet.
- Working Capital Schedule calculates changes in NWC, which feeds the Cash Flow Statement.
- PP&E & Depreciation Schedule calculates D&A, which feeds the Income Statement (Operating Expenses) and Cash Flow Statement (non-cash add-back).
- Debt & Interest Schedule calculates Interest Expense, feeding the Income Statement. *Circularity risk*: Interest expense lowers Net Income, which lowers Cash, which dictates debt paydown/drawdown, which changes Interest Expense. Use a circularity breaker (toggle).
- Cash Flow Statement ending cash feeds the Balance Sheet cash line.
Sign Convention
- Revenues and Assets: Positive.
- Expenses and Liabilities: Positive in their supporting schedules, but subtracted in the Income Statement and Balance Sheet equations.
- Cash Flow Statement: Cash inflows are positive; cash outflows (CapEx, dividends, debt repayment) are negative.
- Margins and Growth Rates: Displayed as percentages (e.g., 10.5%, not 0.105 in text, but calculated as 0.105).
Things Most Likely to Go Wrong
- Coyote Logistics Divestiture: UPS sold Coyote in 2024. Historical Supply Chain Solutions revenue includes Coyote, but future forecasts must exclude it. The model must step down SCS revenue appropriately in the base year.
- Pension Mark-to-Market: UPS frequently reports massive non-cash pension adjustments in Q4. The model should forecast operating profit *excluding* these unpredictable MTM adjustments (Non-GAAP basis).
- Operating Days: Package volume is reported as Average Daily Volume (ADV). The model must multiply ADV by the exact number of operating days in the quarter/year (typically 253-255 days annually), not 365.
- Union Wage Step-Ups: The 2023 Teamsters contract front-loaded wage increases. Compensation as a % of revenue spiked in 2023/2024 and will normalise. Do not straight-line historical compensation ratios.
- Fuel Surcharges: Fuel costs and fuel surcharge revenues naturally hedge each other. If you forecast a drop in fuel expense, you must also forecast a corresponding drop in Yield (Revenue Per Piece).
- Amazon Insourcing: Amazon is UPS's largest customer (historically ~11% of revenue) but is actively insourcing. U.S. Domestic volume growth assumptions must account for this structural headwind.
- Capital Expenditures: UPS guides to absolute CapEx dollars (e.g., $3.5B for 2025), not a strict percentage of revenue. The model should allow hardcoding of the guided dollar amount in the near term.
- Share Count: UPS actively repurchases shares. The EPS calculation must use a dynamically calculated weighted average share count that reduces over time based on the buyback assumption.
Validation Checks
- "Consolidated Operating Margin should be in the 9.5% - 11.0% range; flag if outside this band."
- "U.S. Domestic Operating Margin should not exceed International Operating Margin (International is structurally more profitable)."
- "CapEx should be approximately $3.5B - $4.5B annually; flag if it exceeds 6.0% of revenue."
- "Debt/EBITDA should remain between 1.5x and 2.5x to maintain the A-tier credit rating."
- "Free Cash Flow must comfortably cover the ~$5.5B annual dividend payment (FCF Payout Ratio < 100%)."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Effective tax rate should be approximately 23.5%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| U.S. Domestic ADV Growth | 1.5 | % | Modest recovery post-2023/2024 volume declines, offset by Amazon insourcing. |
| U.S. Domestic Yield Growth | 2.5 | % | Driven by annual GRI and mix shift to higher-yielding SMBs. |
| International ADV Growth | 2.0 | % | Stabilisation of global trade and cross-border e-commerce. |
| International Yield Growth | 1.5 | % | Normalisation of air freight rates post-pandemic. |
| Supply Chain Solutions Growth | 2.0 | % | Baseline growth, adjusting for the Coyote divestiture base effect. |
| U.S. Domestic Operating Margin | 9.5 | % | Management guidance and historical average post-union contract. |
| International Operating Margin | 18.5 | % | Historical premium margin profile for cross-border services. |
| Supply Chain Solutions Margin | 8.5 | % | Historical average for forwarding and logistics. |
| Operating Days per Year | 254 | Days | Standard UPS operating calendar (excludes weekends and major holidays). |
| Capital Expenditures | 3,500 | $ Millions | Management guidance for 2025. |
| Effective Tax Rate | 23.5 | % | Management guidance and historical average. |
| Annual Dividend | 5,500 | $ Millions | Management guidance for 2025 capital return. |
| Annual Share Repurchases | 1,000 | $ Millions | Management guidance for 2025 capital return. |
| Cost of Debt | 4.2 | % | Weighted average interest rate on existing senior notes. |
| WACC | 8.0 | % | Standard discount rate for mature, large-cap industrials. |
| Terminal Growth Rate | 2.0 | % | Aligned with long-term GDP growth. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the UPS Investor Relations website (investors.ups.com) for quarterly earnings presentations and non-GAAP reconciliations.
- Key Peers: FedEx (FDX), DHL Group (DHL.DE), XPO Logistics (XPO), C.H. Robinson (CHRW).
- Industry Data: Cass Freight Index, Pitney Bowes Parcel Shipping Index, ATA Truck Tonnage Index.
- Consensus Estimates: FactSet or Bloomberg for ADV and Yield consensus figures.
Sources
Do more with the United Parcel Service model
Frequently asked
What does United Parcel Service (UPS) do?+
United Parcel Service (UPS) is a global leader in package delivery and supply chain management, providing integrated logistics solutions across more than 200 countries and territories. It operates through its U.S. Domestic Package, International Package, and Supply Chain Solutions segments.
What are the primary revenue drivers for UPS?+
UPS's revenue is primarily driven by its asset-heavy, transaction-based logistics network, with its U.S. Domestic Package segment contributing approximately 65% of total revenue. Key factors influencing revenue include package volume, pricing strategies, and global economic activity.
What is UPS's typical capital expenditure as a percentage of revenue?+
UPS targets capital expenditure between 4.0% and 5.5% of revenue, which translates to approximately $3.5B - $4.5B annually. This investment is split, with about 60% allocated to maintenance and 40% to growth initiatives like network automation and fleet electrification.
How do labor costs impact UPS's financial performance?+
Labor costs are a significant factor for UPS, notably impacted by events such as the 2023 Teamsters union contract negotiation which led to increased expenses. The company also implements cost-reduction programs like "Fit to Serve" and "Transformation 2.0" to manage these operational costs.
What are the key inputs for a discounted cash flow (DCF) valuation of UPS?+
Key inputs for a DCF valuation of UPS include assumptions for revenue growth, cost of goods sold as a percentage of revenue, and capital expenditure as a percentage of revenue. The model also considers the impact of macroeconomic shifts and union labor costs on consolidated free cash flow.
Can I download an Excel financial model for United Parcel Service (UPS)?+
Yes, a comprehensive Excel financial model for United Parcel Service (UPS) is available for download. This model serves as an equity valuation and scenario planning tool, enabling analysts to forecast the impact of various factors on free cash flow and intrinsic value.
Have more financial modelling questions? Contact us
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.
C.H. Robinson
C.H.
CSX
CSX Corporation is a premier Class I freight railroad operating a 20,000 route-mile network across the eastern United States and parts of Canada.
Delta Air Lines
Delta Air Lines is one of the world's largest global network airlines, providing scheduled air transportation for passengers and cargo.
Expeditors International
Expeditors International of Washington, Inc.
FedEx
FedEx Corporation provides a broad portfolio of transportation, e-commerce, and business services globally.
J.B. Hunt
J.B.
Southwest Airlines
Southwest Airlines (NYSE: LUV) is a major US passenger airline operating a low-cost carrier (LCC) business model primarily focused on domestic point-to-point transit.
Norfolk Southern
Norfolk Southern Corporation is a premier Class I freight railroad operating an extensive network of approximately 19,200 route miles across 22 states and the District of Columbia in the eastern United States.
Explore more Manufacturing financial model templates.
