| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked By Finance Value (Col E) | Ticker | Reward = Total Return/Yr since S&P 500 peak of 9/1/00 | Risk = Total Return/Yr during Housing Crisis of 4/07 to 10/11 | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Div Yield | 3-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 | Px (50d avg) | Shares BOT | Amount | PV of Expected Cash Flows | NPV | WACC | ROIC | expenses @ $100/mo | |
2 | Union Pacific | UNP | 17.9% | 13.0% | 30.9% | 17.0% | 2.2% | 15.3% | 1.04 | 22 | 17.5% | on trendline | 30% | 367 | 177 | $105.99 | 47 | $4,981.53 | $11,476.47 | $6,367.21 | 8.3% | 13.6% | $0.00 | |
3 | Nike | NKE | 17.0% | 12.9% | 29.9% | 18.2% | 1.3% | 14.6% | 0.43 | 25 | 17.4% | on trendline | 25% | 22 | 82 | $53.02 | 94 | $4,983.88 | $10,893.55 | $5,781.88 | 6.3% | 40.5% | $26.00 | |
4 | Costco Wholesale | COST | 11.9% | 11.1% | 22.8% | 19.6% | 1.0% | 9.0% | 0.87 | 32 | 13.9% | up 1SD | 29% | 134 | 258 | $163.99 | 30 | $4,919.70 | $7,890.08 | $2,844.23 | 7.1% | 13.9% | $26.00 | |
5 | International Business Machines | IBM | 3.6% | 16.5% | 20.1% | 1.3% | 3.1% | 13.8% | 0.88 | 15 | 7.7% | on trendline | 31% | 185 | 344 | $171.28 | 29 | $4,967.12 | $5,899.20 | $804.72 | 7.3% | 27.5% | $13.00 | |
6 | NextEra Energy | NEE | 13.7% | 0.2% | 13.9% | 19.8% | 2.8% | 9.7% | 0.24 | 20 | 14.3% | on trendline | 24% | 304 | 179 | $120.59 | 41 | $4,944.19 | $8,959.43 | $3,888.47 | 3.8% | 5.8% | $0.00 | |
7 | Johnson & Johnson | JNJ | 8.6% | 4.6% | 13.2% | 16.3% | 2.7% | 6.6% | 0.64 | 20 | 8.7% | up 1SD | 24% | 314 | 189 | $114.76 | 44 | $5,049.44 | $5,852.95 | $674.04 | 7.3% | 28.9% | $12.00 | |
8 | Vanguard Interm-Term Treasury | VFITX | 5.1% | 7.9% | 13.0% | 1.4% | 1.6% | -4.9% | 0 | NA | ||||||||||||||
9 | Vanguard Interm-Term Treasury | VFITX | 5.1% | 7.9% | 13.0% | 1.4% | 1.6% | -4.9% | 0 | NA | ||||||||||||||
10 | Vanguard Interm-Term Treasury | VFITX | 5.1% | 7.9% | 13.0% | 1.4% | 1.6% | -4.9% | 0 | NA | ||||||||||||||
11 | Vanguard Interm-Term Treasury | VFITX | 5.1% | 7.9% | 13.0% | 1.4% | 1.6% | -4.9% | 0 | NA | ||||||||||||||
12 | AT&T | T | 4.8% | -1.8% | 3.0% | 12.1% | 4.8% | 2.1% | 0.39 | 20 | 9.1% | up 1SD | 33% | 368 | 460 | $41.55 | 120 | $4,986.00 | $6,825.76 | $1,711.91 | 4.3% | 7.4% | $33.00 | |
13 | JP Morgan Chase | JPM | 6.0% | -8.1% | -2.3% | 21.9% | 2.1% | 8.1% | 1.15 | 15 | 9.3% | up 2SD | 32% | 142 | 414 | $86.20 | 58 | $4,999.60 | $5,898.87 | $771.08 | 5.9% | 11.7% | $25.00 | |
14 | Average | n = 12 | 8.7% | 6.7% | 15.3% | 11.0% | 2.2% | 5.0% | 0.47 | 21 | 12.2% | on trendline | 29% | 230 | 263 | $107.17 | $4,978.93 | $7,962.04 | $2,855.44 | 6.3% | 18.7% | $16.88 | ||
15 | ||||||||||||||||||||||||
16 | BENCHMARKS | |||||||||||||||||||||||
17 | iShares 7-10 Yr Treasury ETF | IEF | 5.0% | 9.3% | 14.3% | 2.0% | 1.8% | -3.2% | 0 | NA | ||||||||||||||
18 | Vanguard Wellesley Income | VWINX | 7.3% | 4.9% | 12.2% | 7.1% | 2.9% | -10.9% | 0.55 | 20 | ||||||||||||||
19 | Berkshire Hathaway | BRK-B | 9.1% | -0.3% | 8.8% | 16.2% | 0.0% | 0.0% | 0.79 | 18 | 8.8% | up 1SD | 23% | 187 | 248 | $163.91 | 31 | $5,081.21 | $4,841.39 | -$345.94 | 7.5% | 8.3% | ||
20 | SPDR S&P MidCap 400 ETF | MDY | 8.3% | -0.7% | 7.6% | 13.5% | 1.3% | 18.0% | 1.02 | 21 | 8.5% | up 1SD | 27% | $306.99 | 16 | $4,911.84 | $5,212.26 | $202.37 | NA | NA | ||||
21 | Vanguard Balanced Index Fund | VBINX | 5.3% | 1.5% | 6.8% | 9.0% | 1.9% | 9.4% | 0.9 | 26 | ||||||||||||||
22 | Vanguard 500 Index Fund | VFINX | 4.5% | -3.0% | 1.5% | 13.8% | 1.9% | 13.0% | 1 | 26 | 5.5% | up 1SD | 30% | $210.66 | 24 | $5,055.84 | $4,568.88 | -$456.24 | NA | NA | ||||
23 | Average | n = 6 | 6.6% | 2.0% | 8.5% | 10.3% | 1.6% | 4.4% | 0.71 | 22 | 7.6% | up 1SD | 27% | $227.19 | $5,016.30 | $4,874.18 | -$199.94 | 7.5% | 8.3% | |||||
24 | ||||||||||||||||||||||||
25 | Standard Retirement Plan (50% each) | |||||||||||||||||||||||
26 | Vanguard Interm-Term Treasury | VFITX | 5.1% | 7.9% | 13.0% | 1.4% | 1.6% | -4.9% | 0 | NA | ||||||||||||||
27 | Vanguard Total Stock Market | VTSMX | 5.0% | -2.6% | 2.4% | 13.6% | 1.8% | 12.5% | 1.02 | 19 | ||||||||||||||
28 | Average | n = 2 | 5.1% | 2.7% | 7.7% | 7.5% | 1.7% | 3.8% | 0.51 | 19 | ||||||||||||||
29 | ||||||||||||||||||||||||
30 | Standard Indices (Px only) | |||||||||||||||||||||||
31 | S&P MidCap 400 | ^MID | 7.2% | -1.9% | 5.3% | 12.1% | 8.5% | up 1SD | 27% | |||||||||||||||
32 | S&P 500 | ^GSPC | 2.6% | -5.0% | -2.4% | 11.6% | 5.5% | up 1SD | 30% | |||||||||||||||
33 | n = 2 | 4.9% | -3.5% | 1.5% | 11.9% | 7.0% | up 1SD | 29% | ||||||||||||||||
34 | ||||||||||||||||||||||||
35 | Consumer Price Index | cpi | 1.9% | 1.0% | ||||||||||||||||||||
36 | ||||||||||||||||||||||||
37 | Updated 2/18/2017 |