| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Col E) | Ticker | Reward = Total Return/Yr since S&P 500 Peak on 9/1/00 | Risk = Total Return/Yr during Commodity Correction (7/14-7/16) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Div Yield | 4-Yr Div Growth | 5-Yr Beta | P/E | 16-Yr CAGR (Px only) | Recent Px Trend | Est Loss @ -2SD | 2016 Barron's 500 Rank | 2015 Barron's 500 Rank | LT Debt:Total Assets | TBV:Px | Div:FCF | S&P Bond Rating | S&P Stock Rating | Px (50d avg) | Shares BOT | Amount | PV of Expected Cash Flows | Net Present Value | WACC | ROIC | Div Achiever | |
2 | Verizon Communications | VZ | 5.6% | 11.4% | 17.0% | 7.2% | 5.0% | 3.0% | 0.59 | 16 | 8.0% | on trendline | 30% | 181 | 307 | 43% | -51% | negative CF | BBB+ | B/M | $48.75 | 103 | $5,021.25 | $6,045.86 | $925.86 | 4.9% | 13.4% | yes | |
3 | Pfizer | PFE | 1.9% | 12.0% | 13.9% | 12.2% | 3.8% | 7.9% | 1.04 | 29 | 5.8% | on trendline | 44% | 302 | 481 | 17% | -23% | 38% | AA | B+/M | $34.07 | 147 | $5,008.29 | $5,117.00 | -$19.71 | 7.5% | 14.0% | ||
4 | Boeing | BA | 9.9% | 3.4% | 13.3% | 22.4% | 3.1% | 27.0% | 1.19 | 23 | 13.1% | up 1SD | 41% | 49 | 385 | 11% | -7% | 40% | A | A/M | $179.61 | 28 | $5,029.08 | $9,704.97 | $4,546.94 | 8.9% | 197.6% | ||
5 | Coca-Cola | KO | 5.6% | 6.8% | 12.4% | 5.6% | 3.4% | 8.0% | 0.66 | 31 | 8.2% | on trendline | 22% | 253 | 444 | 34% | 2% | 175% | AA- | A/L | $42.60 | 117 | $4,984.20 | $5,893.47 | $781.47 | 5.3% | 14.5% | yes | |
6 | Cisco Systems | CSCO | -3.1% | 10.3% | 7.2% | 15.9% | 3.4% | 19.2% | 1.42 | 18 | 5.9% | up 1SD | 33% | 215 | 314 | 24% | 20% | 44% | AA- | B+/M | $33.73 | 148 | $4,992.04 | $5,729.36 | $609.32 | 9.7% | 35.9% | ||
7 | Exxon Mobil | XOM | 6.8% | -0.6% | 6.2% | 2.4% | 3.8% | 6.6% | 0.64 | 44 | 6.9% | down 2SD | 29% | 481 | 494 | 9% | 50% | 116% | AA+ | B+/L | $81.92 | 61 | $4,997.12 | $5,431.08 | $305.83 | 5.7% | 5.3% | yes | |
8 | Merck | MRK | 3.5% | 2.5% | 6.0% | 14.3% | 3.0% | 2.3% | 0.95 | 45 | 5.9% | up 1SD | 40% | 411 | 485 | 24% | 3% | 45% | AA | B/M | $63.82 | 78 | $4,977.96 | $4,588.55 | -$517.05 | 7.3% | 9.3% | ||
9 | Chevron | CVX | 9.3% | -6.5% | 2.8% | 4.2% | 4.1% | 4.5% | 1.21 | neg earnings | 9.9% | down 2SD | 30% | 482 | 495 | 15% | 68% | 370% | AA- | B/M | $108.20 | 46 | $4,977.20 | $6,661.14 | $1,556.32 | 8.0% | 1.1% | ||
10 | Caterpillar | CAT | 13.7% | -13.6% | 0.1% | 3.7% | 3.0% | 10.7% | 1.63 | neg earnings | 10.6% | on trendline | 43% | 452 | 470 | 31% | 8% | 61% | A | B+/M | $95.56 | 52 | $4,969.12 | $7,014.77 | $1,918.24 | 7.7% | 0.3% | ||
11 | Int'l Business Machines | IBM | 2.7% | -6.8% | -4.1% | -2.3% | 3.8% | 13.3% | 0.87 | 13 | 6.9% | down 1SD | 31% | 185 | 344 | 31% | -14% | 45% | AA- | A/M | $171.38 | 29 | $4,970.02 | $5,674.74 | $577.28 | 6.2% | 24.4% | yes | |
12 | Average | n = 10 | 5.6% | 1.9% | 7.5% | 8.6% | 3.6% | 10.3% | 1.02 | 27 | 8.1% | on trendline | 34% | 301 | 422 | 31% | -14% | 104% | AA- | A/M | $85.96 | $4,992.63 | $6,186.09 | $1,068.45 | 7.1% | 31.6% | |||
13 | |||||||||||||||||||||||||||||
14 | BENCHMARKS | ||||||||||||||||||||||||||||
15 | Berkshire Hathaway | BRK-B | 9.1% | 6.7% | 15.8% | 15.1% | 0.0% | 0.0% | 0.83 | 17 | 8.8% | up 1SD | 23% | 187 | 248 | 17% | 39% | no dividend | AA | B+/M | $169.00 | 30 | $5,070.00 | $4,852.01 | -$347.99 | 6.6% | 8.1% | ||
16 | Vanguard Wellesley Income Fund | VWINX | 7.3% | 5.5% | 12.8% | 7.0% | 2.9% | -1.4% | 0.56 | 18 | |||||||||||||||||||
17 | SPDR Dow Jones Industrial Average ETF | DIA | 6.2% | 5.2% | 11.4% | 12.6% | 2.2% | 8.2% | 1.01 | 18 | 5.6% | up 1SD | 25% | $207.66 | 24 | $4,983.84 | $4,417.81 | -$693.82 | |||||||||||
18 | SPDR S&P MidCap 400 ETF | MDY | 8.3% | 3.1% | 11.4% | 13.6% | 1.3% | 15.3% | 1.02 | 21 | 8.5% | on trendline | 27% | $312.48 | 16 | $4,999.68 | $5,309.76 | $181.88 | |||||||||||
19 | Vanguard 500 Index Fund | VFINX | 4.7% | 5.2% | 9.9% | 14.0% | 1.8% | 9.2% | 1 | 25 | 5.8% | up 1SD | 30% | $218.68 | 23 | $5,029.64 | $4,486.68 | -$542.96 | |||||||||||
20 | Vanguard Balanced Index Fund | VBINX | 5.3% | 4.2% | 9.5% | 9.1% | 1.9% | 6.9% | 0.92 | 25 | |||||||||||||||||||
21 | Average | n = 6 | 6.4% | 4.6% | 11.0% | 11.9% | 1.7% | 6.4% | 0.89 | 21 | 7.2% | up 1SD | 26% | $226.96 | $5,020.79 | $4,766.57 | -$350.72 | ||||||||||||
22 | |||||||||||||||||||||||||||||
23 | Standard Indices (Px only) | ||||||||||||||||||||||||||||
24 | S&P MidCap 400 | ^MID | 7.1% | 1.8% | 8.9% | 12.2% | 8.5% | on trendline | 27% | ||||||||||||||||||||
25 | Dow Jones Industrial Average | ^DJI | 3.8% | 2.8% | 6.6% | 10.0% | 5.6% | up 1SD | 25% | ||||||||||||||||||||
26 | S&P 500 | ^GSPC | 2.7% | 3.1% | 5.8% | 11.8% | 5.8% | up 1SD | 30% | ||||||||||||||||||||
27 | Average | n = 3 | 4.5% | 2.6% | 7.1% | 11.3% | 6.6% | up 1SD | 27% | ||||||||||||||||||||
28 | |||||||||||||||||||||||||||||
29 | Consumer Price Index | cpi | 2.1% | 1.4% | |||||||||||||||||||||||||
30 | |||||||||||||||||||||||||||||
31 | Updated 5/6/2017 |