Evergy, Inc. (EVRG) DCF Valuation

Evergy, Inc. (EVRG) DCF Valuation

US | Utilities | Regulated Electric | NASDAQ
Evergy, Inc. (EVRG) 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

Evergy, Inc. (EVRG) Bundle

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

TOTAL:

If you're an investor or analyst, this [EVRG] DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Evergy, Inc., you can adjust forecasts and instantly observe the effects.


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 5,147.8 4,913.4 5,586.7 5,859.1 5,508.2 5,618.9 5,731.8 5,846.9 5,964.4 6,084.2
Revenue Growth, % 0 -4.55 13.7 4.88 -5.99 2.01 2.01 2.01 2.01 2.01
EBITDA 2,059.9 2,039.2 2,314.5 2,194.1 2,416.5 2,295.5 2,341.6 2,388.7 2,436.6 2,485.6
EBITDA, % 40.02 41.5 41.43 37.45 43.87 40.85 40.85 40.85 40.85 40.85
Depreciation 913.1 938.4 947.8 984.9 1,138.9 1,025.9 1,046.5 1,067.5 1,089.0 1,110.8
Depreciation, % 17.74 19.1 16.97 16.81 20.68 18.26 18.26 18.26 18.26 18.26
EBIT 1,146.8 1,100.8 1,366.7 1,209.2 1,277.6 1,269.6 1,295.1 1,321.1 1,347.7 1,374.8
EBIT, % 22.28 22.4 24.46 20.64 23.19 22.6 22.6 22.6 22.6 22.6
Total Cash 23.2 144.9 26.2 25.2 27.7 54.0 55.0 56.2 57.3 58.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 653.0 336.8 568.6 683.6 610.4
Account Receivables, % 12.69 6.85 10.18 11.67 11.08
Inventories 481.6 504.5 566.7 672.9 776.2 621.9 634.4 647.2 660.2 673.4
Inventories, % 9.36 10.27 10.14 11.48 14.09 11.07 11.07 11.07 11.07 11.07
Accounts Payable 528.8 654.0 639.7 600.8 616.9 634.8 647.5 660.6 673.8 687.4
Accounts Payable, % 10.27 13.31 11.45 10.25 11.2 11.3 11.3 11.3 11.3 11.3
Capital Expenditure -596.1 -1,560.3 -1,972.5 -2,166.5 -2,334.0 -1,775.5 -1,811.2 -1,847.5 -1,884.7 -1,922.5
Capital Expenditure, % -11.58 -31.76 -35.31 -36.98 -42.37 -31.6 -31.6 -31.6 -31.6 -31.6
Tax Rate, % 2.73 2.73 2.73 2.73 2.73 2.73 2.73 2.73 2.73 2.73
EBITAT 994.1 940.2 1,201.0 1,130.4 1,242.8 1,144.5 1,167.5 1,190.9 1,214.9 1,239.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 705.3 736.8 -132.0 -311.3 33.7 587.8 391.2 399.1 407.1 415.3
WACC, % 5.65 5.62 5.67 5.79 5.88 5.72 5.72 5.72 5.72 5.72
PV UFCF
SUM PV UFCF 1,884.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 424
Terminal Value 11,379
Present Terminal Value 8,615
Enterprise Value 10,499
Net Debt 13,246
Equity Value -2,747
Diluted Shares Outstanding, MM 231
Equity Value Per Share -11.92

What You Will Get

  • Real Evergy Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Evergy’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Comprehensive EVRG Data: Pre-loaded with Evergy’s historical financial performance and future projections.
  • Customizable Financial Inputs: Modify growth rates, operating margins, discount rates, tax assumptions, and capital expenditures.
  • Interactive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • Intuitive User Interface: Well-organized and designed for both seasoned professionals and newcomers.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Evergy, Inc. (EVRG) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Evergy, Inc. (EVRG)'s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Evergy, Inc. (EVRG)?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Adjustments: Monitor immediate changes to Evergy’s valuation as you modify inputs.
  • Preloaded Data: Comes with Evergy’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Favored by investors and financial analysts for making strategic decisions.

Who Should Use Evergy, Inc. (EVRG)?

  • Investors: Gain insights for informed decisions with a reliable energy sector analysis tool.
  • Financial Analysts: Streamline your workflow with a customizable financial model tailored for utilities.
  • Consultants: Effortlessly modify the framework for client reports or energy market presentations.
  • Energy Enthusiasts: Enhance your knowledge of the energy sector using practical case studies.
  • Educators and Students: Utilize it as a hands-on resource in energy finance courses.

What the Evergy, Inc. (EVRG) Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
  • Real-World Data: Evergy’s historical and projected financials preloaded for in-depth analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Graphs and tables providing clear, actionable results.

No products were found matching.