Xcel Energy Inc. 6.25% Junior Subordinated Notes, Series due 2085 (XELLL) · DCF calculator
What is one share of Xcel Energy Inc. 6.25% Junior Subordinated Notes, Series due 2085 worth today if its net income keeps growing and the market keeps paying the multiple it has paid? Every starting value below comes from Xcel Energy Inc. 6.25% Junior Subordinated Notes, Series due 2085's own filings and price history. Change any of them; nothing here is a forecast or advice.
Net income, as filed and projected
| Year | Growth | Net income |
|---|---|---|
| 1 | 8.6% | 2.43B |
| 2 | 7.7% | 2.61B |
| 3 | 7.0% | 2.80B |
| 4 | 6.3% | 2.97B |
| 5 | 5.6% | 3.14B |
How it is worked out
The figure is grown for each year of the horizon at a rate that fades, the multiple puts a market value on the last year's figure, and that value is divided over the share count as it will be by then. What that future price is worth today is it discounted at the return you want.
growth in year n = g × (1 − fade)n−1
figure in year n = figure in year n−1 × (1 + growth in year n)
future price = figure in year N × multiple ÷ (shares today × (1 + share change)N)
fair value = future price ÷ (1 + return wanted)N
The starting values are Xcel Energy Inc. 6.25% Junior Subordinated Notes, Series due 2085's own: the latest twelve months of the figure as filed, what it actually grew at over four years, the company's own five-year median multiple of it or today's if that is lower, and what its share count actually did. A model this simple is only as good as the assumptions put into it, and the most important one -- that the business keeps growing -- is the one no filing can tell you.