CSX Corporation (CSX) DCF Valuation

CSX Corporation (CSX) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

CSX Corporation (CSX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 8.26 8.62 9.17 8.84 9.5
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

  1. Step 1: Download the Excel file for CSX Corporation (CSX).
  2. Step 2: Review CSX's pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust assumptions.
  5. 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.

No products were found matching.