|
Valoración de DCF de Eversource Energy (ES)
US | Utilities | Regulated Electric | NYSE
|
- ✓ 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
Eversource Energy (ES) Bundle
¡Agilice su flujo de trabajo y mejore la precisión con nuestra calculadora DCF de Eversource Energy (ES)! Utilizando datos de energía real y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar la (s) Eversource Energy (s) como un inversor experimentado.
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 | 8,526.5 | 8,904.4 | 9,863.1 | 12,289.3 | 11,910.7 | 13,004.0 | 14,197.7 | 15,500.9 | 16,923.8 | 18,477.3 |
| Revenue Growth, % | 0 | 4.43 | 10.77 | 24.6 | -3.08 | 9.18 | 9.18 | 9.18 | 9.18 | 9.18 |
| EBITDA | 2,801.4 | 3,253.9 | 3,487.9 | 4,187.4 | 1,396.1 | 3,915.7 | 4,275.1 | 4,667.5 | 5,096.0 | 5,563.7 |
| EBITDA, % | 32.86 | 36.54 | 35.36 | 34.07 | 11.72 | 30.11 | 30.11 | 30.11 | 30.11 | 30.11 |
| Depreciation | 1,080.7 | 1,159.1 | 1,335.0 | 1,643.1 | 815.7 | 1,546.0 | 1,688.0 | 1,842.9 | 2,012.1 | 2,196.8 |
| Depreciation, % | 12.67 | 13.02 | 13.54 | 13.37 | 6.85 | 11.89 | 11.89 | 11.89 | 11.89 | 11.89 |
| EBIT | 1,720.8 | 2,094.8 | 2,152.9 | 2,544.2 | 580.4 | 2,369.6 | 2,587.1 | 2,824.6 | 3,083.9 | 3,367.0 |
| EBIT, % | 20.18 | 23.53 | 21.83 | 20.7 | 4.87 | 18.22 | 18.22 | 18.22 | 18.22 | 18.22 |
| Total Cash | 15.4 | 106.6 | 66.8 | 374.6 | 53.9 | 144.5 | 157.8 | 172.2 | 188.0 | 205.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,170.4 | 1,429.0 | 1,436.9 | 1,756.1 | 1,656.9 | 1,886.7 | 2,059.9 | 2,249.0 | 2,455.4 | 2,680.8 |
| Account Receivables, % | 13.73 | 16.05 | 14.57 | 14.29 | 13.91 | 14.51 | 14.51 | 14.51 | 14.51 | 14.51 |
| Inventories | 235.5 | 265.6 | 267.5 | 374.4 | 507.3 | 410.0 | 447.6 | 488.7 | 533.5 | 582.5 |
| Inventories, % | 2.76 | 2.98 | 2.71 | 3.05 | 4.26 | 3.15 | 3.15 | 3.15 | 3.15 | 3.15 |
| Accounts Payable | 1,147.9 | 1,370.6 | 1,672.2 | 2,113.9 | 1,869.2 | 2,046.9 | 2,234.8 | 2,440.0 | 2,664.0 | 2,908.5 |
| Accounts Payable, % | 13.46 | 15.39 | 16.95 | 17.2 | 15.69 | 15.74 | 15.74 | 15.74 | 15.74 | 15.74 |
| Capital Expenditure | -2,911.5 | -2,943.0 | -3,175.1 | -3,441.9 | -4,336.8 | -4,260.3 | -4,651.4 | -5,078.3 | -5,544.5 | -6,053.4 |
| Capital Expenditure, % | -34.15 | -33.05 | -32.19 | -28.01 | -36.41 | -32.76 | -32.76 | -32.76 | -32.76 | -32.76 |
| Tax Rate, % | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 | -60.79 |
| EBITAT | 1,314.4 | 1,619.5 | 1,671.3 | 1,915.5 | 933.2 | 1,927.0 | 2,103.9 | 2,297.1 | 2,507.9 | 2,738.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -774.4 | -230.3 | 122.8 | 132.4 | -2,866.2 | -742.0 | -882.4 | -963.4 | -1,051.8 | -1,148.4 |
| WACC, % | 5.11 | 5.13 | 5.14 | 5.08 | 5.71 | 5.23 | 5.23 | 5.23 | 5.23 | 5.23 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -4,076.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,171 | |||||||||
| Terminal Value | -36,242 | |||||||||
| Present Terminal Value | -28,085 | |||||||||
| Enterprise Value | -32,161 | |||||||||
| Net Debt | 26,701 | |||||||||
| Equity Value | -58,862 | |||||||||
| Diluted Shares Outstanding, MM | 350 | |||||||||
| Equity Value Per Share | -168.38 |
What You Will Get
- Real Eversource Energy (ES) Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Eversource Energy's future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Eversource Energy (ES).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Eversource Energy (ES).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit Eversource Energy (ES).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Eversource Energy (ES).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Eversource Energy (ES).
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Eversource Energy (ES) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Eversource Energy’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Eversource Energy (ES)?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and energy consultants.
- Accurate Data: Eversource Energy’s historical and projected financials are preloaded for precision.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance helps you navigate the process seamlessly.
Who Should Use This Product?
- Energy Sector Students: Understand energy market dynamics and apply concepts using real-world data.
- Researchers: Utilize industry-specific models for academic studies or projects.
- Investors: Validate your investment strategies and assess valuation scenarios for Eversource Energy (ES).
- Financial Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for the energy sector.
- Utility Company Owners: Discover how large utilities like Eversource Energy (ES) are evaluated in the market.
What the Eversource Energy Template Contains
- Preloaded ES Data: Historical and projected financial information, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets designed for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for modifying revenue growth, tax rates, and discount rates.
- Financial Statements: Detailed annual and quarterly financials for in-depth analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to assess performance.
- Dashboard and Charts: Visual representations of valuation outcomes and underlying assumptions.