CNX Resources Corporation (CNX) DCF Valuation

CNX Resources Corporation (CNX) 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

CNX Resources Corporation (CNX) 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:

Optimize your time and improve precision with our (CNX) DCF Calculator! Complete with genuine CNX Resources Corporation data and customizable assumptions, this tool empowers you to forecast, analyze, and value (CNX) 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,546.3 1,085.0 2,389.5 3,925.0 1,462.7 1,724.8 2,033.9 2,398.5 2,828.3 3,335.2
Revenue Growth, % 0 -29.83 120.23 64.26 -62.73 17.92 17.92 17.92 17.92 17.92
EBITDA 726.5 81.8 29.8 377.0 2,799.8 570.5 672.7 793.3 935.4 1,103.1
EBITDA, % 46.98 7.54 1.25 9.6 191.42 33.07 33.07 33.07 33.07 33.07
Depreciation 508.5 501.8 515.1 461.2 433.6 490.1 578.0 681.6 803.7 947.8
Depreciation, % 32.88 46.25 21.56 11.75 29.64 28.42 28.42 28.42 28.42 28.42
EBIT 218.1 -420.0 -485.4 -84.3 2,366.2 182.6 215.3 253.9 299.4 353.1
EBIT, % 14.1 -38.71 -20.31 -2.15 161.77 10.59 10.59 10.59 10.59 10.59
Total Cash 16.3 15.6 3.6 21.3 .4 11.1 13.1 15.4 18.2 21.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 209.6 150.3 339.1 354.6 134.0
Account Receivables, % 13.55 13.85 14.19 9.04 9.16
Inventories 7.0 9.7 6.1 27.2 19.8 12.6 14.8 17.5 20.6 24.3
Inventories, % 0.45165 0.89005 0.25725 0.69188 1.36 0.72953 0.72953 0.72953 0.72953 0.72953
Accounts Payable 202.6 118.2 121.8 191.3 147.4 151.9 179.1 211.2 249.1 293.7
Accounts Payable, % 13.1 10.89 5.1 4.87 10.07 8.81 8.81 8.81 8.81 8.81
Capital Expenditure -1,192.6 -487.3 -465.9 -565.8 -679.4 -698.2 -823.3 -970.9 -1,144.9 -1,350.1
Capital Expenditure, % -77.12 -44.91 -19.5 -14.41 -46.45 -40.48 -40.48 -40.48 -40.48 -40.48
Tax Rate, % 22.59 22.59 22.59 22.59 22.59 22.59 22.59 22.59 22.59 22.59
EBITAT 116.7 -298.7 -380.2 -56.5 1,831.6 126.9 149.6 176.4 208.1 245.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -581.4 -311.9 -512.8 -128.0 1,769.8 -141.6 -107.7 -127.0 -149.8 -176.6
WACC, % 9 9.27 9.38 9.21 9.37 9.25 9.25 9.25 9.25 9.25
PV UFCF
SUM PV UFCF -536.0
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) -178
Terminal Value -2,030
Present Terminal Value -1,304
Enterprise Value -1,840
Net Debt 2,365
Equity Value -4,205
Diluted Shares Outstanding, MM 192
Equity Value Per Share -21.90

What You Will Receive

  • Pre-Filled Financial Model: CNX Resources Corporation’s actual data facilitates accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
  • Instantaneous Calculations: Automatic updates provide immediate results as adjustments are made.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, allowing repeated use for in-depth forecasts.

Key Features

  • Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for CNX Resources Corporation (CNX).
  • WACC Tool: Ready-to-use Weighted Average Cost of Capital calculator with adjustable parameters for precise analysis.
  • Customizable Forecast Inputs: Easily adjust growth projections, capital expenditures, and discount rates.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency metrics specifically for CNX Resources Corporation (CNX).
  • Interactive Dashboard and Visualizations: Graphical representations of essential valuation indicators for straightforward evaluation.

How It Works

  • 1. Access the Template: Download and open the Excel file containing CNX Resources Corporation's (CNX) preloaded data.
  • 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
  • 3. Analyze Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
  • 4. Explore Scenarios: Evaluate various forecasts to understand different valuation outcomes for CNX.
  • 5. Present with Assurance: Deliver professional valuation insights to reinforce your investment decisions regarding CNX Resources Corporation (CNX).

Why Choose This Calculator for CNX Resources Corporation (CNX)?

  • Designed for Industry Experts: A sophisticated tool tailored for analysts, financial officers, and consultants.
  • Accurate Data: CNX's historical and projected financials are preloaded for precise analysis.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly Interface: Clear, step-by-step instructions facilitate a smooth experience.

Who Should Use This Product?

  • Finance Students: Master valuation methods and apply them with real-world data for CNX Resources Corporation (CNX).
  • Academics: Integrate industry-standard models into your curriculum or research focused on CNX.
  • Investors: Validate your investment hypotheses and evaluate valuation scenarios for CNX Resources Corporation (CNX).
  • Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for CNX.
  • Small Business Owners: Discover how large public entities like CNX Resources Corporation (CNX) are assessed and valued.

What the Template Contains

  • Pre-Filled DCF Model: CNX Resources Corporation’s (CNX) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to CNX.
  • Financial Ratios: Assess CNX’s profitability, leverage, and efficiency metrics.
  • Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
  • Financial Statements: Comprehensive annual and quarterly reports for in-depth evaluation.
  • Interactive Dashboard: Visualize key valuation metrics and outcomes with ease.

No products were found matching.