| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Col E) | Ticker | Reward = Total Return/Yr Since 9/28/1992 | Risk = Total Return/Yr @ Housing Crisis (4/07-10/11) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Div Yield | 10-Yr Div Growth | 5-Yr Beta | P/E | LT-Debt:Total Assets | 16-Yr Px CAGR | Recent Px Trend | Est Loss @ -2SD | S&P Bond Rating | S&P Stock Rating | 2016 Barron's 500 Rank | 2015 Barron's 500 Rank | Stock Px (50d avg) | Shares BOT | Amount | PV of Expected Cash Flows | Net Present Value | WACC | ROIC | |
2 | VF | VFC | 12.6% | 12.3% | 24.9% | 13.2% | 3.0% | 10.4% | 0.82 | 22 | 15% | 16.5% | down 1SD | 34% | A | A/M | 157 | 95 | $54.78 | 91 | $4,984.98 | $10,773.54 | $5,660.74 | 8.0% | 18.8% | |
3 | Hormel Foods | HRL | 13.6% | 10.6% | 24.2% | 20.9% | 1.7% | 15.3% | 0.5 | 23 | 4% | 14.7% | up 1SD | 31% | A | A+/M | 67 | 124 | $37.56 | 133 | $4,995.48 | $8,912.73 | $3,789.16 | 5.8% | 20.1% | |
4 | Brown-Forman | BF-B | 13.2% | 9.9% | 23.1% | 14.1% | 1.5% | 8.1% | 0 | 17 | 41% | 13.7% | down 1SD | 26% | A- | A/M | NA | NA | $46.08 | 109 | $5,022.72 | $8,062.14 | $2,910.63 | 8.1% | 37.8% | |
5 | Ecolab | ECL | 16.1% | 4.2% | 20.3% | 17.1% | 1.2% | 13.3% | 1.08 | 32 | 28% | 13.1% | on trendline | 24% | A- | A/M | 131 | 17 | $116.68 | 43 | $5,017.24 | $7,661.68 | $2,515.79 | 9.0% | 9.7% | |
6 | Sherwin-Williams | SHW | 14.9% | 4.9% | 19.8% | 26.4% | 1.3% | 12.9% | 1.31 | 22 | 29% | 19.3% | down 1SD | 33% | A | A/M | 43 | 36 | $263.83 | 19 | $5,012.77 | $12,667.00 | $7,525.70 | 11.2% | 43.7% | |
7 | Coca-Cola | KO | 8.4% | 10.9% | 19.3% | 7.0% | 3.4% | 8.5% | 0.8 | 25 | 31% | 7.6% | down 1SD | 24% | AA- | A/L | 253 | 444 | $42.01 | 119 | $4,999.19 | $5,634.13 | $506.76 | 6.8% | 13.9% | |
8 | McCormick | MKC | 10.6% | 7.0% | 17.6% | 15.6% | 1.9% | 9.1% | 0.57 | 25 | 23% | 12.3% | on trendline | 24% | A- | A+/L | NA | NA | $95.12 | 53 | $5,041.36 | $7,395.62 | $2,224.99 | 6.0% | 15.0% | |
9 | Air Products & Chemicals | APD | 10.7% | 3.2% | 13.9% | 14.8% | 2.5% | 10.6% | 1.18 | 48 | 23% | 11.3% | on trendline | 26% | A | A-/M | 300 | 421 | $135.35 | 37 | $5,007.95 | $7,134.00 | $1,997.64 | 9.3% | 12.0% | |
10 | Wal-Mart Stores | WMT | 8.3% | 4.3% | 12.6% | 6.6% | 2.8% | 11.5% | 0.08 | 15 | 22% | 4.5% | on trendline | 24% | AA | A/L | 327 | 386 | $69.81 | 72 | $5,026.32 | $4,518.52 | -$636.68 | 2.8% | 13.6% | |
11 | PepsiCo | PEP | 9.8% | 2.3% | 12.1% | 13.7% | 2.9% | 9.7% | 0.69 | 23 | 42% | 8.3% | on trendline | 20% | A | A/L | 324 | 175 | $106.63 | 47 | $5,011.61 | $5,780.36 | $640.25 | 6.4% | 21.9% | |
12 | Exxon Mobil | XOM | 10.3% | 1.2% | 11.5% | 4.7% | 3.5% | 8.9% | 0.84 | 40 | 9% | 7.4% | down 1SD | 29% | AA+ | A-/L | 481 | 494 | $86.04 | 58 | $4,990.32 | $5,628.47 | $510.19 | 7.8% | 4.4% | |
13 | Average | n = 12 | 11.7% | 6.4% | 18.1% | 14.0% | 2.3% | 10.8% | 0.72 | 27 | 24% | 11.7% | on trendline | 27% | A | A-/L | 231 | 244 | $95.81 | $5,009.99 | $7,651.65 | $2,513.20 | 7.4% | 19.2% | ||
14 | ||||||||||||||||||||||||||
15 | BENCHMARKS | |||||||||||||||||||||||||
16 | Berkshire Hathaway | BRK-A | 14.2% | -0.2% | 14.0% | 15.6% | 0.0% | 0 | 0.72 | 14 | 17% | 8.4% | up 1SD | 23% | AA | B+/M | 187 | 248 | $145.18 | 34 | $4,936.12 | $4,553.75 | -$508.94 | 6.8% | 8.3% | |
17 | Vanguard Wellesley Income Fund | VWINX | 8.2% | 4.9% | 13.1% | 7.4% | 2.8% | -2.1% | 0.54 | 18 | $25.97 | |||||||||||||||
18 | Vanguard Total Bond Market Index Fund | VBMFX | 5.4% | 6.6% | 12.0% | 2.3% | 2.3% | -6.3% | 0 | 40 | 4.3% | down 2SD | 6% | $11.00 | ||||||||||||
19 | Barrick Gold | ABX | 1.0% | 12.5% | 13.5% | -21.1% | 0.5% | -14.6% | -0.33 | -7.2 | 35% | -0.9% | down 2SD | 65% | BBB- | B-/H | 480 | 500 | $17.15 | 292 | $5,007.80 | $1,884.48 | -$3,251.73 | 1.8% | -17.7% | |
20 | SPDR S&P MidCap 400 ETF | MDY | 10.8% | -0.7% | 10.1% | 13.5% | 1.3% | 12.6% | 1.1 | 23 | $278.61 | 18 | $5,014.98 | $5,071.38 | -$72.19 | |||||||||||
21 | Vanguard Balanced Index Fund | VBINX | 7.9% | 1.5% | 9.4% | 9.2% | 1.9% | 0.0% | 0.92 | 25 | $30.69 | |||||||||||||||
22 | Vanguard 500 Index Fund | VFINX | 9.2% | -3.0% | 6.2% | 13.8% | 1.9% | 5.1% | 1 | 25 | $198.32 | 25 | $4,958.00 | $4,125.06 | -$832.94 | |||||||||||
23 | average | n = 6 | 8.1% | 3.1% | 11.2% | 5.8% | 1.5% | -0.8% | 0.55 | 20 | $100.99 | $4,979.23 | $3,908.67 | -$1,166.45 | ||||||||||||
24 | ||||||||||||||||||||||||||
25 | Standard Indices (Px only) | |||||||||||||||||||||||||
26 | S&P 400 MidCap Index | ^MID | 10.4% | -1.9% | 8.5% | 12.1% | 7.9% | on trendline | 27% | |||||||||||||||||
27 | PHLX Gold/Silver Index | ^XAU | 0.0% | 6.5% | 6.5% | -17.9% | -0.8% | down 2SD | 58% | |||||||||||||||||
28 | S&P 500 Index | ^GSPC | 7.1% | -5.0% | 2.1% | 11.6% | 5.1% | on trendline | 30% | |||||||||||||||||
29 | Dow Jones Commodity Index | ^DJC | -0.5% | -4.4% | -4.9% | -11.1% | -3.8% | down 2SD | 38% | |||||||||||||||||
30 | ||||||||||||||||||||||||||
31 | Consumer Price Index | cpi | 2.1% | 1.5% | ||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | Updated 11/14/2016 |