| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | 18.5 yr investment of $200/mo | 18.5 yr Total Return | Annualized Total Return | Current Annual Yield | Annual Yield/$44400 Investment | ||
2 | TICKER | ||||||
3 | 1 | WMT | 44,400 | 94,935.72 | 0.066 | 2,629.61 | 0.059 |
4 | 2 | JNJ | 44,400 | 108,665.25 | 0.076 | 3,824.59 | 0.086 |
5 | 3 | NEE | 44,400 | 109,571.06 | 0.077 | 4,363.02 | 0.098 |
6 | 4 | PG | 44,400 | 97,258.71 | 0.068 | 3,321.57 | 0.075 |
7 | 5 | KO | 44,400 | 85,850.67 | 0.059 | 2,373.16 | 0.053 |
8 | |||||||
9 | Mean (n = 5) | 44,400 | 133,901.43 | 0.069 | 3,551.68 | 0.074 | |
10 | |||||||
11 | SPY | 44,400 | 75,599.90 | 0.049 | 1,468.39 | 0.033 | |
12 | |||||||
13 | INFLATION | 0.025 | |||||
14 |