Norfolk Southern logo
Norfolk Southern Financial Model

Transportation Company Financials Example (Free Excel Download)

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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive 3-statement forecast and discounted cash flow valuation to determine the standalone intrinsic equity value of Norfolk Southern, while also serving as a scenario planning tool to evaluate the financial impact of the proposed acquisition by Union Pacific.

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. The company transports raw materials, intermediate products, and finished goods, providing critical infrastructure for the North American supply chain.

Business segments by 2025 revenue contribution:

  • Merchandise (63%): Transports agriculture, chemicals, metals, construction materials, and automotive products.
  • Intermodal (25%): Moves domestic and international containers and trailers, representing the most extensive intermodal network in the eastern US.
  • Coal (12%): Transports coal for electric generation, industrial markets, and export.

The company operates a highly asset-heavy business model requiring significant ongoing capital investment to maintain track infrastructure and rolling stock. Norfolk Southern operates in a duopoly in the eastern US alongside its primary competitor, CSX Corporation. Recent major events include the financial and operational fallout from the 2023 East Palestine derailment, a 2024 activist campaign by Ancora Holdings resulting in a CEO transition to Mark George, and the July 2025 announcement of a proposed acquisition by Union Pacific.

The downloadable Norfolk Southern 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 & AssumptionsNorfolk Southern financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$11.14B$12.74B$12.16B$12.12B$12.18B
Income before income taxes$3.88B$4.13B$2.32B$3.33B$3.67B
Operating income$4.45B$4.81B$2.85B$4.07B$4.36B
Net income$3.00B$3.27B$1.83B$2.62B$2.87B

Forecast assumptions

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

Revenue growth
1.9%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
10.5%
Effective tax rate
21.4%
See 8 more
Capex % of revenue
16.2%
Net working capital % of revenue
-2.9%
Other assets % of revenue
54.0%
Other liabilities % of revenue
100.1%
Annual debt paydown
5.0%
Interest rate on debt
4.4%
Dividend payout ratio
43.9%
Buybacks % of net income
78.1%

How to build a detailed financial model for Norfolk Southern

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 Average Revenue per Carload
  • Historical growth rate: 1% to 3% CAGR (highly correlated with US industrial production)
  • Key growth levers and headwinds: Automotive production volumes, housing starts (construction materials), and chemical manufacturing output.
  • Pricing dynamics: Contractual with inflation escalators, though subject to truck competition on shorter hauls.
  • Revenue recognition notes: Recognised over time as the freight moves from origin to destination.
  • Seasonality: Generally stronger in the second and third quarters due to construction and agricultural seasons.

Intermodal

  • Segment name: Intermodal
  • Revenue driver formula: Intermodal Units x Average Revenue per Unit
  • Historical growth rate: -2% to +4% (volatile based on consumer goods demand and port traffic)
  • Key growth levers and headwinds: Consumer spending, international trade volumes at East Coast ports, and truck capacity/rates.
  • Pricing dynamics: Highly competitive with long-haul trucking; pricing power increases when truck capacity is tight.
  • Revenue recognition notes: Recognised proportionally as transit occurs.
  • Seasonality: Peak season occurs in the late third and fourth quarters ahead of the holiday retail season.

Coal

  • Segment name: Coal
  • Revenue driver formula: Coal Tonnage (or Carloads) x Average Revenue per Ton
  • Historical growth rate: -3% to -8% CAGR (secular decline)
  • Key growth levers and headwinds: Natural gas prices (competing fuel for power generation), winter weather severity, and global seaborne metallurgical coal demand.
  • Pricing dynamics: Export metallurgical coal pricing is highly dependent on global spot markets, while utility coal is often contracted.
  • Revenue recognition notes: Recognised as transit occurs.
  • Seasonality: Winter months drive utility stockpile replenishment.

Cost Structure

Variable Costs / COGS

For railroads, traditional COGS is replaced by "Railway Operating Expenses". The primary components are:

  • Compensation and benefits: The largest expense (typically 25% to 28% of revenue), driven by unionised labour agreements and headcount.
  • Purchased services and rents: Costs for third-party contractors, equipment leases, and joint facility usage (12% to 15% of revenue).
  • Fuel: Highly variable based on diesel prices and gross ton-miles transported (10% to 14% of revenue). Often offset by fuel surcharge revenue.
  • Materials and other: Locomotive and freight car repair materials, casualty claims, and environmental remediation.

Operating Expenses

  • Depreciation: Massive non-cash expense representing 10% to 12% of revenue, reflecting the capital-intensive nature of track and equipment.
  • Restructuring / one-time charges: Material in recent years due to the East Palestine derailment (environmental remediation, legal settlements) and 2025 merger-related expenses.

Margin Profile

  • Operating Ratio (Operating Expenses / Operating Revenue): The standard railroad profitability metric. Norfolk Southern's adjusted operating ratio was 65.0% in 2025, improving from 65.8% in 2024. Lower is better.
  • EBITDA margin: Typically 40% to 45%.
  • Net margin: Typically 20% to 24%.
  • Margin trend: The company is focused on closing the margin gap with peers through productivity initiatives, targeting an operating ratio in the low 60s.

Balance Sheet Structure

  • Total assets: Approximately $45 billion.
  • Key asset categories: Properties (PP&E) dominate the balance sheet, representing over 80% of total assets. This includes track structure, land, locomotives, and freight cars.
  • Goodwill & intangibles: Minimal, as growth has historically been organic rather than through large acquisitions.
  • Working capital profile:
  • Days Sales Outstanding (DSO): 30 to 40 days.
  • Days Payable Outstanding (DPO): 40 to 50 days.
  • Net working capital is typically negative or slightly positive, providing a modest source of cash as the business grows.
  • PP&E: Track structure has very long useful lives (up to 50+ years), while locomotives are depreciated over 15 to 25 years.
  • Right-of-use assets: Material but manageable, primarily related to leased rolling stock and terminal facilities.

Capital Expenditure & Investment

  • Capex as % of revenue: Typically 15% to 18% (approximately $1.9 billion to $2.2 billion annually).
  • Maintenance capex vs. growth capex: The vast majority (70% to 80%) is maintenance capex required to replace worn rail, ties, and ballast to ensure safe operations.
  • Major capex programmes: Upgrading the locomotive fleet (DC to AC conversions), expanding intermodal terminals, and implementing technology for train inspection.
  • M&A pattern: Historically a bolt-on acquirer of short-line railroads (such as the 2024 acquisition of the Cincinnati Southern Railway for $1.62 billion). The pending 2025 Union Pacific merger is a transformational industry event.

Debt & Capital Structure

  • Total debt: Approximately $17.1 billion as of late 2025.
  • Net debt: Approximately $15.5 billion (accounting for roughly $1.5 billion to $1.6 billion in cash).
  • Debt/EBITDA ratio: Currently running at 2.7x to 3.0x.
  • Credit rating: BBB+ (S&P) / Baa1 (Moody's).
  • Key debt instruments: Long-term unsecured bonds with staggered maturities spanning up to 100 years, plus a revolving credit facility for liquidity.
  • Interest rate profile: Predominantly fixed-rate long-term debt, providing protection against interest rate volatility.
  • Share repurchase programme: Historically active (e.g., $534 million in 2025), though buybacks may be suspended or altered pending the Union Pacific merger closure.
  • Dividend policy: Consistent dividend payer with a yield typically around 1.8% to 2.2% and a payout ratio of 35% to 40%.

Cash Flow Characteristics

  • Operating cash flow conversion: Very strong. OCF routinely exceeds Net Income due to massive depreciation add-backs.
  • Free cash flow margin: 15% to 18% (FCF was approximately $2.16 billion in 2025).
  • Major non-cash items: Depreciation is the primary bridge between net income and OCF. Deferred income taxes are also a material non-cash item due to accelerated tax depreciation on track assets.
  • Capex intensity: High capital intensity is the main drag on free cash flow, requiring disciplined capital allocation.
  • Cash tax rate: Often lower than the GAAP effective tax rate due to bonus depreciation rules on capital investments.

Sheet Structure

  1. Assumptions: Hardcoded inputs for macroeconomic drivers, segment volume growth, pricing, expense ratios, and valuation metrics.
  2. Revenue & Volumes: Detailed build of carloads/units and average revenue per unit for Merchandise, Intermodal, and Coal, plus fuel surcharge revenue.
  3. Operating Expenses: Line-by-line forecast of Compensation, Purchased Services, Fuel, Depreciation, and Materials to calculate the Operating Ratio.
  4. Income Statement: Consolidated GAAP income statement mirroring the 10-K, flowing down to Net Income and EPS.
  5. Balance Sheet: Assets, Liabilities, and Equity, driven by working capital schedules and PP&E.
  6. Cash Flow Statement: Indirect method starting from Net Income, adjusting for D&A and working capital, down to Free Cash Flow.
  7. Debt & Interest Schedule: Tranches of long-term debt, revolver balances, and interest expense calculations.
  8. PP&E & Depreciation: Waterfall schedule for capital expenditures, retirements, and depreciation expense.
  9. Merger Adjustments (Pro-Forma): Specific sheet to model the Union Pacific acquisition scenario, including transaction multiples and synergy assumptions.
  10. DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.

Key Financial Relationships

  1. `Merchandise Revenue = Merchandise Carloads x Merchandise Average Revenue per Carload`
  2. `Intermodal Revenue = Intermodal Units x Intermodal Average Revenue per Unit`
  3. `Coal Revenue = Coal Tonnage x Average Revenue per Ton`
  4. `Total Railway Operating Revenues = Merchandise Revenue + Intermodal Revenue + Coal Revenue`
  5. `Fuel Expense = Total Gross Ton-Miles x Fuel Consumption Rate x Average Diesel Price per Gallon`
  6. `Compensation & Benefits = Total Headcount x Average Fully Burdened Cost per Employee`
  7. `Total Railway Operating Expenses = Compensation + Purchased Services + Fuel + Depreciation + Materials & Other`
  8. `Income from Railway Operations = Total Railway Operating Revenues - Total Railway Operating Expenses`
  9. `Operating Ratio = Total Railway Operating Expenses / Total Railway Operating Revenues`
  10. `Adjusted Operating Ratio = (Total Railway Operating Expenses - One-Time Incident/Merger Costs) / Total Railway Operating Revenues`
  11. `Free Cash Flow = Cash from Operations - Property Additions (Capex)`
  12. `Net Debt = Total Debt - Cash and Cash Equivalents`

Cross-Sheet Dependencies

  • The Revenue & Volumes sheet feeds the top line of the Income Statement and drives volume-dependent variable costs in the Operating Expenses sheet (e.g., Fuel).
  • The Operating Expenses sheet feeds directly into the Income Statement to calculate Income from Railway Operations.
  • The PP&E & Depreciation sheet calculates depreciation expense, which feeds the Operating Expenses sheet, the Balance Sheet (Accumulated Depreciation), and the Cash Flow Statement (non-cash add-back).
  • The Debt & Interest Schedule creates a circularity risk: Interest expense reduces Net Income, which reduces Cash Flow, which impacts the Revolver balance, which in turn changes Interest expense. A circuit breaker toggle must be included.
  • The Income Statement generates Net Income, which is the starting point for the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet.

Sign Convention

  • Revenues and volume metrics are entered and displayed as positive numbers.
  • Operating expenses on the expense build sheet are calculated as positive numbers but subtracted when calculating Income from Railway Operations on the Income Statement.
  • On the Cash Flow Statement, cash inflows (e.g., Net Income, Depreciation add-back, increases in liabilities) are positive. Cash outflows (e.g., Capex, debt repayment, dividend payments, increases in assets) are negative.
  • The Balance Sheet must reflect all assets, liabilities, and equity as positive balances.

Things Most Likely to Go Wrong

  • Failing to accurately model the Operating Ratio. Railroad analysts focus obsessively on the OR; the model must clearly display both GAAP and Adjusted OR.
  • Misinterpreting the East Palestine derailment costs. The model must isolate these environmental and legal charges as non-recurring to calculate the true underlying run-rate profitability.
  • Double-counting fuel surcharges. Ensure fuel surcharge revenue is either explicitly modelled as a separate line item or clearly embedded within the segment ARPU assumptions, but not both.
  • Underestimating capital intensity. Railroads cannot grow without massive maintenance capex. Setting capex too low will artificially inflate Free Cash Flow.
  • Ignoring the Union Pacific merger impact. The 2025 financials include merger-related advisory and legal expenses that must be adjusted out for standalone valuation.
  • Misaligning volume metrics. Intermodal is measured in units, Merchandise in carloads, and Coal often in tons. The model must use the correct denominator for each segment's yield.
  • Overstating coal revenue longevity. Coal is in secular decline; terminal value assumptions must reflect a shrinking coal business.
  • Forgetting the deferred tax liability. Accelerated depreciation for tax purposes creates a massive deferred tax liability on the balance sheet that must be rolled forward correctly.

Validation Checks

  • "Adjusted Operating Ratio should remain between 60.0% and 66.0%; flag if the model projects an OR outside this historical band."
  • "Capex as a percentage of Total Railway Operating Revenues must be between 15.0% and 18.0%."
  • "Free Cash Flow conversion (FCF / Net Income) should be between 70% and 85%."
  • "Debt to EBITDA ratio should not exceed 3.5x to maintain the current investment-grade credit rating."
  • "Total Assets must equal Total Liabilities plus Shareholders' Equity in every forecast period (Balance Sheet check = 0)."
  • "Coal volumes should show a negative CAGR over the forecast period; flag if coal volumes are projected to grow."
  • "Depreciation expense should be roughly 10% to 12% of total revenues."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Merchandise Volume Growth1.5%Aligns with long-term US industrial production growth and recent 2025 performance.
Intermodal Volume Growth2.5%Reflects GDP growth and gradual conversion of highway freight to rail.
Coal Volume Growth-3.0%Reflects secular decline in coal-fired power generation.
Merchandise ARPU Growth2.5%Captures core pricing power and inflation escalators.
Intermodal ARPU Growth1.5%Highly competitive market limits outsized pricing power.
Compensation & Benefits25.5% of RevBased on 2024/2025 historical averages and recent union agreements.
Purchased Services & Rents13.5% of RevConsistent with recent historical run-rates.
Fuel Expense11.0% of RevAssumes stable diesel prices relative to 2025 levels.
Depreciation Expense11.5% of RevReflects the heavy capital base and recent track additions.
Effective Tax Rate23.5%Standard US corporate rate plus state taxes, adjusted for permanent differences.
Capex / Revenue16.0%Management guidance for long-term capital intensity to maintain the network.
Dividend Payout Ratio38.0%Aligns with historical capital return policy.
Cost of Debt4.8%Weighted average interest rate on existing long-term debt.
WACC8.0%Standard discount rate for a mature, asset-heavy industrial transport company.
Terminal Growth Rate2.0%Aligns with long-term US GDP growth.

Data Sources & Benchmarks

  • Filings: Norfolk Southern Investor Relations website and SEC EDGAR (Form 10-K, 10-Q, 8-K).
  • Key Peers: CSX Corporation (CSX) is the direct eastern US peer. Union Pacific (UNP), Canadian National (CNI), and Canadian Pacific Kansas City (CP) serve as broader Class I benchmarks.
  • Industry Data: Association of American Railroads (AAR) weekly carload reports provide real-time volume tracking.
  • Macro Data: US Federal Reserve Industrial Production Index and housing starts data.
  • Consensus Estimates: Bloomberg or FactSet for forward-looking EPS and Operating Ratio estimates.

Sources

Frequently asked

What is Norfolk Southern's primary business model?+

Norfolk Southern operates as a premier Class I freight railroad, managing an extensive network of approximately 19,200 route miles across the eastern United States. The company transports raw materials, intermediate products, and finished goods, providing critical infrastructure for the North American supply chain.

What are the main revenue drivers for Norfolk Southern?+

Norfolk Southern's revenue is primarily driven by three segments: Merchandise (63%), Intermodal (25%), and Coal (12%). Merchandise includes a variety of products like agriculture, chemicals, and automotive, while Intermodal focuses on moving domestic and international containers.

What is Norfolk Southern's typical capital expenditure as a percentage of revenue?+

Norfolk Southern typically allocates 15% to 18% of its revenue to capital expenditures, which translates to approximately $1.9 billion to $2.2 billion annually. The vast majority, 70% to 80%, is maintenance capex required to ensure safe operations and maintain its extensive track infrastructure and rolling stock.

What is the assumed revenue growth rate in the Norfolk Southern financial model?+

The financial model for Norfolk Southern assumes a revenue growth rate of approximately 1.85% for its forecast horizon. This assumption is a key input for projecting the company's future top-line performance from FY2026 to FY2030.

What is the purpose of the Norfolk Southern financial model?+

The Norfolk Southern financial model provides a comprehensive 3-statement forecast and discounted cash flow valuation. Its primary purpose is to determine the standalone intrinsic equity value of the company, while also serving as a scenario planning tool for the proposed acquisition by Union Pacific.

Can I download an Excel financial model for Norfolk Southern?+

Yes, an Excel financial model for Norfolk Southern is available for download. This model offers a detailed forecast horizon from FY2026 through FY2030, incorporating key assumptions such as revenue growth, operating margins, and capital expenditures.

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!

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