CSX Financial Model
Transportation Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates CSX Corporation's equity valuation and credit profile by forecasting freight volumes, pricing yields, and operating ratio improvements across its rail network in a cyclical macroeconomic environment.
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. The company transports a broad spectrum of commodities and provides rail-to-truck transload services, connecting major population centres and industrial markets.
Business segments by approximate 2025 revenue contribution:
- Merchandise (64%): Includes Chemicals, Agricultural and Food Products, Minerals, Automotive, Forest Products, Metals and Equipment, and Fertilizers.
- Intermodal (15%): Shipment of containers and trailers combining rail and truck transport.
- Coal (14%): Domestic and export coal for electricity generation and steelmaking.
- Trucking and Other (7%): Primarily bulk liquid chemicals transportation via Quality Carriers.
The business model is highly asset-heavy, requiring significant ongoing capital investment to maintain track infrastructure and rolling stock. CSX operates in a duopoly in the eastern United States alongside Norfolk Southern, competing more broadly with the trucking industry for intermodal and merchandise freight. Recent major events include the acquisition of Pan Am Systems to expand its northeastern reach and the acquisition of Quality Carriers to bolster its chemical trucking capabilities.
The downloadable CSX 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 & AssumptionsCSX financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Depreciation and Amortization | $1.42B | $1.50B | $1.61B | $1.66B | $1.68B |
| Earnings Before Income Taxes | $4.95B | $5.41B | $4.89B | $4.55B | $3.77B |
| Operating income | $5.59B | $5.95B | $5.50B | $5.25B | $4.52B |
| Net income | $3.78B | $4.11B | $3.67B | $3.47B | $2.89B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for CSX
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Merchandise
- Segment name: Merchandise
- Revenue driver formula: Merchandise Carloads x Merchandise Revenue per Carload
- Historical growth rate: 1% to 3% CAGR
- Key growth levers and headwinds: Industrial production indices, automotive manufacturing output, and chemical plant expansions drive volume. Headwinds include general macroeconomic slowdowns and truck competition.
- Pricing dynamics: Contractual with inflation-linked escalators and fuel surcharge mechanisms. Pricing power is generally strong due to high barriers to entry.
- Revenue recognition notes: Recognised over time as the freight moves from origin to destination.
- Seasonality: Relatively stable, though agricultural products peak during autumn harvest seasons.
Intermodal
- Segment name: Intermodal
- Revenue driver formula: Intermodal Units x Intermodal Revenue per Unit
- Historical growth rate: 2% to 5% CAGR
- Key growth levers and headwinds: Consumer spending, retail inventory restocking, and port import volumes. Headwinds include loose trucking capacity and lower spot trucking rates which draw volume away from rail.
- Pricing dynamics: Highly competitive with the trucking sector. Contracts are often negotiated annually.
- Revenue recognition notes: Recognised over time as shipments transit the network.
- Seasonality: Peaks in the third and fourth quarters ahead of the holiday retail season.
Coal
- Segment name: Coal
- Revenue driver formula: Coal Carloads x Coal Revenue per Carload
- Historical growth rate: Negative 2% to negative 5% CAGR
- Key growth levers and headwinds: Driven by global metallurgical coal demand for steelmaking and natural gas prices affecting domestic thermal coal dispatch. Long-term secular decline in domestic thermal coal is the primary headwind.
- Pricing dynamics: Export coal pricing is often tied to global benchmark indices (e.g., API 2, Australian Premium Low Vol).
- Revenue recognition notes: Recognised over time during transit.
- Seasonality: Winter weather can impact mining operations and increase utility demand for thermal coal.
Trucking and Other
- Segment name: Trucking and Other
- Revenue driver formula: Trucking Loads x Revenue per Load + Incidental Revenues
- Historical growth rate: 3% to 6% CAGR
- Key growth levers and headwinds: Chemical production volumes and driver availability.
- Pricing dynamics: Spot and contract trucking rates.
- Revenue recognition notes: Recognised upon delivery or over the transit period.
- Seasonality: Tracks general industrial seasonality.
Cost Structure
Variable Costs / COGS
Unlike traditional manufacturers, railroads do not report a standard Gross Margin. All operating expenses are grouped together to calculate the Operating Ratio (Operating Expenses divided by Revenue).
- Labour and Fringe: The largest expense (approx. 22% to 24% of revenue). Highly unionised workforce subject to national bargaining agreements. Includes wages, healthcare, and pension costs.
- Fuel: Highly variable (approx. 8% to 10% of revenue). Driven by locomotive diesel consumption and price per gallon. Largely offset by fuel surcharge revenue, though with a 30-to-60 day lag.
- Purchased Services and Other: Includes outsourced terminal operations, professional services, and casualty/insurance expenses.
- Equipment and Other Rents: Costs for using freight cars owned by other railroads or leasing companies.
Operating Expenses
- Depreciation and Amortisation: Very high (approx. 11% to 13% of revenue) due to the capital-intensive nature of track and locomotive assets.
- R&D: Not material for railroads.
- SG&A: Embedded within Labour and Purchased Services; not explicitly broken out on the income statement.
- Stock-Based Compensation: Relatively small, included in Labour and Fringe.
- Restructuring / one-time charges: Occasional severance or technology rationalisation charges (e.g., $50 million charge in Q4 2025).
Margin Profile
- Operating Margin: 31% to 36% (5-year range).
- Operating Ratio (Inverse of Operating Margin): 64% to 69%. Lower is better. CSX reported a 67.9% operating ratio for the full year 2025.
- Margin trend: Margins compressed slightly in 2024 and 2025 due to wage inflation and lower export coal prices, but the company targets long-term operating ratio improvement through efficiency initiatives.
Balance Sheet Structure
- Total assets: Approximately $42 billion to $43 billion.
- Key asset categories: Properties (PP&E) dominate the balance sheet, representing over 80% of total assets.
- Goodwill & intangibles: Approximately $2.5 billion (roughly 6% of assets), primarily from the Pan Am and Quality Carriers acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): 30 to 35 days.
- Days Inventory Outstanding (DIO): Not applicable (materials and supplies are held for maintenance, not sale).
- Days Payable Outstanding (DPO): 40 to 45 days.
- Net working capital: Typically negative or near zero. The company uses cash generated from operations to fund capital expenditures and shareholder returns rather than tying it up in working capital.
- PP&E: Consists of track structure, locomotives, freight cars, and terminal facilities. Track assets have very long useful lives (often 30 to 50 years).
- Right-of-use assets: Operating leases are present for certain equipment and real estate but are not the primary driver of the asset base.
Capital Expenditure & Investment
- Capex as % of revenue: 15% to 18% (historically $2.3 billion to $2.5 billion annually).
- Maintenance capex vs. growth capex: Approximately 70% to 80% is maintenance (replacing rail, ties, and ballast; overhauling locomotives). The remainder is growth (terminal expansions, siding extensions).
- Major capex programmes: Howard Street Tunnel clearance project in Baltimore to enable double-stack intermodal trains.
- Capitalised software: Present but minor compared to physical infrastructure.
- M&A pattern: Infrequent, bolt-on acquisitions (e.g., Pan Am Systems, Quality Carriers) rather than transformational mergers, due to intense regulatory scrutiny by the Surface Transportation Board.
Debt & Capital Structure
- Total debt: Approximately $18 billion to $19 billion.
- Debt/EBITDA ratio: Typically managed around 2.0x to 2.5x to maintain investment-grade ratings.
- Credit rating: BBB+ / Baa1 range.
- Key debt instruments: Long-term unsecured notes and debentures.
- Maturity profile: Well-laddered with maturities extending out 30 to 50 years.
- Interest rate profile: Predominantly fixed-rate long-term debt.
- Covenants: Standard investment-grade covenants; no restrictive financial maintenance covenants on the bonds.
- Share repurchase programme: Highly active. The company frequently uses excess free cash flow to retire shares, reducing share count by several percentage points annually.
- Dividend policy: Consistent dividend payer with a payout ratio typically around 25% to 30% of net income.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong. OCF is typically 1.3x to 1.5x Net Income due to massive non-cash depreciation add-backs.
- Free cash flow margin: 15% to 20% of revenue.
- Major non-cash items: Depreciation and amortisation, deferred income taxes.
- Working capital cash flow impact: Minimal impact year-over-year.
- Capex intensity: High. Capex consumes roughly 40% to 50% of operating cash flow.
- Cash tax rate: Often lower than the GAAP effective tax rate due to accelerated depreciation for tax purposes on track infrastructure.
Sheet Structure
- Assumptions: Hardcoded inputs for volume growth, pricing yields, cost ratios, capex, and capital returns.
- Operating Statistics: Volume (carloads/units) and Yield (revenue per unit) schedules for Merchandise, Intermodal, and Coal.
- Income Statement: Revenue by segment, detailed operating expenses (Labour, Fuel, Purchased Services, D&A, Equipment Rents), Operating Income, Interest Expense, and Net Income.
- Balance Sheet: Cash, Receivables, Materials, PP&E, Goodwill, Accounts Payable, Long-Term Debt, Deferred Taxes, and Equity.
- Cash Flow Statement: Net Income, D&A, Deferred Taxes, Working Capital changes, Capex, Debt issuance/repayment, Dividends, and Share Repurchases.
- Debt Schedule: Beginning balance, issuances, retirements, ending balance, and interest expense calculation based on weighted average rates.
- PP&E & Depreciation: Roll-forward of gross properties, accumulated depreciation, capex additions, and depreciation expense.
- DCF Valuation: Unlevered free cash flow calculation, WACC build-up, terminal value calculation, and implied share price.
Key Financial Relationships
- `Merchandise Revenue = Merchandise Carloads x Merchandise Revenue per Carload`
- `Intermodal Revenue = Intermodal Units x Intermodal Revenue per Unit`
- `Coal Revenue = Coal Carloads x Coal Revenue per Carload`
- `Total Revenue = Merchandise Revenue + Intermodal Revenue + Coal Revenue + Trucking and Other Revenue`
- `Labour and Fringe Expense = Total Revenue x Labour % of Revenue`
- `Fuel Expense = Total Revenue x Fuel % of Revenue` (Alternatively modelled as Gallons Consumed x Price per Gallon if data permits).
- `Total Operating Expenses = Labour and Fringe + Purchased Services + Depreciation + Fuel + Equipment Rents`
- `Operating Income = Total Revenue - Total Operating Expenses`
- `Operating Ratio = Total Operating Expenses / Total Revenue`
- `Interest Expense = Average Long-Term Debt x Weighted Average Interest Rate`
- `Free Cash Flow = Cash from Operations - Property Additions (Capex)`
- `Ending Shares Outstanding = Beginning Shares - (Share Repurchase Spend / Average Share Price)`
Cross-Sheet Dependencies
- The Operating Statistics sheet is the foundation. It calculates segment revenues which feed the top line 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 PP&E & Depreciation schedule takes Capex from the Assumptions sheet, feeds D&A to the Income Statement and Cash Flow Statement, and updates net Properties on the Balance Sheet.
- The Debt Schedule takes funding shortfalls/surpluses from the Cash Flow Statement, updates Debt on the Balance Sheet, and feeds Interest Expense back to the Income Statement. This creates a circular reference that must be managed with a toggle switch.
- The DCF Valuation pulls NOPAT and D&A from the Income Statement, and Capex and Working Capital changes from the Cash Flow Statement.
Sign Convention
- Revenues and Assets: Entered and displayed as positive numbers.
- Expenses: Entered as positive numbers in the assumptions and expense build-ups, but subtracted in total calculations (e.g., Revenue - Expenses).
- Liabilities and Equity: Entered and displayed as positive numbers.
- Cash Flow Statement: Cash inflows are positive; cash outflows (Capex, dividends, share repurchases) are negative.
Things Most Likely to Go Wrong
- Operating Ratio disconnect: Modellers often forecast revenue and expenses independently, resulting in an implied Operating Ratio that defies management guidance or historical bounds. The model must check implied OR against the 60% to 68% historical range.
- Fuel surcharge lag: Fuel expense and fuel surcharge revenue do not move in perfect tandem. A rapid drop in diesel prices flatters margins temporarily before surcharges adjust downward.
- Ignoring union wage step-ups: Labour costs are governed by national union agreements. Assuming a smooth historical average might miss contractual step-ups in wages or back-pay settlements.
- Export coal volatility: Assuming straight-line growth for coal ignores the extreme volatility of global metallurgical coal prices, which heavily impact coal yields.
- Capitalising vs. expensing track maintenance: Railroad accounting rules dictate specific treatments for track replacement. Ensure Capex and Maintenance Expense assumptions do not double-count track work.
- Share count stagnation: Failing to model CSX's aggressive share repurchase programme will severely understate future Earnings Per Share.
- Tax rate assumptions: Using the statutory tax rate ignores the significant deferred tax liabilities generated by accelerated depreciation on track assets.
- Goodwill impairments: Historical operating income includes occasional non-cash goodwill impairments (e.g., $164 million in 2025). These must be excluded when calculating adjusted run-rate margins.
Validation Checks
- "Operating Ratio must remain between 60% and 69%; flag if the model implies margins outside this historical band."
- "Capex as a percentage of revenue should run between 15% and 18% based on management guidance."
- "Operating Cash Flow to Net Income conversion should consistently exceed 1.2x due to heavy D&A."
- "Debt to EBITDA should remain between 2.0x and 2.5x to align with the company's target capital structure."
- "Balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every period."
- "Coal volume growth should be flat to negative over the long term, reflecting secular industry trends."
- "Depreciation expense should be roughly 11% to 13% of total revenue."
- "Dividend payout ratio should remain between 20% and 30% of Net Income."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Merchandise Volume Growth | 1.5 | % | Aligns with long-term industrial production growth. |
| Intermodal Volume Growth | 3.0 | % | Reflects GDP growth plus slight truck-to-rail conversion. |
| Coal Volume Growth | -3.0 | % | Secular decline in domestic thermal coal offset by stable export met coal. |
| Merchandise Yield Growth | 3.5 | % | Historical pricing power exceeding general inflation. |
| Intermodal Yield Growth | 2.0 | % | Highly competitive with trucking, limiting pricing power. |
| Coal Yield Growth | 1.0 | % | Subject to global commodity price fluctuations; conservative long-term assumption. |
| Labour and Fringe % of Revenue | 23.0 | % | Based on 2024/2025 actuals and recent union agreements. |
| Purchased Services % of Revenue | 20.5 | % | Based on recent historical averages. |
| Fuel % of Revenue | 9.0 | % | Assumes normalised diesel prices. |
| Equipment Rents % of Revenue | 2.5 | % | Stable historical run-rate. |
| Capex % of Revenue | 16.5 | % | Aligns with management guidance of approx $2.4B on $14B+ revenue. |
| Effective Tax Rate | 24.0 | % | Historical GAAP effective tax rate. |
| Weighted Average Interest Rate | 4.5 | % | Based on current long-term debt portfolio. |
| Share Repurchase Spend | 1,500 | $ Millions | Historical average of excess free cash flow deployment. |
| Dividend Payout Ratio | 25.0 | % | Aligns with management's capital return framework. |
| WACC | 8.0 | % | Standard cost of capital for a mature, asset-heavy industrial. |
| Terminal Growth Rate | 2.0 | % | Aligns with long-term macroeconomic growth. |
Data Sources & Benchmarks
- Filings: SEC EDGAR for 10-K and 10-Q filings; CSX Investor Relations website for quarterly earnings presentations and financial supplements.
- Key Peers: Norfolk Southern (NSC) is the direct eastern US competitor. Union Pacific (UNP) and Canadian National (CNI) serve as broader Class I operational benchmarks.
- Industry Data: Surface Transportation Board (STB) weekly carload reports; Association of American Railroads (AAR) rail traffic data.
- Consensus Estimates: Bloomberg or FactSet for consensus revenue, EPS, and Operating Ratio estimates.
Sources
Do more with the CSX model
Frequently asked
What does CSX Corporation do?+
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. It transports a broad spectrum of commodities and provides rail-to-truck transload services, connecting major population centers and industrial markets.
How does CSX Corporation generate revenue?+
CSX generates revenue primarily from its Merchandise segment, contributing 64%, followed by Intermodal at 15%, and Coal at 14%, with a smaller 7% from Trucking and Other. Its business model relies on forecasting freight volumes and pricing yields across its extensive rail network.
What is CSX Corporation's typical capital expenditure as a percentage of revenue?+
CSX Corporation historically allocates 15% to 18% of its revenue to capital expenditures, amounting to $2.3 billion to $2.5 billion annually. A significant portion, 70% to 80%, is dedicated to maintenance capex for track infrastructure and rolling stock, while the remainder supports growth initiatives.
What are the key assets considered in CSX Corporation's financial valuation?+
In CSX Corporation's financial valuation, Properties (PP&E) are the dominant asset category, representing over 80% of its approximately $42 billion to $43 billion in total assets. These assets, including track structure, locomotives, and terminal facilities, have very long useful lives and are central to its asset-heavy business model.
Can I download an Excel financial model for CSX Corporation?+
Yes, an Excel financial model for CSX Corporation is available for download, covering a forecast horizon from FY2026 to FY2030. This general corporate model is designed to evaluate the company's equity valuation and credit profile by forecasting key operational and financial metrics.
What are the primary competitive factors for CSX Corporation?+
CSX Corporation operates in a duopoly in the eastern United States alongside Norfolk Southern, which is a primary competitive factor for rail freight. The company also competes broadly with the trucking industry for intermodal and merchandise freight, influencing its market strategies.
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.
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.
Old Dominion
Old Dominion Freight Line (ODFL) is one of the largest North American less-than-truckload (LTL) motor carriers, providing regional, inter-regional, and national LTL services through a single integrated, union-free organisation.
Explore more Manufacturing financial model templates.
