Discounted Cash Flow (DCF) Analysis Levered
Xcel Energy Inc. (XEL)
$64.98
-2.41 (-3.58%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 11,537 | 11,529 | 11,526 | 13,431 | 15,310 | 16,474.42 | 17,727.40 | 19,075.68 | 20,526.51 | 22,087.68 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| Operating Cash Flow | 3,122 | 3,263 | 2,848 | 2,189 | 3,932 | 4,021.52 | 4,327.38 | 4,656.50 | 5,010.66 | 5,391.75 |
| Operating Cash Flow (%) | ||||||||||
| Capital Expenditure | -3,957 | -4,225 | -5,369 | -4,244 | -4,638 | -5,911.65 | -6,361.27 | -6,845.09 | -7,365.70 | -7,925.91 |
| Capital Expenditure (%) | ||||||||||
| Free Cash Flow | -835 | -962 | -2,521 | -2,055 | -706 | -1,890.14 | -2,033.89 | -2,188.59 | -2,355.04 | -2,534.16 |
Weighted Average Cost Of Capital
| Share price | $ 64.98 |
|---|---|
| Beta | 0.421 |
| Diluted Shares Outstanding | 547 |
| Cost of Debt | |
| Tax Rate | -8.43 |
| After-tax Cost of Debt | 3.54% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 5.579 |
| Total Debt | 25,219 |
| Total Equity | 35,544.06 |
| Total Capital | 60,763.06 |
| Debt Weighting | 41.50 |
| Equity Weighting | 58.50 |
| Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 11,537 | 11,529 | 11,526 | 13,431 | 15,310 | 16,474.42 | 17,727.40 | 19,075.68 | 20,526.51 | 22,087.68 |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating Cash Flow | 3,122 | 3,263 | 2,848 | 2,189 | 3,932 | 4,021.52 | 4,327.38 | 4,656.50 | 5,010.66 | 5,391.75 |
| Capital Expenditure | -3,957 | -4,225 | -5,369 | -4,244 | -4,638 | -5,911.65 | -6,361.27 | -6,845.09 | -7,365.70 | -7,925.91 |
| Free Cash Flow | -835 | -962 | -2,521 | -2,055 | -706 | -1,890.14 | -2,033.89 | -2,188.59 | -2,355.04 | -2,534.16 |
| WACC | ||||||||||
| PV LFCF | -1,432.41 | -1,471.74 | -1,512.15 | -1,553.67 | -1,596.33 | |||||
| SUM PV LFCF | -9,533.20 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 4.73 |
| Free cash flow (t + 1) | -2,584.84 |
| Terminal Value | -94,682.78 |
| Present Value of Terminal Value | -75,147.66 |
Intrinsic Value
| Enterprise Value | -84,680.86 |
|---|---|
| Net Debt | 25,108 |
| Equity Value | -109,788.86 |
| Shares Outstanding | 547 |
| Equity Value Per Share | -200.71 |