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 |