| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Col E) | Ticker | Reward = Total Return/Yr since market peak on 7/19/2007 | Risk Aversion = Total Return/Yr during Commodities Bear Market (4/14-4/16) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Div Yield | 5-Yr Div Growth | 5-Yr Beta | P/E | BMW Method 20-Yr CAGR (Px only) | Recent Px Trend | BMW Method Est. Loss @ -2SD | 2017 Barron's 500 Rank | 2016 Barron's 500 Rank | LT Debt: Total Assets | Operating Cash Flow Ratio | TBV:Px | Div:FCF | S&P Bond Rating | S&P Stock Rating | Px (50d avg) | Shares BOT | Amount | PV of Expected Cash Flows after 10-Yr Holding Period | Net Present Value @ 9% Discount Rate | WACC | ROIC | Market Cap ($B) | Div Achiever | |
2 | Consolidated Edison | ED | 11.2% | 25.2% | 36.4% | 11.2% | 3.3% | 2.7% | -0.04 | 19 | 9.7% | up 2SD | 22% | 363 | 464 | 31% | 90% | 59% | no FCF | A- | B+/L | $82.56 | 61 | $5,036.16 | $6,341.63 | $1,176.34 | 2.3% | 5.6% | $26 | yes | |
3 | Xcel Energy | XEL | 13.4% | 22.0% | 35.4% | 17.6% | 2.9% | 5.9% | 0.06 | 23 | 10.1% | up 2SD | 40% | 297 | 399 | 33% | 94% | 46% | no FCF | A- | A-/L | $47.52 | 105 | $4,989.60 | $6,495.05 | $1,377.51 | 2.6% | 5.9% | $25 | yes | |
4 | WEC Energy | WEC | 14.7% | 17.8% | 32.5% | 15.3% | 3.2% | 6.3% | -0.04 | 22 | 14.4% | on trendline | 26% | 441 | 465 | 31% | 87% | 30% | 92% | A- | A/L | $63.18 | 79 | $4,991.22 | $9,119.85 | $4,000.65 | 2.1% | 5.8% | $21 | yes | |
5 | American Electric Power | AEP | 9.4% | 19.2% | 28.6% | 15.9% | 3.2% | 4.7% | 0.09 | 52 | 9.1% | up 2SD | 33% | 293 | 362 | 27% | 48% | 51% | no FCF | A- | B+/L | $70.74 | 71 | $5,022.54 | $6,125.95 | $974.63 | 3.1% | 2.6% | $36 | ||
6 | NextEra Energy | NEE | 13.5% | 15.1% | 28.6% | 21.0% | 2.6% | 10.4% | 0.28 | 15 | 14.5% | up 1SD | 27% | 468 | 304 | 31% | 58% | 39% | 68% | A- | A/L | $145.16 | 34 | $4,935.44 | $9,031.21 | $3,969.22 | 3.4% | 7.1% | $71 | yes | |
7 | DTE Energy | DTE | 12.8% | 14.2% | 27.0% | 17.9% | 3.0% | 7.0% | 0.1 | 20 | 11.7% | up 2SD | 30% | 364 | 469 | 35% | 86% | 31% | 1400% | BBB+ | A-/M | $108.09 | 46 | $4,972.14 | $7,356.51 | $2,256.88 | 3.0% | 6.4% | $20 | ||
8 | Eversource Energy | ES | 11.0% | 12.8% | 23.8% | 12.6% | 3.0% | 6.7% | 0.18 | 21 | 11.9% | up 1SD | 36% | 394 | 310 | 29% | 60% | 37% | 290% | A | A/L | $61.55 | 81 | $4,985.55 | $7,486.96 | $2,373.58 | 3.0% | 5.6% | $20 | yes | |
9 | Southern | SO | 8.5% | 14.3% | 22.8% | 6.0% | 4.8% | 3.4% | 0.03 | 18 | 9.5% | down 1SD | 27% | 311 | 409 | 39% | 38% | 35% | no FCF | A- | A-/L | $48.20 | 104 | $5,012.80 | $6,746.78 | $1,605.45 | 2.3% | 2.5% | $48 | yes | |
10 | Duke Energy | DUK | 10.2% | 11.5% | 21.7% | 10.7% | 4.1% | 3.1% | 0.08 | 28 | 8.6% | up 1SD | 36% | 358 | 369 | 35% | 59% | 37% | no FCF | A- | B/L | $85.38 | 59 | $5,037.42 | $6,134.58 | $968.00 | 2.6% | 4.3% | $61 | yes | |
11 | Public Service Enterprise | PEG | 4.5% | 16.4% | 20.9% | 12.7% | 3.6% | 3.9% | 0.27 | 45 | 9.6% | on trendline | 30% | 473 | 408 | 28% | 101% | 21% | no FCF | BBB+ | B+/L | $44.73 | 112 | $5,009.76 | $6,484.88 | $1,346.66 | 3.4% | 2.3% | $24 | ||
12 | Dominion Energy | D | 10.5% | 7.1% | 17.6% | 12.6% | 3.8% | 7.4% | 0.22 | 23 | 11.3% | on trendline | 22% | 396 | 406 | 43% | 51% | 18% | no FCF | BBB+ | B/L | $77.63 | 64 | $4,968.32 | $7,472.87 | $2,377.16 | 3.1% | 5.8% | $52 | yes | |
13 | Exelon | EXC | -2.9% | 7.5% | 4.6% | 5.2% | 3.4% | -9.2% | 0.29 | 18 | 5.4% | on trendline | 54% | 387 | 255 | 27% | 63% | 56% | no FCF | BBB | B/L | $37.32 | 134 | $5,000.88 | $4,263.32 | -$865.79 | 2.2% | 30.4% | $37 | ||
14 | Average | n = 12 | 9.7% | 15.3% | 25.0% | 13.2% | 3.4% | 4.4% | 0.13 | 25 | 10.5% | up 1SD | 32% | 379 | 385 | 32% | 70% | 38% | 460% | A- | B+/L | $72.67 | $4,996.82 | $6,921.63 | $1,796.69 | 2.8% | 7.0% | $37 | yes | ||
15 | |||||||||||||||||||||||||||||||
16 | BENCHMARKS | ||||||||||||||||||||||||||||||
17 | SPDR Utilities Select Sector Index ETF | XLU | 7.2% | 13.7% | 20.9% | 12.6% | 3.2% | 5.0% | 0.27 | 18 | |||||||||||||||||||||
18 | Berkshire Hathaway | BRK-B | 9.2% | 6.6% | 15.8% | 16.2% | 0.0% | 0.0% | 0.85 | 19 | 8.7% | up 1SD | 24% | 274 | 187 | 16% | 93% | 43% | no dividend | AA | B+/M | $174.14 | 29 | $5,050.06 | $4,789.41 | -$390.14 | 6.5% | 7.1% | $440 | ||
19 | Vanguard High Dividend Yield Index ETF | VYM | 7.1% | 7.7% | 14.8% | 13.2% | 2.9% | 10.8% | 0.9 | 18 | |||||||||||||||||||||
20 | SPDR S&P 500 Index ETF | SPY | 6.9% | 6.6% | 13.5% | 13.9% | 1.9% | 11.4% | 1 | 24 | 4.9% | up 1SD | 33% | $244.94 | 20 | $4,898.80 | $4,087.06 | -$937.35 | |||||||||||||
21 | Vanguard Interm-Term Bond Index ETN | BIV | 5.7% | 6.3% | 12.0% | 2.5% | 2.5% | -11.5% | 0 | NA | 5.5% | down 2SD | 8% | $84.84 | 59 | $5,005.56 | $4,043.99 | -$1,089.92 | |||||||||||||
22 | SPDR S&P 400 MidCap Index ETF | MDY | 7.7% | 3.2% | 10.9% | 13.3% | 1.1% | 16.4% | 1.03 | 21 | 8.3% | on trendline | 26% | $317.15 | 16 | $5,074.40 | $5,263.70 | $59.19 | |||||||||||||
23 | Average | n = 6 | 7.3% | 7.4% | 14.7% | 12.0% | 1.9% | 5.4% | 0.68 | 20 | 6.9% | on trendline | 23% | $205.27 | $5,007.21 | $4,546.04 | -$589.56 | ||||||||||||||
24 | |||||||||||||||||||||||||||||||
25 | Consumer Price Index | cpi | 1.7% | 1.2% | |||||||||||||||||||||||||||
26 | |||||||||||||||||||||||||||||||
27 | Updated 9/1/2017 |