| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | Company | Ticker | Yield | Growth of $900 ($100/qtr) | Total Return (%/yr) |
2 | Exxon Mobil | XOM | 2.40% | $1,055.58 | 15.0 |
3 | Wal*Mart | WMT | 2.50% | $1,012.93 | 11.0 |
4 | Procter & Gamble | PG | 3.30% | $967.48 | 6.8 |
5 | Johnson & Johnson | JNJ | 3.50% | $971.06 | 7.1 |
6 | IBM | IBM | 1.60% | $1,231.54 | 30.0 |
7 | Chevron | CVX | 3.10% | $1,157.21 | 24.0 |
8 | Coca-Cola | KO | 2.80% | $1,062.72 | 16.0 |
9 | McDonald's | MCD | 3.00% | $1,233.20 | 30.0 |
10 | United Technologies | UTX | 2.40% | $1,000.81 | 10.0 |
11 | 3M | MMM | 2.70% | $912.19 | 2.1 |
12 | Norfolk Southern | NSC | 2.30% | $1,208.83 | 28.0 |
13 | NextEra Energy | NEE | 4.00% | $983.56 | 8.4 |
14 | |||||
15 | Total (n = 12) | 2.80% | $12,797.11 | 16.0 | |
16 | |||||
17 | Vanguard 500 Index Admiral | VFIAX | 1.90% | $993.80 | 9.3 |
18 | Vanguard Wellesley | VWINX | 3.60% | $995.51 | 9.5 |
19 | Blackrock Global Allocation A | MDLOX | 1.70% | $938.90 | 4.0 |
20 | Vanguard Admiral Intermediate Treasury | VFIUX | 2.10% | $983.95 | 8.4 |
21 | |||||
22 | Consumer Price Index | -- | -- | -- | 2.7 |