CONSOL Energy Inc. (CEIX) DCF Valuation

CONSOL Energy Inc. (CEIX) 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

CONSOL Energy Inc. (CEIX) 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:

Streamline your analysis and improve precision with our (CEIX) DCF Calculator! Utilizing actual data from CONSOL Energy Inc. and customizable assumptions, this tool empowers you to forecast, evaluate, and appraise (CEIX) like a seasoned investor.


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 1,392.2 879.5 1,261.0 2,280.0 2,527.8 3,148.6 3,921.8 4,884.9 6,084.5 7,578.7
Revenue Growth, % 0 -36.83 43.39 80.81 10.87 24.56 24.56 24.56 24.56 24.56
EBITDA 377.9 150.5 323.3 813.0 1,048.5 925.9 1,153.2 1,436.5 1,789.2 2,228.6
EBITDA, % 27.14 17.11 25.64 35.66 41.48 29.41 29.41 29.41 29.41 29.41
Depreciation 207.1 210.8 224.6 226.9 241.3 479.5 597.3 743.9 926.6 1,154.2
Depreciation, % 14.88 23.96 17.81 9.95 9.55 15.23 15.23 15.23 15.23 15.23
EBIT 170.8 -60.3 98.7 586.1 807.2 446.4 556.0 692.5 862.6 1,074.4
EBIT, % 12.27 -6.85 7.83 25.71 31.93 14.18 14.18 14.18 14.18 14.18
Total Cash 80.3 50.9 149.9 273.1 281.3 293.1 365.1 454.7 566.4 705.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 172.7 160.4 115.7 196.6 160.4
Account Receivables, % 12.4 18.24 9.18 8.62 6.34
Inventories 54.1 56.2 62.9 66.3 88.2 136.4 169.9 211.6 263.6 328.3
Inventories, % 3.89 6.39 4.99 2.91 3.49 4.33 4.33 4.33 4.33 4.33
Accounts Payable 106.2 71.2 76.6 130.2 137.2 207.4 258.4 321.8 400.9 499.3
Accounts Payable, % 7.63 8.1 6.07 5.71 5.43 6.59 6.59 6.59 6.59 6.59
Capital Expenditure -169.7 -86.0 -132.8 -171.5 -167.8 -293.8 -366.0 -455.8 -567.8 -707.2
Capital Expenditure, % -12.19 -9.78 -10.53 -7.52 -6.64 -9.33 -9.33 -9.33 -9.33 -9.33
Tax Rate, % 15.68 15.68 15.68 15.68 15.68 15.68 15.68 15.68 15.68 15.68
EBITAT 132.3 -86.1 95.1 481.5 680.6 393.1 489.6 609.8 759.6 946.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 49.1 13.8 230.3 506.2 775.6 416.0 653.6 814.1 1,014.0 1,263.0
WACC, % 12.56 12.74 12.71 12.6 12.62 12.65 12.65 12.65 12.65 12.65
PV UFCF
SUM PV UFCF 2,780.0
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 1,269
Terminal Value 10,450
Present Terminal Value 5,761
Enterprise Value 8,541
Net Debt 13
Equity Value 8,528
Diluted Shares Outstanding, MM 33
Equity Value Per Share 257.33

What You Will Receive

  • Pre-Filled Financial Model: CONSOL Energy Inc.’s actual data allows for accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential factors.
  • Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.

Key Features

  • Real-Life CEIX Data: Pre-filled with CONSOL Energy’s historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
  • User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.

How It Works

  • Download: Obtain the pre-prepared Excel file containing CONSOL Energy Inc.'s (CEIX) financial data.
  • Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various projections and evaluate outcomes immediately.
  • Make Decisions: Leverage the valuation results to inform your investment strategy.

Why Choose This Calculator for CONSOL Energy Inc. (CEIX)?

  • All-in-One Solution: Integrates DCF, WACC, and financial ratio analyses tailored for CONSOL Energy Inc. (CEIX).
  • Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios for CONSOL Energy Inc. (CEIX).
  • In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for CONSOL Energy Inc. (CEIX).
  • Preloaded Information: Historical and projected data provide reliable starting points for analysis.
  • Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on CONSOL Energy Inc. (CEIX).

Who Should Use This Product?

  • Investors: Assess CONSOL Energy Inc. (CEIX) valuation before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
  • Startup Founders: Understand the valuation process of established energy companies like CONSOL Energy Inc. (CEIX).
  • Consultants: Provide comprehensive valuation analyses for clients in the energy sector.
  • Students and Educators: Utilize real data to learn and teach valuation strategies in finance.

What the Template Contains

  • Pre-Filled Data: Contains CONSOL Energy Inc.'s historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Evaluate CONSOL Energy Inc.'s profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visualizations and tables summarizing essential valuation results.

No products were found matching.