The spreadsheet contains more information including company Revenue, Net Income, EPS, and Dividend history. But it's a work in progress FYI
I've updated the portfolio calculations for 2017. Each holding is given an equal weight starting value of $10k. New buys and sells are only permitted at year end, so each calendar year starts fresh.
Below are the results for the first quarter of 2017, which represent the first quarter with the new calculation method.
| Equal Weight Performance With $10k Starting Balance | ||||||||
| Shares | 12/31/2016 | Beginning | 3/31/17 | Ending | %Gain | Dividends | Total Return | |
| BTI | 177.51 | 56.34 | $10,000.00 | $66.32 | $11,772.43 | 17.72% | $0.00 | 17.72% |
| BUD | 94.84 | 105.44 | $10,000.00 | $109.76 | $10,409.71 | 4.10% | $0.00 | 4.10% |
| CHD | 226.30 | 44.19 | $10,000.00 | $49.87 | $11,285.36 | 12.85% | $43.00 | 13.28% |
| CMI | 73.17 | 136.67 | $10,000.00 | $151.20 | $11,063.14 | 10.63% | $75.00 | 11.38% |
| COST | 62.46 | 160.11 | $10,000.00 | $167.69 | $10,473.42 | 4.73% | $28.11 | 5.02% |
| CTSH | 178.48 | 56.03 | $10,000.00 | $59.52 | $10,622.88 | 6.23% | $0.00 | 6.23% |
| DEO | 96.21 | 103.94 | $10,000.00 | $115.58 | $11,119.88 | 11.20% | $0.00 | 11.20% |
| EMR | 179.37 | 55.75 | $10,000.00 | $59.86 | $10,737.22 | 7.37% | $86.10 | 8.23% |
| FB | 86.92 | 115.05 | $10,000.00 | $142.05 | $12,346.81 | 23.47% | $0.00 | 23.47% |
| GPN | 144.07 | 69.41 | $10,000.00 | $80.68 | $11,623.69 | 16.24% | $1.44 | 16.25% |
| HAIN | 256.21 | 39.03 | $10,000.00 | $37.20 | $9,531.13 | -4.69% | $0.00 | -4.69% |
| HCP | 336.47 | 29.72 | $10,000.00 | $31.28 | $10,524.90 | 5.25% | $124.50 | 6.49% |
| HSY | 96.68 | 103.43 | $10,000.00 | $109.25 | $10,562.70 | 5.63% | $59.75 | 6.22% |
| IBB | 37.68 | 265.38 | $10,000.00 | $293.27 | $11,050.95 | 10.51% | $11.27 | 10.62% |
| IBM | 60.24 | 165.99 | $10,000.00 | $174.14 | $10,490.99 | 4.91% | $84.34 | 5.75% |
| MA | 97.05 | 103.04 | $10,000.00 | $112.25 | $10,893.83 | 8.94% | $21.35 | 9.15% |
| MKC | 107.15 | 93.33 | $10,000.00 | $97.09 | $10,402.87 | 4.03% | $50.36 | 4.53% |
| MO | 147.89 | 67.62 | $10,000.00 | $71.42 | $10,561.96 | 5.62% | $90.21 | 6.52% |
| PG | 118.93 | 84.08 | $10,000.00 | $89.85 | $10,686.25 | 6.86% | $79.63 | 7.66% |
| PM | 109.30 | 91.49 | $10,000.00 | $112.90 | $12,340.15 | 23.40% | $113.67 | 24.54% |
| PX | 85.33 | 117.19 | $10,000.00 | $118.60 | $10,120.32 | 1.20% | $67.20 | 1.88% |
| PYPL | 253.36 | 39.47 | $10,000.00 | $43.02 | $10,899.42 | 8.99% | $0.00 | 8.99% |
| RAI | 178.44 | 56.04 | $10,000.00 | $63.02 | $11,245.54 | 12.46% | $82.08 | 13.28% |
| SAM | 58.88 | 169.85 | $10,000.00 | $144.65 | $8,516.34 | -14.84% | $0.00 | -14.84% |
| UVV | 158.18 | 63.22 | $10,000.00 | $70.21 | $11,105.66 | 11.06% | $85.42 | 11.91% |
| V | 128.17 | 78.02 | $10,000.00 | $88.87 | $11,390.67 | 13.91% | $21.15 | 14.12% |
| VGR | 439.75 | 22.74 | $10,000.00 | $20.80 | $9,146.88 | -8.53% | $175.90 | -6.77% |
| WAB | 120.45 | 83.02 | $10,000.00 | $78.00 | $9,395.33 | -6.05% | $12.05 | -5.93% |
| WWAV | 179.86 | 55.60 | $10,000.00 | $56.15 | $10,098.92 | 0.99% | $0.00 | 0.99% |
| $290,000.00 | $310,419.34 | 7.04% | $1,312.51 | 7.49% | ||||
| Benchmark Comparison | ||||||||
| SPY | 44.74 | 223.53 | $10,000.00 | 235.74 | $10,546.24 | 5.46% | 59.46 | 6.06% |
No comments :
Post a Comment