FirstEnergy Corp. (FE) DCF Valuation

FirstEnergy Corp. (FE) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

FirstEnergy Corp. (FE) 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:

Explore FirstEnergy Corp.'s (FE) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate FirstEnergy Corp.'s (FE) intrinsic value and enhance your investment approach.


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,035.0 10,790.0 11,132.0 12,459.0 12,870.0 13,390.2 13,931.5 14,494.6 15,080.5 15,690.1
Revenue Growth, % 0 -2.22 3.17 11.92 3.3 4.04 4.04 4.04 4.04 4.04
EBITDA 3,271.0 3,393.0 4,243.0 3,451.0 3,729.0 4,174.4 4,343.2 4,518.7 4,701.4 4,891.4
EBITDA, % 29.64 31.45 38.12 27.7 28.97 31.18 31.18 31.18 31.18 31.18
Depreciation 1,149.0 1,228.0 1,571.0 1,010.0 1,200.0 1,428.4 1,486.1 1,546.2 1,608.7 1,673.7
Depreciation, % 10.41 11.38 14.11 8.11 9.32 10.67 10.67 10.67 10.67 10.67
EBIT 2,122.0 2,165.0 2,672.0 2,441.0 2,529.0 2,746.1 2,857.1 2,972.6 3,092.7 3,217.7
EBIT, % 19.23 20.06 24 19.59 19.65 20.51 20.51 20.51 20.51 20.51
Total Cash 627.0 1,734.0 1,462.0 160.0 137.0 997.2 1,037.5 1,079.4 1,123.0 1,168.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,294.0 1,439.0 1,279.0 1,571.0 1,584.0
Account Receivables, % 11.73 13.34 11.49 12.61 12.31
Inventories 281.0 317.0 260.0 421.0 512.0 406.5 422.9 440.0 457.8 476.3
Inventories, % 2.55 2.94 2.34 3.38 3.98 3.04 3.04 3.04 3.04 3.04
Accounts Payable 1,005.0 827.0 943.0 1,503.0 1,362.0 1,282.5 1,334.3 1,388.3 1,444.4 1,502.8
Accounts Payable, % 9.11 7.66 8.47 12.06 10.58 9.58 9.58 9.58 9.58 9.58
Capital Expenditure -2,665.0 -2,657.0 -2,445.0 -2,756.0 -3,356.0 -3,185.1 -3,313.9 -3,447.9 -3,587.2 -3,732.2
Capital Expenditure, % -24.15 -24.62 -21.96 -22.12 -26.08 -23.79 -23.79 -23.79 -23.79 -23.79
Tax Rate, % 24.73 24.73 24.73 24.73 24.73 24.73 24.73 24.73 24.73 24.73
EBITAT 1,732.6 2,069.1 2,199.0 688.7 1,903.7 1,993.7 2,074.2 2,158.1 2,245.3 2,336.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -353.4 281.1 1,658.0 -950.3 -497.3 200.8 215.3 224.0 233.1 242.5
WACC, % 5.14 5.46 5.15 3.9 4.99 4.93 4.93 4.93 4.93 4.93
PV UFCF
SUM PV UFCF 963.8
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 250
Terminal Value 12,950
Present Terminal Value 10,181
Enterprise Value 11,145
Net Debt 24,773
Equity Value -13,628
Diluted Shares Outstanding, MM 574
Equity Value Per Share -23.74

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: FirstEnergy Corp.'s (FE) financial data pre-filled to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.

Key Features

  • Real-Time FE Data: Pre-loaded with FirstEnergy Corp.’s historical financials and future projections.
  • Customizable Input Options: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Interactive Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Analysis: Develop multiple forecasting scenarios to evaluate various valuation results.
  • User-Centric Interface: Intuitive, organized, and crafted for both industry professionals and newcomers.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based FE DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
  3. Instant Calculations: The model automatically recalculates FirstEnergy Corp.'s intrinsic value.
  4. Test Scenarios: Explore various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Leverage the findings to inform your investment or financial strategy.

Why Choose This Calculator for FirstEnergy Corp. (FE)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters to suit your financial analysis needs.
  • Real-Time Valuation: Monitor immediate changes to FirstEnergy's valuation as you tweak inputs.
  • Preloaded Data: Comes with FirstEnergy's actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Employed by investors and analysts for informed decision-making.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for assessing FirstEnergy Corp. (FE) in their portfolios.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients interested in FirstEnergy Corp. (FE) stock.
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
  • Energy Sector Enthusiasts: Gain insights into how utility companies like FirstEnergy Corp. (FE) are valued in the market.

What the Template Contains

  • Pre-Filled Data: Includes FirstEnergy Corp.'s historical financials and forecasts.
  • 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: Analyze FirstEnergy Corp.'s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.