| A | B | C | D | E | F | J | K | N | O | P | Q | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Click File > Make a copy: to get your own version of this spreadsheet | ||||||||||||
2 | Symbol | Total Shares | Current Price | Market Value | Initial Shares | Purchase Price | Total Return | % Return | Current Yield | Yield ON Cost | Portfolio Weighting | Estimated Annual Income | |
3 | T | 408.0696 | $23.28 | $9,499.86 | 369 | $13,147.36 | (3,669.40) | -27.74% | 8.76% | 5.73% | 0.84% | $832.46 | |
4 | VZ | 120 | $51.07 | $6,128.40 | 120 | $6,619.10 | (490.70) | -7.41% | 4.91% | 4.55% | 0.54% | $301.20 | |
5 | DUK | 40.85 | $101.21 | $4,134.43 | 33 | $1,843.00 | 2,278.48 | 124.33% | 3.83% | 6.95% | 0.36% | $158.50 | |
6 | KO | 113.641 | $54.91 | $6,240.03 | 110 | $4,677.65 | 1,553.43 | 33.40% | 2.99% | 3.86% | 0.55% | $186.37 | |
7 | GE | 14 | $96.01 | $1,344.14 | 14 | $2,566.00 | (1,230.81) | -47.62% | 0.04% | 0.02% | 0.12% | $0.56 | |
8 | CR | 11 | $101.08 | $1,111.88 | 11 | $547.84 | 564.04 | 102.96% | 1.70% | 3.45% | 0.10% | $18.92 | |
9 | DAL | 115 | $38.14 | $4,386.10 | 115 | $5,988.60 | (1,611.45) | -26.76% | 0.00% | 0.00% | 0.39% | $0.05 | |
10 | F | 354.7528 | $19.22 | $6,818.35 | 317 | $3,877.68 | 2,931.72 | 75.84% | 0.00% | 0.00% | 0.60% | $0.00 | |
11 | HOG | 20 | $37.68 | $753.60 | 20 | $704.80 | 48.80 | 6.92% | 0.21% | 0.23% | 0.07% | $1.60 | |
12 | GIS | 233.4052 | $64.44 | $15,040.63 | 212 | $10,300.95 | 4,730.73 | 46.01% | 3.04% | 4.03% | 1.33% | $457.47 | |
13 | CVX | 82.93 | $116.20 | $9,636.47 | 76 | $7,883.11 | 1,744.41 | 22.24% | 4.61% | 5.17% | 0.85% | $444.50 | |
14 | XOM | 158.3714 | $61.58 | $9,752.51 | 154 | $12,235.83 | (2,501.22) | -20.30% | 5.65% | 4.38% | 0.86% | $551.13 | |
15 | TTE | 112 | $49.13 | $5,502.56 | 108 | $5,388.77 | 113.79 | 2.11% | 6.11% | 6.01% | 0.49% | $336.00 | |
16 | BP | 52 | $27.33 | $1,421.16 | 52 | $2,010.12 | (588.96) | -29.30% | 4.68% | 3.31% | 0.13% | $66.56 | |
17 | SU | 20 | $24.37 | $487.40 | 20 | $556.00 | (68.60) | -12.34% | 2.54% | 2.23% | 0.04% | $12.40 | |
18 | DIS | 223.3728 | $150.37 | $33,588.57 | 220 | $22,871.10 | 10,717.47 | 46.86% | 0.00% | 0.00% | 2.96% | $0.04 | |
19 | CMCSA | 85 | $52.35 | $4,449.75 | 85 | $4,119.50 | 330.25 | 8.02% | 0.88% | 0.95% | 0.39% | $39.10 | |
20 | NYSE:BBL | 29.2354 | $55.04 | $1,609.12 | 26 | $1,216.51 | 392.61 | 32.27% | 5.45% | 6.41% | 0.14% | $87.71 | |
21 | MAR | 10 | $156.70 | $1,567.00 | 10 | $910.64 | 656.36 | 72.08% | 0.00% | 0.00% | 0.14% | $0.00 | |
22 | SBUX | 123 | $113.36 | $13,943.28 | 123 | $6,727.60 | 7,215.68 | 107.25% | 1.45% | 3.00% | 1.23% | $100.86 | |
23 | IP | 31 | $47.05 | $1,458.55 | 31 | $1,427.59 | 30.96 | 2.17% | 4.34% | 4.43% | 0.13% | $63.24 | |
24 | WRK | 16 | $45.48 | $727.68 | 16 | $498.88 | 228.80 | 45.86% | 1.76% | 2.57% | 0.06% | $12.80 | |
25 | IVZ | 50 | $22.77 | $1,138.50 | 50 | $1,100.57 | 37.93 | 3.45% | 2.99% | 3.09% | 0.10% | $34.00 | |
26 | STWD | 20 | $25.44 | $508.80 | 20 | $417.20 | 91.60 | 21.96% | 3.77% | 4.60% | 0.04% | $19.20 | |
27 | GEO | 82 | $7.60 | $623.20 | 80 | $1,143.80 | (520.60) | -45.51% | 13.16% | 6.99% | 0.05% | $82.00 | |
28 | OHI | 83.4454 | $28.61 | $2,387.37 | 67 | $2,384.25 | (5.83) | 0.13% | 9.37% | 7.53% | 0.21% | $223.63 | |
29 | WELL | 4 | $83.04 | $332.16 | 4 | $223.44 | 108.72 | 48.66% | 2.94% | 4.37% | 0.03% | $9.76 | |
30 | UHT | 10 | $59.45 | $594.50 | 10 | $658.60 | (64.10) | -9.73% | 4.64% | 4.19% | 0.05% | $27.60 | |
31 | O | 306.7136 | $68.08 | $20,881.06 | 303 | $15,920.83 | 4,960.23 | 31.16% | 4.23% | 5.48% | 1.84% | $883.34 | |
32 | MAIN | 55 | $44.03 | $2,421.65 | 55 | $1,860.10 | 561.55 | 30.19% | 5.72% | 7.45% | 0.21% | $138.60 | |
33 | STAG | 120 | $44.79 | $5,374.80 | 120 | $3,264.00 | 2,110.80 | 64.67% | 3.22% | 5.29% | 0.47% | $172.80 | |
34 | STOR | 102 | $33.90 | $3,457.80 | 100 | $2,695.50 | 762.30 | 28.28% | 4.25% | 5.34% | 0.31% | $146.88 | |
35 | PK | 100 | $17.87 | $1,787.00 | 100 | $2,298.75 | (511.75) | -22.26% | 0.00% | 0.00% | 0.16% | $0.00 | |
36 | SPG | 31 | $152.60 | $4,730.60 | 31 | $4,573.96 | 156.64 | 3.42% | 3.93% | 4.07% | 0.42% | $186.00 | |
37 | SRC | 40 | $45.97 | $1,838.80 | 40 | $1,755.72 | 83.08 | 4.73% | 5.48% | 5.74% | 0.16% | $100.80 | |
38 | AAPL | 148 | $165.32 | $24,467.36 | 148 | $5,537.12 | 18,930.24 | 341.88% | 0.53% | 2.35% | 2.16% | $130.24 | |
39 | CAT | 39.24 | $201.28 | $7,898.23 | 36 | $3,422.47 | 4,466.81 | 130.78% | 2.21% | 4.67% | 0.70% | $174.23 | |
40 | AOS | 58 | $82.00 | $4,756.00 | 58 | $2,867.93 | 390.25 | 65.83% | 1.17% | 1.94% | 0.42% | $55.68 | |
41 | CL | 20 | $78.58 | $1,571.60 | 20 | $1,272.84 | 298.76 | 23.47% | 2.24% | 2.77% | 0.14% | $35.20 | |
42 | CLX | 20 | $168.73 | $3,374.60 | 20 | $2,577.40 | 797.20 | 30.93% | 2.75% | 3.60% | 0.30% | $92.80 | |
43 | GWW | 20 | $499.95 | $9,999.00 | 20 | $3,762.32 | 6,236.68 | 165.77% | 1.30% | 3.44% | 0.88% | $129.60 | |
44 | PG | 61.6429 | $152.15 | $9,378.97 | 61 | $4,779.32 | 4,590.70 | 96.24% | 2.29% | 4.44% | 0.83% | $214.52 | |
45 | DD | 27 | $136.42 | $3,683.34 | 27 | $1,882.08 | 1,801.26 | 95.71% | 1.11% | 2.18% | 0.33% | $41.04 | |
46 | DOW | 49 | $53.88 | $2,640.12 | 49 | $2,581.96 | 58.16 | 2.25% | 5.20% | 5.31% | 0.23% | $137.20 | |
47 | BASFY | 43 | $16.86 | $724.98 | 43 | $969.90 | (244.92) | -25.25% | 5.46% | 4.08% | 0.06% | $158.24 | |
48 | EMN | 35 | $109.34 | $3,826.90 | 35 | $2,503.84 | 1,323.06 | 52.84% | 2.52% | 3.86% | 0.34% | $96.60 | |
49 | LYB | 25 | $88.92 | $2,223.00 | 25 | $2,165.25 | 57.75 | 2.67% | 5.08% | 5.22% | 0.20% | $113.00 | |
50 | KMB | 76 | $136.42 | $10,367.92 | 76 | $9,119.59 | 1,248.33 | 13.69% | 3.14% | 3.57% | 0.91% | $325.28 | |
51 | TRV | 34 | $151.82 | $5,161.88 | 34 | $3,889.76 | 1,272.12 | 32.70% | 2.16% | 2.87% | 0.46% | $111.52 | |
52 | PGR | 45 | $96.79 | $4,355.55 | 45 | $3,914.02 | 441.53 | 11.28% | 5.06% | 5.63% | 0.38% | $220.50 | |
53 | WMT | 47.4551 | $139.00 | $6,596.26 | 40 | $3,444.82 | 3,142.49 | 91.48% | 1.55% | 2.51% | 0.58% | $102.50 | |
54 | MSFT | 65.6649 | $326.19 | $21,419.23 | 64 | $2,855.60 | 18,554.68 | 650.08% | 0.69% | 5.02% | 1.89% | $147.09 | |
55 | UNP | 31.2844 | $246.06 | $7,697.84 | 31 | $2,940.69 | 4,757.15 | 161.77% | 1.74% | 4.51% | 0.68% | $133.90 | |
56 | CNI | 6 | $130.00 | $780.00 | 6 | $502.50 | 277.50 | 55.22% | 1.34% | 2.09% | 0.07% | $10.49 | |
57 | UNH | 13 | $460.11 | $5,981.43 | 13 | $2,555.65 | 3,425.78 | 134.05% | 1.26% | 2.95% | 0.53% | $75.40 | |
58 | CAH | 40 | $47.70 | $1,908.00 | 40 | $1,874.40 | 33.60 | 1.79% | 4.12% | 4.19% | 0.17% | $78.53 | |
59 | MDT | 36 | $110.24 | $3,968.64 | 36 | $3,987.66 | (19.02) | -0.48% | 2.29% | 2.28% | 0.35% | $90.72 | |
60 | BDX | 9 | $246.14 | $2,215.26 | 9 | $2,173.77 | 41.49 | 1.91% | 1.35% | 1.37% | 0.20% | $29.88 | |
61 | BA | 53 | $205.88 | $10,911.64 | 53 | $11,501.03 | (589.39) | -5.12% | 0.00% | 0.00% | 0.96% | $0.02 | |
62 | GD | 23 | $199.57 | $4,590.11 | 23 | $3,227.95 | 1,362.16 | 42.20% | 2.39% | 3.39% | 0.41% | $109.48 | |
63 | RTX | 37 | $83.76 | $3,099.12 | 37 | $2,225.95 | 873.17 | 39.23% | 2.44% | 3.39% | 0.27% | $75.48 | |
64 | PAYX | 30 | $121.93 | $3,657.90 | 30 | $1,739.10 | 1,918.80 | 110.33% | 2.17% | 4.55% | 0.32% | $79.20 | |
65 | JNJ | 129.4431 | $162.94 | $21,091.46 | 119 | $14,819.44 | 6,272.02 | 42.32% | 2.60% | 3.40% | 1.86% | $548.84 | |
66 | MMM | 144.2501 | $177.20 | $25,561.12 | 141 | $24,075.10 | 1,486.02 | 6.17% | 3.34% | 3.47% | 2.26% | $853.96 | |
67 | WFC | 60.4706 | $48.81 | $2,951.57 | 60 | $3,051.81 | (100.24) | -3.28% | 1.64% | 1.57% | 0.26% | $48.38 | |
68 | KEY | 143 | $23.06 | $3,297.58 | 142 | $2,061.52 | 1,236.06 | 59.96% | 3.30% | 5.23% | 0.29% | $108.68 | |
69 | BK | 103 | $55.43 | $5,709.29 | 103 | $4,460.46 | 1,248.83 | 28.00% | 2.45% | 3.14% | 0.50% | $140.08 | |
70 | JPM | 52 | $160.16 | $8,328.32 | 52 | $5,073.44 | 3,254.88 | 64.16% | 2.25% | 3.69% | 0.73% | $187.20 | |
71 | TD | 10 | $74.02 | $740.20 | 10 | $561.02 | 179.18 | 31.94% | 2.78% | 3.67% | 0.07% | $20.60 | |
72 | RY | 48 | $101.17 | $4,856.16 | 48 | $3,725.85 | 1,130.31 | 30.34% | 3.08% | 4.02% | 0.43% | $149.76 | |
73 | BNS | 10 | $66.42 | $664.20 | 10 | $518.60 | 145.60 | 28.08% | 4.02% | 5.14% | 0.06% | $26.68 | |
74 | BMO | 5 | $108.06 | $540.30 | 5 | $319.80 | 220.50 | 68.95% | 3.55% | 6.00% | 0.05% | $19.20 | |
75 | STT | 35 | $93.61 | $3,276.35 | 35 | $2,321.74 | 954.61 | 41.12% | 2.22% | 3.14% | 0.29% | $72.80 | |
76 | MS | 23 | $99.27 | $2,283.21 | 23 | $2,125.94 | 157.27 | 7.40% | 2.82% | 3.03% | 0.20% | $64.40 | |
77 | SYF | 105 | $46.34 | $4,865.70 | 105 | $3,025.80 | 1,839.90 | 60.81% | 1.81% | 2.91% | 0.43% | $88.20 | |
78 | SNV | 120 | $46.97 | $5,636.40 | 120 | $2,012.20 | 3,624.20 | 180.11% | 2.81% | 7.87% | 0.50% | $158.40 | |
79 | CMA | 42 | $83.76 | $3,517.92 | 42 | $2,631.06 | 886.86 | 33.71% | 3.25% | 4.34% | 0.31% | $114.24 | |
80 | FULT | 25 | $16.49 | $412.25 | 25 | $347.95 | 64.30 | 18.48% | 3.15% | 3.74% | 0.04% | $13.00 | |
81 | OZK | 67 | $45.73 | $3,063.91 | 67 | $2,044.42 | 1,019.49 | 49.87% | 2.54% | 3.80% | 0.27% | $77.72 | |
82 | C | 54 | $62.52 | $3,376.08 | 54 | $3,617.60 | (241.52) | -6.68% | 3.26% | 3.05% | 0.30% | $110.16 | |
83 | RF | 50 | $22.44 | $1,122.00 | 50 | $993.00 | 129.00 | 12.99% | 3.03% | 3.42% | 0.10% | $34.00 | |
84 | PNC | 4 | $199.96 | $799.84 | 4 | $574.84 | 225.00 | 39.14% | 2.50% | 3.48% | 0.07% | $20.00 | |
85 | SCHW | 155 | $80.37 | $12,457.35 | 155 | $6,238.32 | 6,219.03 | 99.69% | 0.85% | 1.69% | 1.10% | $105.40 | |
86 | PRU | 68 | $104.20 | $7,085.60 | 68 | $4,861.70 | 2,223.90 | 45.74% | 4.41% | 6.43% | 0.63% | $312.80 | |
87 | UNM | 199 | $23.64 | $4,704.36 | 195 | $3,614.60 | 1,089.76 | 30.15% | 5.08% | 6.47% | 0.42% | $238.80 | |
88 | AIG | 25 | $54.77 | $1,369.25 | 25 | $746.25 | 623.00 | 83.48% | 2.34% | 4.29% | 0.12% | $32.00 | |
89 | ORI | 156 | $24.36 | $3,800.16 | 150 | $2,933.75 | 866.41 | 29.53% | 3.61% | 4.50% | 0.34% | $137.28 | |
90 | AFL | 40 | $55.72 | $2,228.80 | 40 | $1,647.35 | 581.45 | 35.30% | 2.37% | 3.21% | 0.20% | $52.80 | |
91 | KMI | 10 | $15.78 | $157.80 | 10 | $304.50 | (146.70) | -48.18% | 6.84% | 3.55% | 0.01% | $10.80 | |
92 | ENB | 199 | $37.87 | $7,536.13 | 197 | $7,110.90 | 425.23 | 5.98% | 7.29% | 7.65% | 0.67% | $549.24 | |
93 | PEP | 42 | $166.42 | $6,989.64 | 42 | $4,678.09 | 2,311.55 | 49.41% | 2.45% | 3.66% | 0.62% | $171.36 | |
94 | UL | 70 | $52.62 | $3,683.40 | 70 | $3,641.14 | 42.26 | 1.16% | 3.65% | 3.69% | 0.33% | $134.40 | |
95 | CMI | 39 | $219.27 | $8,551.53 | 39 | $6,482.17 | 2,069.36 | 31.92% | 2.65% | 3.49% | 0.75% | $226.20 | |
96 | ITW | 32 | $239.27 | $7,656.64 | 32 | $5,411.72 | 2,244.92 | 41.48% | 1.91% | 2.70% | 0.68% | $145.92 | |
97 | SWK | 20 | $184.36 | $3,687.20 | 20 | $2,736.84 | 950.36 | 34.72% | 1.71% | 2.31% | 0.33% | $63.20 | |
98 | NKE | 150 | $168.91 | $25,336.50 | 150 | $8,873.31 | 16,463.19 | 185.54% | 0.65% | 1.86% | 2.24% | $165.00 | |
99 | WY | 22 | $38.46 | $846.12 | 22 | $594.96 | 251.16 | 42.21% | 3.54% | 5.03% | 0.07% | $29.92 | |
100 | TROW | 17 | $197.33 | $3,354.61 | 17 | $1,185.72 | 2,168.89 | 182.92% | 2.19% | 6.19% | 0.30% | $73.44 |