# Norfolk Southern (NSC) Financial Model Free Excel 3-statement financial model and company analysis for Norfolk Southern. - Canonical: https://finamodel.com/companies/norfolk-southern - Industry: Transportation - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/NSC.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Merchandise Volume Growth | 1.5 | % | Aligns with long-term US industrial production growth and recent 2025 performance. | | Intermodal Volume Growth | 2.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 Growth | 2.5 | % | Captures core pricing power and inflation escalators. | | Intermodal ARPU Growth | 1.5 | % | Highly competitive market limits outsized pricing power. | | Compensation & Benefits | 25.5 | % of Rev | Based on 2024/2025 historical averages and recent union agreements. | | Purchased Services & Rents | 13.5 | % of Rev | Consistent with recent historical run-rates. | | Fuel Expense | 11.0 | % of Rev | Assumes stable diesel prices relative to 2025 levels. | | Depreciation Expense | 11.5 | % of Rev | Reflects the heavy capital base and recent track additions. | | Effective Tax Rate | 23.5 | % | Standard US corporate rate plus state taxes, adjusted for permanent differences. | | Capex / Revenue | 16.0 | % | Management guidance for long-term capital intensity to maintain the network. | | Dividend Payout Ratio | 38.0 | % | Aligns with historical capital return policy. | | Cost of Debt | 4.8 | % | Weighted average interest rate on existing long-term debt. | | WACC | 8.0 | % | Standard discount rate for a mature, asset-heavy industrial transport company. | | Terminal Growth Rate | 2.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 * Norfolk Southern Corporation Form 10-K for the fiscal year ended December 31, 2025 (filed February 2026). * Norfolk Southern Q4 2025 Earnings Press Release (January 29, 2026). * Progressive Railroading: "Norfolk Southern reports mixed Q3 financial results" (October 2025). * S&P Global Ratings: Research Update on Norfolk Southern Corp (July 2023 and subsequent updates). * Association of American Railroads (AAR) weekly traffic data. --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/norfolk-southern/forecast)