# Union Pacific (UNP) Financial Model

Free Excel 3-statement financial model and company analysis for Union Pacific.

- Canonical: https://finamodel.com/companies/union-pacific
- Industry: Transportation
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/UNP.xlsx

## Model Purpose

To evaluate Union Pacific's equity valuation and cash flow generation capacity by forecasting carload volumes, pricing power, and operating ratio improvements in a cyclical macro environment.

## Company Overview

Union Pacific Corporation (UNP) operates the largest Class I freight railroad in the United States, connecting 23 western states and serving major West Coast and Gulf Coast ports.
The company's business mix is divided into three main segments: Bulk (approximately 33% of freight revenue), Industrial (approximately 36%), and Premium (approximately 31%).
Geographically, the network covers the western two-thirds of the US, with critical connections to Canada and all six major Mexico gateways.
The business model is highly asset-heavy, requiring massive continuous capital investment in track and locomotives, but it benefits from immense barriers to entry and significant operating leverage.
Competitively, Union Pacific operates in a duopoly in the Western US alongside BNSF Railway.
Recently, the company delivered record freight revenues (excluding fuel) in 2025, achieved an improved operating ratio of 59.8%, and navigated labour agreement ratifications while returning significant capital to shareholders through a $4.0 billion share repurchase programme.

## Revenue Deep Dive



### Bulk

- **Segment name:** Bulk (includes Grain & grain products, Fertilizer, Food & refrigerated, Coal & renewables).
- **Revenue driver formula:** Bulk Carloads x Bulk Average Revenue per Car (ARC).
- **Historical growth rate:** 1-3% revenue CAGR, driven primarily by pricing rather than volume.
- **Key growth levers and headwinds:** Supported by renewable biofuels and export grain demand, but faces secular headwinds from the long-term decline in coal demand.
- **Pricing dynamics:** Contractual with strong core pricing power above inflation.
- **Revenue recognition notes:** Recognised over time as freight moves from origin to destination.
- **Seasonality:** Strongest in Q4 due to the autumn grain harvest.

### Industrial

- **Segment name:** Industrial (includes Industrial chemicals & plastics, Metals & minerals, Forest products, Energy & specialized markets).
- **Revenue driver formula:** Industrial Carloads x Industrial Average Revenue per Car (ARC).
- **Historical growth rate:** 2-4% revenue CAGR.
- **Key growth levers and headwinds:** Highly correlated with US industrial production, housing starts (lumber), and petrochemical plant expansions in the Gulf Coast.
- **Pricing dynamics:** High pricing power due to the hazardous or heavy nature of the materials, which are difficult to shift to trucks.
- **Revenue recognition notes:** Recognised over time as shipments transit the network.
- **Seasonality:** Relatively stable, with slight dips in Q1 due to winter weather slowing construction.

### Premium

- **Segment name:** Premium (includes Automotive and Intermodal).
- **Revenue driver formula:** Premium Carloads x Premium Average Revenue per Car (ARC).
- **Historical growth rate:** 0-2% revenue CAGR, highly volatile based on macro conditions.
- **Key growth levers and headwinds:** Driven by West Coast port import volumes, consumer spending, and automotive production. Vulnerable to supply chain shifts and trucking competition.
- **Pricing dynamics:** Highly competitive with the trucking industry, limiting pricing power compared to Bulk and Industrial.
- **Revenue recognition notes:** Recognised over time.
- **Seasonality:** Peaks in late Q3 and Q4 ahead of the holiday retail season.

### Fuel Surcharge Revenue

- **Segment name:** Fuel Surcharge Revenue.
- **Revenue driver formula:** Total Carloads x Fuel Surcharge per Carload.
- **Historical growth rate:** Highly volatile, directly tied to highway diesel prices.
- **Key growth levers and headwinds:** Acts as a hedge against rising fuel expenses.
- **Pricing dynamics:** Mechanically pegged to the On-Highway Diesel Fuel Price index with a two-month lag.

## Cost Structure



### Variable Costs / COGS

Railroads do not report traditional COGS. Instead, operating expenses are grouped together. The most variable costs are:
- **Fuel:** Represents 10-14% of revenue. Driven by Gross Ton-Miles (GTMs) and the fuel consumption rate (gallons per thousand GTMs). Highly exposed to diesel commodity prices.
- **Purchased services and materials:** Represents 8-10% of revenue. Covers locomotive maintenance, track repairs, and contractor services. Scales with network volume but has fixed components.
- **Equipment and other rents:** Represents 3-4% of revenue. Costs for using other railroads' cars and short-term equipment leases.

### Operating Expenses

- **Compensation and benefits:** The largest expense, representing 25-28% of revenue. Driven by union labour agreements, crew sizes, and workforce productivity (measured in car miles per employee).
- **Depreciation:** Represents 9-11% of revenue. Exclusively tangible assets (track, locomotives, facilities). Intangibles are negligible.
- **Stock-Based Compensation:** Immaterial relative to total compensation.
- **Restructuring / one-time charges:** Occasional labour buyout charges or merger-related costs (e.g. $40 million labour expense in Q4 2024, $30 million merger costs in Q4 2025).

### Margin Profile

- **Operating Ratio (OR):** The primary profitability metric for railroads (Operating Expenses / Operating Revenue). UNP's OR typically ranges from 58% to 61% (59.8% reported in 2025).
- **Operating Margin:** The inverse of OR (100% - OR), typically 39% to 42%.
- **Net Margin:** Typically 26% to 29%.
- **Margin trend:** Stable to slightly expanding as the company implements precision scheduled railroading (PSR) principles to drive workforce and locomotive productivity.

## Balance Sheet Structure

- **Total assets:** Approximately $65-70 billion.
- **Key asset categories:** The balance sheet is dominated by Net Property, Plant, and Equipment (PP&E), which accounts for over 85% of total assets.
- **Goodwill & intangibles:** Minimal (less than 5% of assets), as growth is primarily organic.
- **Working capital profile:**
  - **Days Sales Outstanding (DSO):** 30-35 days.
  - **Days Payable Outstanding (DPO):** 40-45 days.
  - **Net working capital:** Typically negative. The company collects cash from customers faster than it pays suppliers, providing a slight funding advantage.
- **PP&E:** Consists of track structure, land, locomotives, and freight cars. Useful lives are extremely long (up to 40-50 years for track and structures).
- **Right-of-use assets:** Operating leases for certain equipment and facilities are present but not the primary driver of the capital base.

## Capital Expenditure & Investment

- **Capex as % of revenue:** Typically 13-15% (e.g. $3.4 billion on $24.5 billion revenue in 2025).
- **Maintenance vs growth capex:** Approximately 55-60% is maintenance (infrastructure replacement like ties and ballast), 15-20% is capacity expansion, and the remainder is equipment and technology.
- **Major capex programmes:** Continuous track replacement, siding extensions for longer trains, and locomotive modernisations.
- **Capitalised software:** Minor relative to hard asset investments.
- **M&A pattern:** Historically an organic grower, though recent filings reference regulatory processes for a potential transcontinental railroad merger.

## Debt & Capital Structure

- **Total debt:** Approximately $30-33 billion.
- **Debt/EBITDA ratio:** Management targets an adjusted Debt/EBITDA ratio of approximately 2.6x to 2.8x.
- **Credit rating:** Solid investment grade (A- / Baa1).
- **Key debt instruments:** Long-term unsecured bonds with staggered maturities, supported by a revolving credit facility.
- **Interest rate profile:** Predominantly fixed-rate long-term debt to match the long-duration asset base.
- **Share repurchase programme:** Highly active. The company repurchased $1.5 billion in 2024 and targets $4.0 to $4.5 billion annually, using debt to maintain target leverage as EBITDA grows.
- **Dividend policy:** Target payout ratio of approximately 45% of net income. The company has increased its dividend for 19 consecutive years.

## Cash Flow Characteristics

- **Operating cash flow conversion:** Very strong, typically 1.2x to 1.3x Net Income (e.g. $9.3 billion OCF on $7.1 billion Net Income in 2025).
- **Free cash flow margin:** 20-25% of revenue.
- **Major non-cash items:** Depreciation is the massive bridge between Net Income and OCF, adding back over $2.5 billion annually.
- **Working capital cash flow impact:** Minor fluctuations year-to-year, not a primary driver of cash generation.
- **Capex intensity:** High. Capex consumes roughly 35-40% of Operating Cash Flow.
- **Cash tax rate:** Closely tracks the GAAP effective tax rate of 23-24%.

## Sheet Structure

1. **Assumptions:** Hardcoded drivers for macro indicators, segment volume growth, pricing (ARC) growth, fuel prices, and margin targets.
2. **Volume & Revenue:** Row-level detail for Carloads, Average Revenue per Car, and Freight Revenue across Bulk, Industrial, and Premium segments. Includes Fuel Surcharge calculation.
3. **Operating Expenses:** Line items for Compensation and benefits, Fuel, Purchased services and materials, Depreciation, and Equipment rents. Calculates the Operating Ratio.
4. **Income Statement:** Consolidated GAAP view from Operating Revenue down to Net Income and EPS.
5. **Balance Sheet:** Highlights the massive Net PP&E line, working capital accounts, and long-term debt.
6. **Cash Flow Statement:** Reconciles Net Income to OCF (heavy depreciation add-back), subtracts Capex for FCF, and details share repurchases and dividends.
7. **Debt & Interest Schedule:** Tracks debt tranches, calculates interest expense, and monitors the Adjusted Debt/EBITDA target.
8. **PP&E & Capex Schedule:** Roll-forward of gross PP&E, accumulated depreciation, and capital expenditures.
9. **DCF Valuation:** Calculates WACC, unlevered free cash flow, terminal value, and implied share price.

## Key Financial Relationships

1. `Bulk Freight Revenue = Bulk Carloads * Bulk Average Revenue per Car`
2. `Industrial Freight Revenue = Industrial Carloads * Industrial Average Revenue per Car`
3. `Premium Freight Revenue = Premium Carloads * Premium Average Revenue per Car`
4. `Total Freight Revenue = Bulk Freight Revenue + Industrial Freight Revenue + Premium Freight Revenue`
5. `Fuel Surcharge Revenue = Total Carloads * Fuel Surcharge per Carload`
6. `Total Operating Revenue = Total Freight Revenue + Fuel Surcharge Revenue + Other Revenue`
7. `Operating Ratio = Total Operating Expenses / Total Operating Revenue`
8. `Fuel Expense = (Gross Ton-Miles / 1000) * Fuel Consumption Rate * Price per Gallon`
9. `Workforce Productivity = Total Car Miles / Average Employees`
10. `Operating Income = Total Operating Revenue - Total Operating Expenses`
11. `Free Cash Flow = Cash Provided by Operating Activities - Cash Paid for Capital Investments`
12. `Adjusted Debt to EBITDA = (Total Debt + Operating Lease Liabilities) / Adjusted EBITDA`

## Cross-Sheet Dependencies

- The **Volume & Revenue** sheet is the primary engine, feeding the top line of the **Income Statement** and driving volume-based metrics in the **Operating Expenses** sheet (e.g. Fuel expense).
- The **Operating Expenses** sheet feeds EBIT on the **Income Statement** and Net Income on the **Cash Flow Statement**.
- The **PP&E & Capex Schedule** feeds Depreciation to the **Operating Expenses** sheet, Net PP&E to the **Balance Sheet**, and Capex to the **Cash Flow Statement**.
- The **Debt & Interest Schedule** creates a circularity risk: Interest expense lowers Net Income, which lowers Cash, which dictates debt paydown/borrowing needs, which in turn changes the Interest expense.

## Sign Convention

- Revenue, Assets, and Volume metrics are positive.
- Expenses on the Operating Expenses sheet are positive, but subtracted when calculating Operating Income.
- On the Cash Flow Statement, cash inflows are positive. Cash outflows (Capital Expenditures, Dividends Paid, Share Repurchases) are negative.
- Contra-assets (Accumulated Depreciation) are negative.

## Things Most Likely to Go Wrong

1. "Fuel surcharge lag: Fuel revenue and fuel expense do not match perfectly in a given quarter due to the two-month lag in surcharge programmes, causing margin volatility."
2. "Operating Ratio vs Adjusted OR: One-time items (labour buyouts, real estate sales) distort reported OR. The model must forecast core adjusted OR."
3. "Volume vs Pricing: Overestimating volume growth in mature markets (like coal) instead of relying on pricing (ARC) for revenue growth will skew the top line."
4. "Capex intensity: Under-forecasting maintenance capex will artificially inflate FCF. Railroads require massive continuous investment just to maintain the network."
5. "Share repurchases: UNP uses debt to fund buybacks to maintain its target leverage ratio. The model must dynamically size buybacks based on the 2.6x Debt/EBITDA target."
6. "Weather impacts: Q1 is typically the weakest quarter due to winter weather impacting network fluidity and increasing purchased services costs."
7. "Real estate sales: UNP frequently sells industrial park land (e.g. $234 million in Q4 2025), which boosts net income but is not part of core freight operations."
8. "Intermodal volatility: Premium volumes are highly sensitive to West Coast port activity and international shipping disruptions, making straight-line growth assumptions dangerous."

## Validation Checks

1. "Operating Ratio must be between 55% and 65% based on historical performance; flag if outside this band."
2. "Capex as a percentage of revenue must remain between 13% and 16%."
3. "Adjusted Debt to EBITDA should remain near the 2.6x to 2.8x target."
4. "Dividend payout ratio should be approximately 45% of Net Income."
5. "Total Assets must equal Total Liabilities plus Equity in every period."
6. "Free Cash Flow conversion (FCF / Net Income) should be 75-85%."
7. "Effective tax rate should be 23-24%."
8. "Total revenue growth should not exceed 5% without flagging, as this is a mature, GDP-linked business."

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Bulk Volume Growth | 1.0 | % | Mature market, slight growth in grain/renewables offset by coal secular decline |
| Bulk ARC Growth | 3.0 | % | Consistent core pricing power above inflation |
| Industrial Volume Growth | 1.5 | % | Tied to US industrial production and construction |
| Industrial ARC Growth | 3.5 | % | Strong pricing power in chemicals and plastics |
| Premium Volume Growth | 2.0 | % | Intermodal growth tied to consumer spending and imports |
| Premium ARC Growth | 2.0 | % | Highly competitive with trucking, limiting pricing power |
| Fuel Surcharge % of Revenue | 8.0 | % | Based on normalised diesel prices |
| Comp & Benefits % of Revenue | 26.0 | % | Reflects recent union agreements and headcount efficiency |
| Fuel Expense % of Revenue | 11.0 | % | Based on normalised diesel prices |
| Purchased Services % of Rev | 9.0 | % | Historical average required to maintain network |
| Depreciation % of Revenue | 10.5 | % | Driven by massive PP&E base |
| Capex | 3.4 | $B | Management guidance for baseline capital programme |
| Effective Tax Rate | 23.5 | % | Statutory rate plus state taxes |
| Share Repurchases | 4.0 | $B | Management target for capital return |
| Dividend per Share | 5.40 | $ | Based on recent quarterly run-rate and 19 years of increases |
| Target Debt/EBITDA | 2.6 | x | Company stated leverage target |
| WACC | 7.5 | % | Standard for large-cap stable infrastructure |
| Terminal Growth Rate | 2.0 | % | Long-term GDP growth |

## Data Sources & Benchmarks

- **Filings:** SEC EDGAR for Union Pacific (UNP) 10-K and 10-Q filings.
- **Investor Relations:** up.com/investor (Weekly carload reports are critical for intra-quarter modelling).
- **Peers:** CSX Corporation (CSX), Norfolk Southern (NSC), Canadian National Railway (CNI), Canadian Pacific Kansas City (CP).
- **Industry Data:** Association of American Railroads (AAR) weekly rail traffic data.
- **Regulatory:** Surface Transportation Board (STB) for regulatory filings, employment data, and operational metrics.

## Sources

- Union Pacific 2024 and 2025 Earnings Releases (up.com)
- Union Pacific 2024 and 2025 Form 10-K Filings (sec.gov)
- Progressive Railroading: Union Pacific reports Q4 net income (progressiverailroading.com)
- SupplyChainBrain: Union Pacific Profits Surge (supplychainbrain.com)

---

## Frequently asked questions

### What is Union Pacific Corporation's primary business?

Union Pacific Corporation (UNP) operates the largest Class I freight railroad in the United States, connecting 23 western states and serving major West Coast and Gulf Coast ports. Its business model is highly asset-heavy, benefiting from immense barriers to entry and significant operating leverage.

### What are the key revenue drivers for Union Pacific?

Union Pacific's revenue is primarily driven by carload volumes and its pricing power across its extensive network. The company's freight revenue is divided into three main segments: Bulk, Industrial, and Premium.

### What is Union Pacific's typical capital expenditure as a percentage of revenue?

Union Pacific typically allocates 13-15% of its revenue to capital expenditures, for example, $3.4 billion on $24.5 billion revenue in 2025. These investments primarily fund continuous track replacement, siding extensions for longer trains, and locomotive modernisations.

### What is the main purpose of the Union Pacific financial model?

The Union Pacific financial model aims to evaluate the company's equity valuation and its capacity for cash flow generation. It achieves this by forecasting key metrics such as carload volumes, pricing power, and improvements in the operating ratio within a cyclical macro environment.

### Can I download an Excel financial model for Union Pacific?

Yes, an Excel financial model for Union Pacific is available for download. This model provides forecasts for the company's financials from fiscal year 2026 through fiscal year 2030.

### What is Union Pacific's recent operating ratio, and how does it factor into the financial model?

Union Pacific recently achieved an improved operating ratio of 59.8% in 2025. The financial model specifically forecasts operating ratio improvements as a key element in evaluating the company's operational efficiency and profitability.

[Interactive forecast calculator](https://finamodel.com/companies/union-pacific/forecast)