|
Hawaiian Electric Industries, Inc. (HE) DCF Valuation
US | Utilities | Diversified Utilities | 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
Hawaiian Electric Industries, Inc. (HE) Bundle
Looking to assess the intrinsic value of Hawaiian Electric Industries, Inc.? Our (HE) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 2,874.6 | 2,579.8 | 2,850.4 | 3,742.0 | 3,682.2 | 3,957.5 | 4,253.5 | 4,571.6 | 4,913.5 | 5,281.0 |
| Revenue Growth, % | 0 | -10.26 | 10.49 | 31.28 | -1.6 | 7.48 | 7.48 | 7.48 | 7.48 | 7.48 |
| EBITDA | 587.7 | 564.4 | 648.1 | 660.1 | 636.2 | 791.4 | 850.5 | 914.2 | 982.5 | 1,056.0 |
| EBITDA, % | 20.45 | 21.88 | 22.74 | 17.64 | 17.28 | 20 | 20 | 20 | 20 | 20 |
| Depreciation | 229.9 | 238.1 | 246.2 | 256.1 | 270.2 | 316.9 | 340.6 | 366.1 | 393.5 | 422.9 |
| Depreciation, % | 8 | 9.23 | 8.64 | 6.84 | 7.34 | 8.01 | 8.01 | 8.01 | 8.01 | 8.01 |
| EBIT | 357.9 | 326.3 | 402.0 | 404.0 | 366.0 | 474.4 | 509.9 | 548.0 | 589.0 | 633.1 |
| EBIT, % | 12.45 | 12.65 | 14.1 | 10.8 | 9.94 | 11.99 | 11.99 | 11.99 | 11.99 | 11.99 |
| Total Cash | 1,429.6 | 2,311.8 | 2,880.2 | 1,629.5 | 1,816.0 | 2,629.5 | 2,826.2 | 3,037.5 | 3,264.7 | 3,508.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5,368.6 | 147.8 | 5,484.2 | 6,418.6 | 575.2 | 2,543.5 | 2,733.7 | 2,938.2 | 3,157.9 | 3,394.1 |
| Account Receivables, % | 186.76 | 5.73 | 192.4 | 171.53 | 15.62 | 64.27 | 64.27 | 64.27 | 64.27 | 64.27 |
| Inventories | -416.8 | -307.2 | -411.8 | -.8 | .0 | -323.6 | -347.8 | -373.8 | -401.7 | -431.8 |
| Inventories, % | -14.5 | -11.91 | -14.45 | -0.0220204 | 0 | -8.18 | -8.18 | -8.18 | -8.18 | -8.18 |
| Accounts Payable | 220.6 | 182.3 | 205.5 | 251.5 | 247.5 | 280.2 | 301.1 | 323.6 | 347.8 | 373.8 |
| Accounts Payable, % | 7.68 | 7.07 | 7.21 | 6.72 | 6.72 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 |
| Capital Expenditure | -457.5 | -383.9 | -314.5 | -344.0 | -448.3 | -500.2 | -537.6 | -577.9 | -621.1 | -667.5 |
| Capital Expenditure, % | -15.92 | -14.88 | -11.03 | -9.19 | -12.17 | -12.64 | -12.64 | -12.64 | -12.64 | -12.64 |
| Tax Rate, % | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 |
| EBITAT | 289.8 | 270.8 | 320.8 | 322.8 | 299.6 | 384.8 | 413.5 | 444.5 | 477.7 | 513.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4,669.0 | 5,197.9 | -4,956.1 | -1,064.7 | 5,960.1 | -1,410.6 | 71.5 | 76.8 | 82.6 | 88.7 |
| WACC, % | 4.32 | 4.4 | 4.28 | 4.29 | 4.36 | 4.33 | 4.33 | 4.33 | 4.33 | 4.33 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,077.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 89 | |||||||||
| Terminal Value | 2,329 | |||||||||
| Present Terminal Value | 1,885 | |||||||||
| Enterprise Value | 807 | |||||||||
| Net Debt | 3,356 | |||||||||
| Equity Value | -2,549 | |||||||||
| Diluted Shares Outstanding, MM | 110 | |||||||||
| Equity Value Per Share | -23.16 |
What You Will Get
- Pre-Filled Financial Model: Hawaiian Electric Industries' actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- 🔍 Real-Life HE Financials: Pre-filled historical and projected data for Hawaiian Electric Industries, Inc. (HE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Hawaiian Electric’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Hawaiian Electric’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based HE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Hawaiian Electric's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Accurate Data: Real Hawaiian Electric Industries, Inc. (HE) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you the effort of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the energy sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate Hawaiian Electric Industries, Inc. (HE) to make informed decisions on stock trades.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
- Startup Founders: Gain insights into how large utilities like Hawaiian Electric Industries, Inc. (HE) are appraised.
- Consultants: Provide comprehensive valuation analyses for your clients in the energy sector.
- Students and Educators: Utilize actual market data to learn and teach valuation strategies effectively.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Hawaiian Electric Industries, Inc. (HE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Hawaiian Electric Industries, Inc. (HE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.