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 | $19.95 | $8,140.99 | 369 | $11,134.51 | (3,015.42) | -26.89% | 5.56% | 3.68% | 0.63% | $452.96 | |
4 | VZ | 120 | $40.64 | $4,876.80 | 120 | $6,619.10 | (1,742.30) | -26.32% | 6.30% | 4.64% | 0.38% | $307.20 | |
5 | DUK | 40.85 | $101.58 | $4,149.54 | 33 | $1,843.00 | 2,293.59 | 125.15% | 3.82% | 6.95% | 0.32% | $158.50 | |
6 | KO | 113.641 | $60.49 | $6,874.14 | 110 | $4,677.65 | 2,187.54 | 46.96% | 2.91% | 4.14% | 0.53% | $200.01 | |
7 | GE | 14 | $83.23 | $1,165.22 | 14 | $2,566.00 | (1,409.73) | -54.59% | 0.38% | 0.17% | 0.09% | $4.48 | |
8 | CR | 11 | $113.38 | $1,247.18 | 11 | $547.84 | 699.34 | 127.65% | 1.66% | 3.77% | 0.10% | $20.68 | |
9 | DAL | 115 | $38.73 | $4,453.95 | 115 | $5,988.60 | (1,543.60) | -25.63% | 0.00% | 0.00% | 0.34% | $0.05 | |
10 | F | 357.7528 | $13.27 | $4,747.38 | 317 | $3,877.68 | 860.75 | 22.43% | 3.01% | 3.27% | 0.37% | $143.10 | |
11 | HOG | 20 | $45.17 | $903.40 | 20 | $704.80 | 198.60 | 28.18% | 1.39% | 1.79% | 0.07% | $12.60 | |
12 | GIS | 235.4052 | $77.89 | $18,335.71 | 212 | $10,300.95 | 8,025.81 | 78.00% | 2.52% | 4.03% | 1.42% | $461.39 | |
13 | CVX | 82.93 | $179.45 | $14,881.79 | 76 | $7,883.11 | 6,989.73 | 88.78% | 3.17% | 5.48% | 1.15% | $471.04 | |
14 | XOM | 159.3714 | $115.61 | $18,424.93 | 154 | $12,235.83 | 6,171.20 | 50.58% | 3.04% | 4.43% | 1.42% | $560.99 | |
15 | TTE | 115 | $63.25 | $7,273.75 | 108 | $5,388.77 | 1,884.98 | 34.98% | 4.74% | 6.01% | 0.56% | $345.00 | |
16 | BP | 52 | $36.32 | $1,888.64 | 52 | $2,010.12 | (121.48) | -6.04% | 3.52% | 3.31% | 0.15% | $66.56 | |
17 | SU | 20 | $34.62 | $692.40 | 20 | $556.00 | 136.40 | 24.53% | 1.79% | 2.23% | 0.05% | $12.40 | |
18 | DIS | 223.3728 | $109.54 | $24,468.26 | 220 | $22,871.10 | 1,597.16 | 6.98% | 0.00% | 0.00% | 1.89% | $0.04 | |
19 | WBD | 135 | $14.91 | $2,012.85 | 135 | $4,590.00 | (2,577.15) | -56.15% | 0.00% | 0.00% | 0.16% | $0.03 | |
20 | CMCSA | 182 | $39.60 | $7,207.20 | 182 | $7,869.39 | (662.19) | -8.41% | 1.36% | 1.25% | 0.56% | $98.28 | |
21 | BHP | 41 | $69.88 | $2,865.08 | 40 | $1,816.47 | 1,048.61 | 57.73% | 4.29% | 6.61% | 0.22% | $123.00 | |
22 | MAR | 10 | $174.33 | $1,743.30 | 10 | $910.64 | 832.66 | 91.44% | 0.00% | 0.00% | 0.13% | $0.00 | |
23 | SBUX | 124 | $109.02 | $13,518.48 | 123 | $6,727.60 | 6,790.88 | 100.94% | 1.80% | 3.58% | 1.05% | $121.52 | |
24 | IP | 31 | $38.11 | $1,181.41 | 31 | $1,427.59 | (246.18) | -17.24% | 5.35% | 4.43% | 0.09% | $63.24 | |
25 | WRK | 16 | $38.02 | $608.32 | 16 | $498.88 | 109.44 | 21.94% | 2.63% | 3.21% | 0.05% | $16.00 | |
26 | IVZ | 50 | $18.30 | $915.00 | 50 | $1,100.57 | (185.57) | -16.86% | 4.09% | 3.40% | 0.07% | $37.40 | |
27 | STWD | 20 | $20.69 | $413.80 | 20 | $417.20 | (3.40) | -0.81% | 4.64% | 4.60% | 0.03% | $19.20 | |
28 | GEO | 82 | $11.33 | $929.06 | 80 | $1,143.80 | (214.74) | -18.77% | 8.83% | 6.99% | 0.07% | $82.00 | |
29 | VICI | 35 | $34.14 | $1,194.90 | 35 | $975.10 | 219.80 | 22.54% | 4.22% | 5.17% | 0.09% | $50.40 | |
30 | OHI | 86.4454 | $29.06 | $2,512.10 | 67 | $2,384.25 | 118.90 | 5.36% | 9.22% | 7.53% | 0.19% | $231.67 | |
31 | WELL | 4 | $75.19 | $300.76 | 4 | $223.44 | 77.32 | 34.60% | 3.25% | 4.37% | 0.02% | $9.76 | |
32 | UHT | 10 | $54.15 | $541.50 | 10 | $658.60 | (117.10) | -17.78% | 5.24% | 4.31% | 0.04% | $28.40 | |
33 | O | 352.7136 | $68.30 | $24,090.34 | 349 | $18,830.79 | 5,259.55 | 27.93% | 4.34% | 5.49% | 1.86% | $1,045.44 | |
34 | MAIN | 55 | $39.58 | $2,176.90 | 55 | $1,860.10 | 316.80 | 17.03% | 6.67% | 7.81% | 0.17% | $145.20 | |
35 | STAG | 120 | $35.80 | $4,296.00 | 120 | $3,264.00 | 1,032.00 | 31.62% | 4.08% | 5.37% | 0.33% | $175.25 | |
36 | STOR | 124 | $32.20 | $3,992.80 | 120 | $3,290.50 | 702.30 | 21.34% | 4.47% | 5.25% | 0.31% | $178.56 | |
37 | PK | 100 | $14.43 | $1,443.00 | 100 | $2,298.75 | (855.75) | -37.23% | 0.00% | 0.00% | 0.11% | $0.00 | |
38 | SPG | 45 | $128.61 | $5,787.45 | 45 | $6,103.20 | (315.75) | -5.17% | 5.13% | 4.87% | 0.45% | $297.00 | |
39 | SRC | 40 | $42.89 | $1,715.60 | 40 | $1,755.72 | (40.12) | -2.29% | 5.88% | 5.74% | 0.13% | $100.80 | |
40 | AAPL | 148 | $145.93 | $21,597.64 | 148 | $5,537.12 | 16,060.52 | 290.05% | 0.63% | 2.46% | 1.67% | $136.16 | |
41 | CAT | 43.24 | $264.54 | $11,438.71 | 40 | $4,145.91 | 7,283.85 | 175.90% | 1.68% | 4.28% | 0.88% | $191.99 | |
42 | AOS | 71 | $60.36 | $4,285.56 | 71 | $3,700.71 | 390.25 | 15.80% | 1.86% | 2.15% | 0.33% | $79.52 | |
43 | CL | 20 | $71.59 | $1,431.80 | 20 | $1,272.84 | 158.96 | 12.49% | 2.63% | 2.95% | 0.11% | $37.60 | |
44 | CLX | 20 | $140.50 | $2,810.00 | 20 | $2,577.40 | 232.60 | 9.02% | 3.30% | 3.60% | 0.22% | $92.80 | |
45 | GWW | 20 | $571.79 | $11,435.80 | 20 | $3,762.32 | 7,673.48 | 203.96% | 1.20% | 3.66% | 0.88% | $137.60 | |
46 | PG | 63.6429 | $140.57 | $8,946.28 | 63 | $5,053.04 | 3,884.29 | 77.05% | 2.60% | 4.55% | 0.69% | $232.50 | |
47 | DD | 27 | $73.55 | $1,985.85 | 27 | $1,882.08 | 103.77 | 5.51% | 1.79% | 1.89% | 0.15% | $35.64 | |
48 | DOW | 69 | $58.97 | $4,068.93 | 69 | $3,719.16 | 349.77 | 9.40% | 4.75% | 5.19% | 0.31% | $193.20 | |
49 | BASFY | 43 | $14.35 | $617.05 | 43 | $969.90 | (352.85) | -36.38% | 6.41% | 4.08% | 0.05% | $158.24 | |
50 | EMN | 75 | $86.82 | $6,511.50 | 75 | $5,524.67 | 986.83 | 17.86% | 3.50% | 4.13% | 0.50% | $228.00 | |
51 | LYB | 55 | $95.55 | $5,255.25 | 55 | $4,417.85 | 837.40 | 18.95% | 4.98% | 5.93% | 0.41% | $261.80 | |
52 | KMB | 77 | $128.92 | $9,926.84 | 76 | $9,119.59 | 807.25 | 8.85% | 3.60% | 3.87% | 0.77% | $357.28 | |
53 | TRV | 34 | $188.76 | $6,417.84 | 34 | $3,889.76 | 2,528.08 | 64.99% | 1.97% | 3.25% | 0.50% | $126.48 | |
54 | PGR | 45 | $135.07 | $6,078.15 | 45 | $3,914.02 | 2,164.13 | 55.29% | 3.63% | 5.63% | 0.47% | $220.50 | |
55 | WMT | 47.4551 | $143.30 | $6,800.32 | 40 | $3,444.82 | 3,346.55 | 97.41% | 1.56% | 2.60% | 0.53% | $106.30 | |
56 | MSFT | 115.6649 | $248.16 | $28,703.40 | 114 | $16,486.42 | 12,208.03 | 74.10% | 1.00% | 1.71% | 2.22% | $286.85 | |
57 | ORCL | 30 | $88.99 | $2,669.70 | 30 | $2,253.60 | 416.10 | 18.46% | 1.44% | 1.70% | 0.21% | $38.40 | |
58 | UNP | 52.2844 | $202.39 | $10,581.84 | 52 | $7,168.45 | 3,413.39 | 47.62% | 2.57% | 3.77% | 0.82% | $271.88 | |
59 | CNI | 16 | $118.29 | $1,892.64 | 16 | $1,591.36 | 301.28 | 18.93% | 1.94% | 2.31% | 0.15% | $36.69 | |
60 | UNH | 13 | $486.05 | $6,318.65 | 13 | $2,555.65 | 3,763.00 | 147.24% | 1.36% | 3.36% | 0.49% | $85.80 | |
61 | SYK | 4 | $254.17 | $1,016.68 | 4 | $819.86 | 196.82 | 24.01% | 1.10% | 1.37% | 0.08% | $11.20 | |
62 | CAH | 60 | $76.48 | $4,588.80 | 60 | $2,892.00 | 1,696.80 | 58.67% | 2.57% | 4.07% | 0.35% | $117.79 | |
63 | MDT | 51 | $82.58 | $4,211.58 | 51 | $5,418.73 | (1,207.15) | -22.28% | 3.05% | 2.37% | 0.33% | $128.52 | |
64 | BDX | 9 | $251.82 | $2,266.38 | 9 | $2,173.77 | 92.61 | 4.26% | 1.38% | 1.44% | 0.18% | $31.32 | |
65 | BA | 53 | $211.17 | $11,192.01 | 53 | $11,501.03 | (309.02) | -2.69% | 0.00% | 0.00% | 0.87% | $0.02 | |
66 | GD | 23 | $227.49 | $5,232.27 | 23 | $3,227.95 | 2,004.32 | 62.09% | 2.22% | 3.59% | 0.40% | $115.92 | |
67 | RTX | 37 | $99.60 | $3,685.20 | 37 | $2,225.95 | 1,459.25 | 65.56% | 2.21% | 3.66% | 0.28% | $81.40 | |
68 | PAYX | 30 | $113.03 | $3,390.90 | 30 | $1,739.10 | 1,651.80 | 94.98% | 2.80% | 5.45% | 0.26% | $94.80 | |
69 | ADP | 10 | $220.80 | $2,208.00 | 10 | $2,028.60 | 179.40 | 8.84% | 1.88% | 2.05% | 0.17% | $41.60 | |
70 | JNJ | 129.4431 | $168.23 | $21,776.21 | 119 | $14,819.44 | 6,956.77 | 46.94% | 2.69% | 3.63% | 1.68% | $585.08 | |
71 | MMM | 157.2501 | $115.25 | $18,123.07 | 154 | $25,929.28 | (7,806.21) | -30.11% | 5.17% | 3.54% | 1.40% | $937.21 | |
72 | WFC | 60.4706 | $46.12 | $2,788.90 | 60 | $3,051.81 | (262.91) | -8.61% | 2.17% | 1.97% | 0.22% | $60.47 | |
73 | KEY | 143 | $18.99 | $2,715.57 | 142 | $2,061.52 | 654.05 | 31.73% | 4.11% | 5.37% | 0.21% | $111.54 | |
74 | BK | 103 | $50.06 | $5,156.18 | 103 | $4,460.46 | 695.72 | 15.60% | 2.72% | 3.14% | 0.40% | $140.08 | |
75 | JPM | 100 | $140.32 | $14,032.00 | 100 | $11,124.84 | 2,907.16 | 26.13% | 2.85% | 3.60% | 1.09% | $400.00 | |
76 | TD | 10 | $68.67 | $686.70 | 10 | $561.02 | 125.68 | 22.40% | 3.00% | 3.67% | 0.05% | $20.60 | |
77 | RY | 63 | $101.13 | $6,371.19 | 63 | $5,084.87 | 1,286.32 | 25.30% | 3.09% | 3.87% | 0.49% | $196.56 | |
78 | BNS | 10 | $53.31 | $533.10 | 10 | $518.60 | 14.50 | 2.80% | 5.00% | 5.14% | 0.04% | $26.68 | |
79 | BMO | 5 | $100.25 | $501.25 | 5 | $319.80 | 181.45 | 56.74% | 3.83% | 6.00% | 0.04% | $19.20 | |
80 | STT | 70 | $90.73 | $6,351.10 | 70 | $4,540.89 | 1,810.21 | 39.86% | 2.29% | 3.21% | 0.49% | $145.60 | |
81 | MS | 66 | $96.86 | $6,392.76 | 66 | $5,653.84 | 738.92 | 13.07% | 2.89% | 3.27% | 0.49% | $184.80 | |
82 | SYF | 105 | $37.06 | $3,891.30 | 105 | $3,025.80 | 865.50 | 28.60% | 2.27% | 2.91% | 0.30% | $88.20 | |
83 | SNV | 120 | $41.19 | $4,942.80 | 120 | $2,012.20 | 2,930.60 | 145.64% | 3.30% | 8.11% | 0.38% | $163.20 | |
84 | CMA | 42 | $72.57 | $3,047.94 | 42 | $3,208.53 | (160.59) | -5.01% | 3.75% | 3.56% | 0.24% | $114.24 | |
85 | BLK | 30 | $759.18 | $22,775.40 | 30 | $17,343.72 | 5,431.68 | 31.32% | 2.57% | 3.38% | 1.76% | $585.60 | |
86 | BX | 12 | $95.86 | $1,150.32 | 12 | $1,102.32 | 551.16 | 4.35% | 5.30% | 5.53% | 0.09% | $60.96 | |
87 | FULT | 25 | $16.18 | $404.50 | 25 | $347.95 | 56.55 | 16.25% | 3.71% | 4.31% | 0.03% | $15.00 | |
88 | SPGI | 7 | $373.39 | $2,613.73 | 7 | $2,218.02 | 395.71 | 17.84% | 1.26% | 1.49% | 0.20% | $33.04 | |
89 | OZK | 68 | $44.82 | $3,047.76 | 68 | $2,082.20 | 965.56 | 46.37% | 2.77% | 4.05% | 0.24% | $84.32 | |
90 | C | 84 | $51.86 | $4,356.24 | 84 | $5,188.78 | (832.54) | -16.05% | 3.93% | 3.30% | 0.34% | $171.36 | |
91 | BAC | 70 | $35.45 | $2,481.50 | 70 | $2,873.16 | (391.66) | -13.63% | 2.37% | 2.05% | 0.19% | $58.80 | |
92 | RF | 50 | $23.40 | $1,170.00 | 50 | $993.00 | 177.00 | 17.82% | 2.91% | 3.42% | 0.09% | $34.00 | |
93 | PNC | 4 | $163.17 | $652.68 | 4 | $574.84 | 77.84 | 13.54% | 3.68% | 4.18% | 0.05% | $24.00 | |
94 | FMNB | 150 | $13.46 | $2,019.00 | 150 | $2,634.50 | (615.50) | -23.36% | 4.75% | 3.64% | 0.16% | $96.00 | |
95 | USB | 35 | $48.86 | $1,710.10 | 35 | $2,015.10 | (305.00) | -15.14% | 3.77% | 3.20% | 0.13% | $64.40 | |
96 | SCHW | 155 | $74.69 | $11,576.95 | 155 | $6,238.32 | 5,338.63 | 85.58% | 0.91% | 1.69% | 0.90% | $105.40 | |
97 | PRU | 70 | $103.50 | $7,245.00 | 68 | $4,861.70 | 2,383.30 | 49.02% | 4.64% | 6.71% | 0.56% | $336.00 | |
98 | UNM | 201 | $41.56 | $8,353.56 | 195 | $3,614.60 | 4,738.96 | 131.11% | 2.89% | 6.47% | 0.65% | $241.20 | |
99 | AIG | 25 | $63.33 | $1,583.25 | 25 | $746.25 | 837.00 | 112.16% | 2.02% | 4.29% | 0.12% | $32.00 | |
100 | MFC | 100 | $19.65 | $1,965.00 | 100 | $1,955.00 | 10.00 | 0.51% | 5.28% | 5.30% | 0.15% | $103.68 |