CSX Corporation (CSX) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
CSX Corporation (CSX) Bundle
Designed for accuracy, our (CSX) DCF Calculator enables you to evaluate CSX Corporation's valuation using real-world financial data, providing complete flexibility to modify all key parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 11,937.0 | 10,583.0 | 12,522.0 | 14,853.0 | 14,657.0 | 15,546.5 | 16,489.9 | 17,490.7 | 18,552.1 | 19,678.0 |
| Revenue Growth, % | 0 | -11.34 | 18.32 | 18.62 | -1.32 | 6.07 | 6.07 | 6.07 | 6.07 | 6.07 |
| EBITDA | 6,402.0 | 5,764.0 | 6,653.0 | 7,390.0 | 7,340.0 | 8,117.1 | 8,609.7 | 9,132.2 | 9,686.4 | 10,274.2 |
| EBITDA, % | 53.63 | 54.46 | 53.13 | 49.75 | 50.08 | 52.21 | 52.21 | 52.21 | 52.21 | 52.21 |
| Depreciation | 1,349.0 | 1,383.0 | 1,420.0 | 1,500.0 | 1,611.0 | 1,766.1 | 1,873.2 | 1,986.9 | 2,107.5 | 2,235.4 |
| Depreciation, % | 11.3 | 13.07 | 11.34 | 10.1 | 10.99 | 11.36 | 11.36 | 11.36 | 11.36 | 11.36 |
| EBIT | 5,053.0 | 4,381.0 | 5,233.0 | 5,890.0 | 5,729.0 | 6,351.0 | 6,736.5 | 7,145.3 | 7,578.9 | 8,038.8 |
| EBIT, % | 42.33 | 41.4 | 41.79 | 39.66 | 39.09 | 40.85 | 40.85 | 40.85 | 40.85 | 40.85 |
| Total Cash | 1,954.0 | 3,131.0 | 2,316.0 | 2,087.0 | 1,436.0 | 2,745.5 | 2,912.1 | 3,088.8 | 3,276.2 | 3,475.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 986.0 | 912.0 | 1,148.0 | 1,313.0 | 1,393.0 | 1,380.2 | 1,464.0 | 1,552.8 | 1,647.0 | 1,747.0 |
| Account Receivables, % | 8.26 | 8.62 | 9.17 | 8.84 | 9.5 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 |
| Inventories | 261.0 | 302.0 | 339.0 | 341.0 | 446.0 | 406.9 | 431.6 | 457.8 | 485.5 | 515.0 |
| Inventories, % | 2.19 | 2.85 | 2.71 | 2.3 | 3.04 | 2.62 | 2.62 | 2.62 | 2.62 | 2.62 |
| Accounts Payable | 1,043.0 | 809.0 | 963.0 | 1,130.0 | 1,237.0 | 1,247.4 | 1,323.1 | 1,403.4 | 1,488.6 | 1,579.0 |
| Accounts Payable, % | 8.74 | 7.64 | 7.69 | 7.61 | 8.44 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 |
| Capital Expenditure | -1,657.0 | -1,626.0 | -1,791.0 | -2,133.0 | -2,281.0 | -2,284.4 | -2,423.1 | -2,570.1 | -2,726.1 | -2,891.5 |
| Capital Expenditure, % | -13.88 | -15.36 | -14.3 | -14.36 | -15.56 | -14.69 | -14.69 | -14.69 | -14.69 | -14.69 |
| Tax Rate, % | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 |
| EBITAT | 3,899.8 | 3,339.8 | 3,996.4 | 4,532.3 | 4,351.5 | 4,860.9 | 5,155.9 | 5,468.8 | 5,800.7 | 6,152.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3,387.8 | 2,895.8 | 3,506.4 | 3,899.3 | 3,603.5 | 4,404.9 | 4,573.3 | 4,850.8 | 5,145.2 | 5,457.5 |
| WACC, % | 8.57 | 8.56 | 8.56 | 8.57 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 19,051.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 5,621 | |||||||||
| Terminal Value | 101,022 | |||||||||
| Present Terminal Value | 66,986 | |||||||||
| Enterprise Value | 86,037 | |||||||||
| Net Debt | 17,739 | |||||||||
| Equity Value | 68,298 | |||||||||
| Diluted Shares Outstanding, MM | 2,013 | |||||||||
| Equity Value Per Share | 33.93 |
What You Will Get
- Real CSX Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Modify WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed dynamically.
- Scenario Analysis: Evaluate various scenarios to assess CSX's future performance.
- Clear and Intuitive Design: Designed for professionals while remaining accessible for beginners.
Key Features
- Real-Life CSX Data: Pre-filled with CSX Corporation’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value in response to your inputs.
- Scenario Testing: Develop various forecast scenarios to assess different valuation outcomes.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file for CSX Corporation (CSX).
- Step 2: Review CSX's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for informed investment decisions.
Why Choose This Calculator for CSX Corporation (CSX)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and consultants in the transportation sector.
- Comprehensive Data: CSX’s historical and projected financials are preloaded for enhanced precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and other essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessments related to CSX Corporation (CSX).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations regarding CSX Corporation (CSX).
- Consultants and Advisors: Deliver precise valuation insights to clients interested in investing in CSX Corporation (CSX).
- Students and Educators: Utilize real-time data to practice and teach financial modeling techniques focused on CSX Corporation (CSX).
- Transport Industry Enthusiasts: Gain insights into how transportation companies like CSX Corporation (CSX) are valued in the financial markets.
What the Template Contains
- Preloaded CSX Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.