| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Column E) | Ticker | Reward = 10-Yr Total Return/Yr | Risk Aversion = Total Return in 2015 (worst year of Commodities Bear Market 4/14-4/16) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Div Yield | 5-Yr Div Growth | 3-Yr Beta | P/E | BMW Method 16-Yr CAGR (Px only) | Recent Px Trend | BMW Method Est. Loss @ -2SD | LT-Debt: Total Assets | Total Debt: EBITDA | TBV:Px | Div:FCF | S&P Bond Rating | S&P Stock Rating (Stars) | Px (50d avg) | Shares BOT | Amount | Net Present Value @ 10-Yr Holding Period & 9% Discount Rate | Graham Number | Px (50d avg): Graham Number | 7-Yr P/E | Market Cap ($B) | |
2 | Hormel Foods | HRL | 23.3% | 55.9% | 79.2% | 17.2% | 1.7% | 6.7% | -0.49 | 25 | 19.9% | on trendline | 26% | 8% | 55% | 7% | 42% | A | A+/M (3) | $40.83 | 122 | $4,981.26 | $8,182.40 | $22.00 | 196% | 33 | $23 | |
3 | Clorox | CLX | 13.6% | 25.4% | 39.0% | 14.5% | 2.5% | 6.6% | 0.27 | 25 | 11.4% | up 1SD | 23% | 45% | 194% | -9% | 58% | A- | A/M (3) | $149.81 | 33 | $4,943.73 | $1,880.54 | $28.26 | 520% | 26 | $20 | |
4 | PepsiCo | PEP | 10.5% | 8.9% | 19.4% | 8.8% | 3.3% | 9.4% | 0.43 | 33 | 8.8% | on trendline | 19% | 42% | 318% | -11% | 79% | A+ | A-/L (5) | $111.19 | 45 | $5,003.55 | $1,057.88 | $23.84 | 473% | 28 | $161 | |
5 | Xcel Energy | XEL | 14.3% | 3.3% | 17.6% | 14.8% | 3.2% | 6.4% | -0.14 | 20 | 12.3% | on trendline | 19% | 35% | 443% | 48% | no FCF | A- | A-/L (3) | $48.23 | 104 | $5,015.92 | $2,630.51 | $35.30 | 135% | 24 | $25 | |
6 | NextEra Energy | NEE | 17.1% | 0.4% | 17.5% | 17.5% | 2.6% | 10.8% | -0.17 | 10 | 15.8% | up 1SD | 25% | 30% | 389% | 41% | no FCF | A- | A/L (4) | $170.92 | 29 | $4,956.68 | $4,902.66 | $165.00 | 104% | 28 | $81 | |
7 | WEC Energy | WEC | 15.8% | 0.3% | 16.1% | 13.8% | 3.3% | 9.8% | -0.04 | 17 | 15.3% | down 1SD | 16% | 29% | 433% | 32% | 280% | A- | A/L (3) | $68.23 | 73 | $4,980.79 | $4,780.81 | $52.67 | 128% | 25 | $21 | |
8 | Johnson & Johnson | JNJ | 12.6% | 1.2% | 13.8% | 11.9% | 2.6% | 6.5% | 0.31 | 250 | 10.1% | up 1SD | 24% | 19% | 120% | -7% | 50% | AAA | A-/L (4) | $138.44 | 36 | $4,983.84 | $1,240.01 | $16.24 | 838% | 32 | $382 | |
9 | Procter & Gamble | PG | 6.9% | -9.3% | -2.4% | 5.3% | 3.2% | 3.7% | -0.08 | 24 | 6.9% | on trendline | 17% | 18% | 178% | -9% | 70% | AA- | A/L (4) | $84.33 | 59 | $4,975.47 | $46.66 | $41.19 | 201% | 24 | $227 | |
10 | Walmart | WMT | 9.0% | -26.7% | -17.7% | 8.4% | 2.1% | 2.8% | 0.47 | 59 | 8.0% | up 2SD | 23% | 25% | 166% | 23% | 37% | AA | A-/L (4) | $96.49 | 52 | $5,017.48 | $29.54 | $30.90 | 307% | 21 | $300 | |
11 | Average | n = 9 | 13.7% | 6.6% | 20.3% | 12.5% | 2.7% | 7.0% | 0.06 | 51 | 12.1% | on trendline | 21% | 28% | 255% | 13% | 88% | A+ | A/M (4) | $100.94 | $4,984.30 | $2,750.11 | $46.16 | 322% | 27 | $138 | ||
12 | ||||||||||||||||||||||||||||
13 | BENCHMARKS | |||||||||||||||||||||||||||
14 | SPDR Health Care ETF | XLV | 14.2% | 6.8% | 21.0% | 15.2% | 1.4% | 9.4% | 0.93 | 17 | 7.7% | NA | NA | $92.26 | 54 | $4,982.04 | $54.13 | $18 | ||||||||||
15 | SPDR Consumer Staples ETF | XLP | 9.9% | 6.8% | 16.7% | 9.1% | 2.8% | 6.3% | 0.49 | 17 | 6.7% | NA | NA | $54.25 | 92 | $4,991.00 | $58.89 | $9 | ||||||||||
16 | SPDR Dow Jones Ind Avg ETF | DIA | 12.1% | 0.1% | 12.2% | 14.4% | 2.0% | 8.1% | 1.07 | 17 | 6.6% | up 1SD | 27% | $258.67 | 19 | $4,914.73 | -$181.15 | $21 | ||||||||||
17 | SPDR Utilities ETF | XLU | 8.8% | -4.9% | 3.9% | 10.9% | 3.4% | 4.4% | 0.1 | 9 | 6.8% | NA | NA | $53.63 | 93 | $4,987.59 | $257.06 | $8 | ||||||||||
18 | Average | n = 4 | 11.3% | 2.2% | 13.5% | 12.4% | 2.4% | 7.1% | 0.65 | 15 | 7.0% | $114.70 | $4,968.84 | $47.23 | $14 | |||||||||||||
19 | ||||||||||||||||||||||||||||
20 | Consumer Price Index | cpi | 1.9% | 1.7% | ||||||||||||||||||||||||
21 | ||||||||||||||||||||||||||||
22 | Updated 11/7/2018 |