|
NextEra Energy, Inc. (NEE) DCF Valuation
US | Utilities | Regulated Electric | NYSE
|
- ✓ 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
NextEra Energy, Inc. (NEE) Bundle
Designed for accuracy, our NextEra Energy, Inc. (NEE) DCF Calculator empowers you to evaluate NextEra Energy, Inc. (NEE) valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 19,204.0 | 17,997.0 | 17,069.0 | 20,956.0 | 28,114.0 | 31,311.1 | 34,871.8 | 38,837.4 | 43,254.0 | 48,172.9 |
Revenue Growth, % | 0 | -6.29 | -5.16 | 22.77 | 34.16 | 11.37 | 11.37 | 11.37 | 11.37 | 11.37 |
EBITDA | 9,821.0 | 8,227.0 | 8,824.0 | 10,359.0 | 16,472.0 | 16,067.1 | 17,894.3 | 19,929.2 | 22,195.5 | 24,719.6 |
EBITDA, % | 51.14 | 45.71 | 51.7 | 49.43 | 58.59 | 51.31 | 51.31 | 51.31 | 51.31 | 51.31 |
Depreciation | 4,478.0 | 4,315.0 | 4,214.0 | 4,790.0 | 6,151.0 | 7,309.2 | 8,140.4 | 9,066.1 | 10,097.1 | 11,245.3 |
Depreciation, % | 23.32 | 23.98 | 24.69 | 22.86 | 21.88 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 |
EBIT | 5,343.0 | 3,912.0 | 4,610.0 | 5,569.0 | 10,321.0 | 8,757.9 | 9,753.9 | 10,863.1 | 12,098.4 | 13,474.3 |
EBIT, % | 27.82 | 21.74 | 27.01 | 26.57 | 36.71 | 27.97 | 27.97 | 27.97 | 27.97 | 27.97 |
Total Cash | 600.0 | 1,105.0 | 639.0 | 1,601.0 | 2,690.0 | 1,892.2 | 2,107.4 | 2,347.0 | 2,613.9 | 2,911.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,807.0 | 2,974.0 | 4,108.0 | 5,093.0 | 6,040.0 | 6,324.6 | 7,043.8 | 7,844.9 | 8,737.0 | 9,730.5 |
Account Receivables, % | 14.62 | 16.52 | 24.07 | 24.3 | 21.48 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 |
Inventories | 1,328.0 | 1,552.0 | 1,561.0 | 1,934.0 | 2,106.0 | 2,592.8 | 2,887.7 | 3,216.0 | 3,581.8 | 3,989.1 |
Inventories, % | 6.92 | 8.62 | 9.15 | 9.23 | 7.49 | 8.28 | 8.28 | 8.28 | 8.28 | 8.28 |
Accounts Payable | 3,631.0 | 4,615.0 | 6,935.0 | 8,312.0 | 8,504.0 | 9,712.2 | 10,816.7 | 12,046.8 | 13,416.7 | 14,942.5 |
Accounts Payable, % | 18.91 | 25.64 | 40.63 | 39.66 | 30.25 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 |
Capital Expenditure | -11,077.0 | -7,759.0 | -7,830.0 | -9,742.0 | -9,548.0 | -14,222.5 | -15,839.9 | -17,641.2 | -19,647.3 | -21,881.6 |
Capital Expenditure, % | -57.68 | -43.11 | -45.87 | -46.49 | -33.96 | -45.42 | -45.42 | -45.42 | -45.42 | -45.42 |
Tax Rate, % | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 | -0.30187 |
EBITAT | 5,249.7 | 4,732.3 | 4,104.7 | 4,717.4 | 10,352.2 | 8,267.5 | 9,207.7 | 10,254.8 | 11,420.9 | 12,719.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,853.3 | 1,881.3 | 1,665.7 | -215.6 | 6,028.2 | 1,791.0 | 1,598.6 | 1,780.3 | 1,982.8 | 2,208.3 |
WACC, % | 6.22 | 6.25 | 6.08 | 6.01 | 6.25 | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 |
PV UFCF | ||||||||||
SUM PV UFCF | 7,792.3 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 2,297 | |||||||||
Terminal Value | 106,290 | |||||||||
Present Terminal Value | 78,827 | |||||||||
Enterprise Value | 86,619 | |||||||||
Net Debt | 70,521 | |||||||||
Equity Value | 16,098 | |||||||||
Diluted Shares Outstanding, MM | 2,031 | |||||||||
Equity Value Per Share | 7.93 |
What You Will Get
- Real NEE Financial Data: Pre-filled with NextEra Energy’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See NextEra Energy’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for NextEra Energy, Inc. (NEE).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the energy sector.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit NextEra's strategic outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for NextEra Energy, Inc. (NEE).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing NextEra Energy, Inc.'s (NEE) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to back your investment decisions.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned users.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Adjustments: Observe immediate changes to NextEra Energy’s valuation as you modify inputs.
- Preloaded Data: Comes with NextEra Energy’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately estimate NextEra Energy's fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis at NextEra Energy, Inc. (NEE).
- Consultants: Quickly adapt the template for valuation reports tailored to clients interested in NextEra Energy, Inc. (NEE).
- Entrepreneurs: Gain insights into financial modeling strategies employed by leading energy companies like NextEra Energy, Inc. (NEE).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to the energy sector.
What the Template Contains
- Historical Data: Includes NextEra Energy’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate NextEra Energy’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of NextEra Energy’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.