Below is the updated dividend portfolio spreadsheet of my current holdings. This spreadsheet contains my entire dividend stock portfolio and excludes any mutual funds I’ve yet to sell.
All the fields are calculated in real-time so the total value and yields will change throughout the day. The columns with the blue headings are the only fields that require manual input. The rest of the portfolio spreadsheet will auto calculate with current information.
Feel free to make a copy of the spreadsheet from the link below to use and manipulate the dividend portfolio spreadsheet as you’d like. More narrative about the dividend stock portfolio can be found here.
Dividend Portfolio
Symbol | Total Shares | Current Price | Market Value | Initial Shares | Purchase Price | Return % | % Return | Sector | Quarterly Dividend | Current Yield | Yield ON Cost | Estimated Annual Income |
---|---|---|---|---|---|---|---|---|---|---|---|---|
T | 408.07 | 17.01 | 6,941.26 | 369 | 11,971.51 | -42.02 | -0.420 | Telecommunication Services | 0.28 | 0.065 | 0.034 | 452.96 |
VZ | 120.00 | 39.90 | 4,788.00 | 120 | 6,619.10 | -27.66 | -0.277 | Telecommunication Services | 0.64 | 0.064 | 0.046 | 307.20 |
DUK | 40.85 | 91.84 | 3,751.66 | 33 | 1,843.00 | 103.56 | 1.036 | Utilities | 0.97 | 0.042 | 0.069 | 158.50 |
KO | 113.64 | 59.96 | 6,813.91 | 110 | 4,677.65 | 45.67 | 0.457 | Consumer Staples | 0.44 | 0.029 | 0.041 | 200.01 |
GE | 14.00 | 156.24 | 2,187.36 | 14 | 2,566.00 | -14.76 | -0.148 | Industrials | 0.08 | 0.002 | 0.002 | 4.48 |
CR | 11.00 | 121.50 | 1,336.50 | 11 | 547.84 | 143.96 | 1.440 | Industrials | 0.47 | 0.015 | 0.038 | 20.68 |
DAL | 115.00 | 42.27 | 4,861.05 | 115 | 5,988.60 | -18.83 | -0.188 | Industrials | 0.00 | 0.000 | 0.000 | 0.05 |
F | 357.75 | 12.42 | 4,443.29 | 317 | 3,877.68 | 14.59 | 0.146 | Consumer Discretionary | 0.10 | 0.032 | 0.033 | 143.10 |
HOG | 20.00 | 36.38 | 727.60 | 20 | 704.80 | 3.23 | 0.032 | Consumer Discretionary | 0.16 | 0.017 | 0.018 | 12.60 |
GIS | 235.41 | 64.16 | 15,103.60 | 212 | 10,300.95 | 46.62 | 0.466 | Consumer Staples | 0.49 | 0.031 | 0.040 | 461.39 |
CVX | 82.93 | 152.42 | 12,640.19 | 76 | 7,883.11 | 60.35 | 0.603 | Energy | 1.42 | 0.037 | 0.055 | 471.04 |
XOM | 159.37 | 104.60 | 16,670.25 | 154 | 12,235.83 | 36.24 | 0.362 | Energy | 0.88 | 0.034 | 0.044 | 560.99 |
TTE | 115.00 | 63.84 | 7,341.60 | 108 | 5,388.77 | 36.24 | 0.362 | Energy | 0.75 | 0.047 | 0.060 | 345.00 |
BP | 52.00 | 35.00 | 1,820.00 | 52 | 2,010.12 | -9.46 | -0.095 | Energy | 0.32 | 0.037 | 0.033 | 66.56 |
SU | 20.00 | 34.42 | 688.40 | 20 | 556.00 | 23.81 | 0.238 | Energy | 0.16 | 0.018 | 0.022 | 12.40 |
DIS | 223.37 | 111.24 | 24,847.99 | 220 | 22,871.10 | 8.64 | 0.086 | Consumer Discretionary | 0.00 | 0.000 | 0.000 | 0.00 |
WBD | 135.00 | 8.71 | 1,175.85 | 135 | 4,590.00 | -74.38 | -0.744 | Consumer Discretionary | 0.00 | 0.000 | 0.000 | 0.00 |
CMCSA | 182.00 | 42.63 | 7,758.66 | 182 | 7,879.83 | -1.54 | -0.015 | Consumer Discretionary | 0.27 | 0.013 | 0.012 | 98.28 |
BHP | 41.00 | 57.32 | 2,350.12 | 40 | 1,816.47 | 29.38 | 0.294 | Industrials | 1.50 | 0.052 | 0.066 | 123.00 |
MAR | 10.00 | 249.48 | 2,494.80 | 10 | 910.64 | 173.96 | 1.740 | Consumer Discretionary | 0.00 | 0.000 | 0.000 | 0.00 |
SBUX | 124.00 | 94.30 | 11,693.20 | 123 | 6,727.60 | 73.81 | 0.738 | Consumer Discretionary | 0.49 | 0.021 | 0.036 | 121.52 |
IP | 31.00 | 35.57 | 1,102.67 | 31 | 1,427.59 | -22.76 | -0.228 | Consumer Discretionary | 0.51 | 0.057 | 0.044 | 63.24 |
WRK | 16.00 | 45.36 | 725.76 | 16 | 498.88 | 45.48 | 0.455 | Consumer Discretionary | 0.25 | 0.022 | 0.032 | 16.00 |
IVZ | 50.00 | 15.39 | 769.50 | 50 | 1,100.57 | -30.08 | -0.301 | Financials | 0.19 | 0.049 | 0.034 | 37.40 |
STWD | 20.00 | 20.35 | 407.00 | 20 | 417.20 | -2.44 | -0.024 | Financials | 0.48 | 0.047 | 0.046 | 19.20 |
GEO | 82.00 | 12.12 | 993.84 | 80 | 1,143.80 | -13.11 | -0.131 | Real Estate | 0.25 | 0.083 | 0.070 | 82.00 |
VICI | 35.00 | 30.04 | 1,051.40 | 35 | 975.10 | 7.82 | 0.078 | Real Estate | 0.36 | 0.048 | 0.052 | 50.40 |
OHI | 86.45 | 31.34 | 2,709.20 | 67 | 2,384.25 | 13.63 | 0.136 | Real Estate | 0.67 | 0.086 | 0.075 | 231.67 |
WELL | 4.00 | 92.93 | 371.72 | 4 | 223.44 | 66.36 | 0.664 | Real Estate | 0.61 | 0.026 | 0.044 | 9.76 |
UHT | 10.00 | 39.76 | 397.60 | 10 | 658.60 | -39.63 | -0.396 | Real Estate | 0.71 | 0.071 | 0.043 | 28.40 |
O | 352.71 | 52.15 | 18,394.01 | 349 | 18,830.79 | -2.32 | -0.023 | Real Estate | 0.25 | 0.057 | 0.055 | 1,045.44 |
MAIN | 55.00 | 45.62 | 2,509.10 | 55 | 1,860.10 | 34.89 | 0.349 | Financials | 0.22 | 0.058 | 0.078 | 145.20 |
STAG | 120.00 | 37.33 | 4,479.60 | 120 | 3,264.00 | 37.24 | 0.372 | Real Estate | 0.12 | 0.039 | 0.054 | 175.25 |
STOR | 124.00 | 0.00 | 0.00 | 120 | 3,290.50 | 0.00 | 0.000 | Real Estate | 0.36 | 0.000 | 0.053 | 178.56 |
PK | 100.00 | 16.61 | 1,661.00 | 100 | 2,298.75 | -27.74 | -0.277 | Real Estate | 0.00 | 0.000 | 0.000 | 0.00 |
SPG | 45.00 | 148.62 | 6,687.90 | 45 | 6,103.20 | 9.58 | 0.096 | Real Estate | 1.65 | 0.044 | 0.049 | 297.00 |
SRC | 40.00 | 0.98 | 39.20 | 40 | 1,755.72 | -97.77 | -0.978 | Real Estate | 0.63 | 2.571 | 0.057 | 100.80 |
AAPL | 148.00 | 180.45 | 26,706.60 | 148 | 5,537.12 | 382.32 | 3.823 | Information Technology | 0.23 | 0.005 | 0.025 | 136.16 |
CAT | 43.24 | 333.87 | 14,436.54 | 40 | 4,145.91 | 248.21 | 2.482 | Industrials | 1.11 | 0.013 | 0.043 | 191.99 |
AOS | 71.00 | 82.87 | 5,883.77 | 71 | 3,700.71 | 58.99 | 0.590 | Industrials | 0.28 | 0.014 | 0.021 | 79.52 |
CL | 20.00 | 86.71 | 1,734.20 | 20 | 1,272.84 | 36.25 | 0.362 | Consumer Staples | 0.47 | 0.022 | 0.030 | 37.60 |
CLX | 20.00 | 152.79 | 3,055.80 | 20 | 2,577.40 | 18.56 | 0.186 | Consumer Staples | 1.16 | 0.030 | 0.036 | 92.80 |
GWW | 20.00 | 978.08 | 19,561.60 | 20 | 3,762.32 | 419.93 | 4.199 | Industrials | 1.72 | 0.007 | 0.037 | 137.60 |
PG | 63.64 | 158.98 | 10,117.95 | 63 | 5,053.04 | 100.23 | 1.002 | Consumer Staples | 0.91 | 0.023 | 0.046 | 232.50 |
DD | 27.00 | 69.17 | 1,867.59 | 27 | 1,882.08 | -0.77 | -0.008 | Materials | 0.33 | 0.019 | 0.019 | 35.64 |
DOW | 69.00 | 55.83 | 3,852.27 | 69 | 3,719.16 | 3.58 | 0.036 | Materials | 0.70 | 0.050 | 0.052 | 193.20 |
BASFY | 43.00 | 12.79 | 549.97 | 43 | 969.90 | -43.30 | -0.433 | Materials | 0.92 | 0.072 | 0.041 | 158.24 |
EMN | 75.00 | 87.38 | 6,553.50 | 75 | 5,524.67 | 18.62 | 0.186 | Materials | 0.76 | 0.035 | 0.041 | 228.00 |
LYB | 55.00 | 99.97 | 5,498.35 | 55 | 4,417.85 | 24.46 | 0.245 | Materials | 1.19 | 0.048 | 0.059 | 261.80 |
KMB | 77.00 | 121.39 | 9,347.03 | 76 | 9,119.59 | 2.49 | 0.025 | Consumer Staples | 1.16 | 0.038 | 0.039 | 357.28 |
TRV | 34.00 | 220.31 | 7,490.54 | 34 | 3,889.76 | 92.57 | 0.926 | Financials | 0.93 | 0.017 | 0.033 | 126.48 |
PGR | 45.00 | 190.18 | 8,558.10 | 45 | 3,914.02 | 118.65 | 1.187 | Financials | 1.23 | 0.026 | 0.056 | 220.50 |
WMT | 47.46 | 58.83 | 2,791.78 | 40 | 3,444.82 | -18.96 | -0.190 | Consumer Staples | 0.56 | 0.038 | 0.026 | 106.30 |
MSFT | 115.66 | 410.00 | 47,422.61 | 114 | 16,486.52 | 187.64 | 1.876 | Information Technology | 0.62 | 0.006 | 0.017 | 286.85 |
ORCL | 30.00 | 111.18 | 3,335.40 | 30 | 2,253.60 | 48.00 | 0.480 | Information Technology | 0.32 | 0.012 | 0.017 | 38.40 |
UNP | 52.28 | 254.67 | 13,315.27 | 52 | 7,168.45 | 85.75 | 0.857 | Industrials | 1.30 | 0.020 | 0.038 | 271.88 |
CNI | 16.00 | 129.78 | 2,076.48 | 16 | 1,591.36 | 30.48 | 0.305 | Industrials | 0.57 | 0.018 | 0.023 | 36.69 |
UNH | 13.00 | 492.67 | 6,404.71 | 13 | 2,555.65 | 150.61 | 1.506 | Health Care | 1.65 | 0.013 | 0.034 | 85.80 |
CAH | 60.00 | 111.48 | 6,688.80 | 60 | 2,892.00 | 131.29 | 1.313 | Health Care | 0.49 | 0.018 | 0.041 | 117.79 |
SYK | 4.00 | 349.04 | 1,396.16 | 4 | 819.86 | 70.29 | 0.703 | Health Care | 0.70 | 0.008 | 0.014 | 11.20 |
MDT | 51.00 | 83.59 | 4,263.09 | 51 | 5,418.73 | -21.33 | -0.213 | Health Care | 0.63 | 0.030 | 0.024 | 128.52 |
BDX | 9.00 | 235.42 | 2,118.78 | 9 | 2,173.77 | -2.53 | -0.025 | Health Care | 0.87 | 0.015 | 0.014 | 31.32 |
BA | 53.00 | 203.30 | 10,774.90 | 53 | 11,501.03 | -6.31 | -0.063 | Industrials | 0.00 | 0.000 | 0.000 | 0.02 |
GD | 23.00 | 273.16 | 6,282.68 | 23 | 3,227.95 | 94.63 | 0.946 | Industrials | 1.26 | 0.018 | 0.036 | 115.92 |
RTX | 37.00 | 89.88 | 3,325.56 | 37 | 2,225.95 | 49.40 | 0.494 | Industrials | 0.55 | 0.024 | 0.037 | 81.40 |
PAYX | 30.00 | 122.64 | 3,679.20 | 30 | 1,739.10 | 111.56 | 1.116 | Information Technology | 0.79 | 0.026 | 0.055 | 94.80 |
ADP | 10.00 | 250.93 | 2,509.30 | 10 | 2,028.60 | 23.70 | 0.237 | Information Technology | 1.04 | 0.017 | 0.021 | 41.60 |
JNJ | 129.44 | 161.72 | 20,933.54 | 119 | 14,819.44 | 41.26 | 0.413 | Health Care | 1.13 | 0.028 | 0.036 | 585.08 |
MMM | 157.25 | 92.10 | 14,482.73 | 154 | 25,929.28 | -44.15 | -0.441 | Industrials | 1.49 | 0.065 | 0.035 | 937.21 |
WFC | 60.47 | 55.51 | 3,356.72 | 60 | 3,051.81 | 9.99 | 0.100 | Financials | 0.25 | 0.018 | 0.020 | 60.47 |
KEY | 143.00 | 14.26 | 2,039.18 | 142 | 2,061.52 | -1.08 | -0.011 | Financials | 0.20 | 0.055 | 0.054 | 111.54 |
BK | 103.00 | 55.97 | 5,764.91 | 103 | 4,460.46 | 29.24 | 0.292 | Financials | 0.34 | 0.024 | 0.031 | 140.08 |
JPM | 100.00 | 185.05 | 18,505.00 | 100 | 11,125.64 | 66.33 | 0.663 | Financials | 1.00 | 0.022 | 0.036 | 400.00 |
TD | 10.00 | 59.70 | 597.00 | 10 | 561.02 | 6.41 | 0.064 | Financials | 0.52 | 0.035 | 0.037 | 20.60 |
RY | 63.00 | 96.56 | 6,083.28 | 63 | 5,084.87 | 19.63 | 0.196 | Financials | 0.78 | 0.032 | 0.039 | 196.56 |
BNS | 10.00 | 48.39 | 483.90 | 10 | 518.60 | -6.69 | -0.067 | Financials | 0.67 | 0.055 | 0.051 | 26.68 |
BMO | 5.00 | 90.25 | 451.25 | 5 | 319.80 | 41.10 | 0.411 | Financials | 0.96 | 0.043 | 0.060 | 19.20 |
STT | 70.00 | 73.71 | 5,159.70 | 70 | 4,540.89 | 13.63 | 0.136 | Financials | 0.52 | 0.028 | 0.032 | 145.60 |
MS | 66.00 | 86.00 | 5,676.00 | 66 | 5,653.84 | 0.39 | 0.004 | Financials | 0.70 | 0.033 | 0.033 | 184.80 |
SYF | 105.00 | 41.25 | 4,331.25 | 105 | 3,025.80 | 43.14 | 0.431 | Financials | 0.21 | 0.020 | 0.029 | 88.20 |
SNV | 120.00 | 37.76 | 4,531.20 | 120 | 2,012.20 | 125.19 | 1.252 | Financials | 0.34 | 0.036 | 0.081 | 163.20 |
CMA | 42.00 | 49.40 | 2,074.80 | 42 | 2,631.06 | -21.14 | -0.211 | Financials | 0.68 | 0.055 | 0.043 | 114.24 |
BLK | 30.00 | 809.29 | 24,278.70 | 30 | 17,343.72 | 39.99 | 0.400 | Financials | 4.88 | 0.024 | 0.034 | 585.60 |
BX | 12.00 | 127.40 | 1,528.80 | 12 | 1,102.32 | 38.69 | 0.387 | Financials | 1.27 | 0.040 | 0.055 | 60.96 |
FULT | 25.00 | 15.32 | 383.00 | 25 | 347.95 | 10.07 | 0.101 | Financials | 0.15 | 0.039 | 0.043 | 15.00 |
SPGI | 7.00 | 430.59 | 3,014.13 | 7 | 2,218.02 | 35.89 | 0.359 | Financials | 1.18 | 0.011 | 0.015 | 33.04 |
OZK | 68.00 | 43.68 | 2,970.24 | 68 | 2,082.20 | 42.65 | 0.426 | Financials | 0.31 | 0.028 | 0.040 | 84.32 |
C | 84.00 | 55.45 | 4,657.80 | 84 | 5,288.50 | -11.93 | -0.119 | Financials | 0.51 | 0.037 | 0.032 | 171.36 |
BAC | 70.00 | 34.46 | 2,412.20 | 70 | 2,773.44 | -13.02 | -0.130 | Financials | 0.21 | 0.024 | 0.021 | 58.80 |
RF | 50.00 | 18.63 | 931.50 | 50 | 993.00 | -6.19 | -0.062 | Financials | 0.17 | 0.037 | 0.034 | 34.00 |
PNC | 4.00 | 147.40 | 589.60 | 4 | 574.84 | 2.57 | 0.026 | Financials | 1.50 | 0.041 | 0.042 | 24.00 |
FMNB | 150.00 | 13.47 | 2,020.50 | 150 | 2,634.50 | -23.31 | -0.233 | Financials | 0.16 | 0.048 | 0.036 | 96.00 |
USB | 35.00 | 41.88 | 1,465.80 | 35 | 2,015.10 | -27.26 | -0.273 | Financials | 0.46 | 0.044 | 0.032 | 64.40 |
SCHW | 155.00 | 66.61 | 10,324.55 | 155 | 6,185.32 | 66.92 | 0.669 | Financials | 0.17 | 0.010 | 0.017 | 105.40 |
PRU | 70.00 | 108.63 | 7,604.10 | 68 | 4,861.70 | 56.41 | 0.564 | Financials | 1.20 | 0.044 | 0.067 | 336.00 |
UNM | 201.00 | 49.44 | 9,937.44 | 195 | 3,614.60 | 174.93 | 1.749 | Financials | 0.30 | 0.024 | 0.065 | 241.20 |
AIG | 25.00 | 72.75 | 1,818.75 | 25 | 746.25 | 143.72 | 1.437 | Financials | 0.32 | 0.018 | 0.043 | 32.00 |
MFC | 100.00 | 23.75 | 2,375.00 | 100 | 1,955.00 | 21.48 | 0.215 | Financials | 0.26 | 0.044 | 0.053 | 103.68 |
MCY | 30.00 | 48.57 | 1,457.10 | 30 | 1,585.80 | -8.12 | -0.081 | Financials | 0.64 | 0.052 | 0.048 | 76.20 |
ORI | 166.00 | 28.93 | 4,802.38 | 150 | 2,933.75 | 63.69 | 0.637 | Financials | 0.23 | 0.032 | 0.047 | 152.72 |
AFL | 89.00 | 80.40 | 7,155.60 | 89 | 4,454.67 | 60.63 | 0.606 | Financials | 0.40 | 0.020 | 0.032 | 142.40 |
KMI | 10.00 | 17.44 | 174.40 | 10 | 304.50 | -42.73 | -0.427 | Energy | 0.28 | 0.064 | 0.037 | 11.20 |
ENB | 223.00 | 34.58 | 7,711.34 | 217 | 7,850.90 | -1.78 | -0.018 | Energy | 0.69 | 0.080 | 0.076 | 615.48 |
PEP | 43.00 | 165.42 | 7,113.06 | 43 | 4,842.74 | 46.88 | 0.469 | Consumer Staples | 1.15 | 0.028 | 0.041 | 197.80 |
UL | 82.00 | 49.03 | 4,020.46 | 82 | 4,218.22 | -4.69 | -0.047 | Consumer Staples | 0.48 | 0.039 | 0.037 | 157.44 |
CMI | 43.00 | 269.06 | 11,569.58 | 43 | 7,288.61 | 58.74 | 0.587 | Industrials | 1.45 | 0.022 | 0.034 | 249.40 |
ITW | 32.00 | 261.96 | 8,382.72 | 32 | 5,411.72 | 54.90 | 0.549 | Industrials | 1.14 | 0.017 | 0.027 | 145.92 |
SWK | 37.00 | 88.74 | 3,283.38 | 37 | 4,979.37 | -34.06 | -0.341 | Industrials | 0.79 | 0.036 | 0.023 | 116.92 |
NKE | 162.00 | 104.10 | 16,864.20 | 162 | 10,144.63 | 66.24 | 0.662 | Consumer Discretionary | 0.31 | 0.012 | 0.019 | 197.64 |
WY | 22.00 | 34.51 | 759.22 | 22 | 594.96 | 27.61 | 0.276 | Real Estate | 0.18 | 0.021 | 0.027 | 15.84 |
TROW | 34.00 | 112.94 | 3,839.96 | 34 | 3,341.12 | 14.93 | 0.149 | Financials | 1.20 | 0.043 | 0.049 | 163.20 |
FAST | 142.00 | 73.27 | 10,404.34 | 141 | 2,935.20 | 254.47 | 2.545 | Industrials | 0.31 | 0.017 | 0.060 | 176.08 |
SNA | 8.00 | 275.29 | 2,202.32 | 8 | 1,646.88 | 33.73 | 0.337 | Industrials | 1.42 | 0.021 | 0.028 | 45.44 |
COST | 48.00 | 749.84 | 35,992.32 | 48 | 10,039.43 | 258.51 | 2.585 | Consumer Staples | 0.90 | 0.005 | 0.017 | 172.80 |
TJX | 10.00 | 98.64 | 986.40 | 10 | 388.60 | 153.83 | 1.538 | Consumer Staples | 0.26 | 0.011 | 0.027 | 10.40 |
TSCO | 15.00 | 255.42 | 3,831.30 | 15 | 999.60 | 283.28 | 2.833 | Consumer Discretionary | 0.92 | 0.014 | 0.055 | 55.20 |
SJM | 15.00 | 120.72 | 1,810.80 | 15 | 1,659.30 | 9.13 | 0.091 | Consumer Staples | 0.99 | 0.033 | 0.036 | 59.40 |
TSN | 32.00 | 54.15 | 1,732.80 | 32 | 1,874.92 | -7.58 | -0.076 | Consumer Staples | 0.46 | 0.034 | 0.031 | 58.88 |
ADM | 30.00 | 53.14 | 1,594.20 | 30 | 1,371.70 | 16.22 | 0.162 | Consumer Staples | 0.40 | 0.030 | 0.035 | 48.00 |
TGT | 57.00 | 152.50 | 8,692.50 | 57 | 3,369.82 | 157.95 | 1.580 | Consumer Discretionary | 0.90 | 0.024 | 0.061 | 205.20 |
EMR | 28.00 | 107.30 | 3,004.40 | 28 | 1,616.44 | 85.87 | 0.859 | Industrials | 0.52 | 0.019 | 0.036 | 57.68 |
HON | 27.00 | 199.53 | 5,387.31 | 27 | 3,155.42 | 70.73 | 0.707 | Industrials | 0.98 | 0.020 | 0.034 | 105.84 |
JCI | 80.00 | 59.50 | 4,760.00 | 80 | 3,268.80 | 45.62 | 0.456 | Industrials | 0.34 | 0.023 | 0.033 | 108.80 |
ROK | 10.00 | 284.70 | 2,847.00 | 10 | 2,448.60 | 16.27 | 0.163 | Industrials | 1.12 | 0.016 | 0.018 | 44.80 |
WM | 25.00 | 206.10 | 5,152.50 | 25 | 3,123.15 | 64.98 | 0.650 | Industrials | 0.65 | 0.013 | 0.021 | 65.00 |
RHHBY | 100.00 | 32.75 | 3,275.00 | 98 | 3,065.31 | 6.84 | 0.068 | Health Care | 1.14 | 0.035 | 0.036 | 114.00 |
NSRGY | 10.00 | 103.98 | 1,039.80 | 10 | 788.90 | 31.80 | 0.318 | Consumer Staples | 2.52 | 0.024 | 0.032 | 25.20 |
BRDCY | 25.00 | 21.40 | 535.00 | 25 | 472.25 | 13.29 | 0.133 | Consumer Staples | 0.36 | 0.034 | 0.019 | 8.97 |
DEO | 15.00 | 151.13 | 2,266.95 | 15 | 1,987.05 | 14.09 | 0.141 | Consumer Staples | 1.41 | 0.037 | 0.043 | 84.78 |
BTI | 144.00 | 29.82 | 4,294.08 | 144 | 6,105.46 | -29.67 | -0.297 | Consumer Staples | 0.71 | 0.095 | 0.067 | 408.96 |
VOD | 25.00 | 8.95 | 223.75 | 25 | 611.75 | -63.42 | -0.634 | Telecommunication Services | 1.82 | 0.203 | 0.074 | 182.00 |
SO | 115.00 | 67.52 | 7,764.80 | 100 | 4,686.75 | 65.68 | 0.657 | Utilities | 0.68 | 0.040 | 0.058 | 312.80 |
NEE | 41.00 | 55.73 | 2,284.93 | 41 | 3,014.07 | -24.19 | -0.242 | Utilities | 0.43 | 0.031 | 0.023 | 69.70 |
FE | 135.00 | 36.77 | 4,963.95 | 135 | 3,803.95 | 30.49 | 0.305 | Utilities | 0.39 | 0.042 | 0.055 | 210.60 |
CWCO | 50.00 | 29.45 | 1,472.50 | 50 | 693.40 | 112.36 | 1.124 | Utilities | 0.09 | 0.012 | 0.025 | 17.00 |
AWR | 15.00 | 71.93 | 1,078.95 | 15 | 1,235.25 | -12.65 | -0.127 | Utilities | 0.40 | 0.022 | 0.019 | 24.00 |
AQN | 100.00 | 5.81 | 581.00 | 100 | 1,540.00 | -62.27 | -0.623 | Utilities | 0.17 | 0.117 | 0.044 | 68.24 |
LOW | 166.00 | 241.00 | 40,006.00 | 165 | 14,869.52 | 169.05 | 1.690 | Consumer Discretionary | 0.80 | 0.013 | 0.036 | 531.20 |
HD | 132.00 | 380.97 | 50,288.04 | 132 | 23,280.69 | 116.01 | 1.160 | Consumer Discretionary | 1.90 | 0.020 | 0.043 | 1,003.20 |
INTC | 170.00 | 42.82 | 7,279.40 | 170 | 7,013.21 | 3.80 | 0.038 | Information Technology | 0.37 | 0.034 | 0.035 | 248.20 |
AVGO | 45.00 | 1,304.02 | 58,680.90 | 45 | 16,353.27 | 258.83 | 2.588 | Information Technology | 4.10 | 0.013 | 0.045 | 738.00 |
TSM | 32.00 | 129.08 | 4,130.56 | 32 | 3,604.07 | 14.61 | 0.146 | Information Technology | 0.45 | 0.014 | 0.016 | 57.14 |
MA | 43.00 | 474.30 | 20,394.90 | 43 | 12,816.46 | 59.13 | 0.591 | Information Technology | 0.49 | 0.004 | 0.007 | 84.28 |
BEN | 66.00 | 27.43 | 1,810.38 | 65 | 2,474.00 | -26.82 | -0.268 | Financials | 0.29 | 0.042 | 0.030 | 76.56 |
PSA | 16.00 | 285.58 | 4,569.28 | 16 | 3,097.26 | 47.53 | 0.475 | Real Estate | 2.00 | 0.028 | 0.041 | 128.00 |
PSX | 57.00 | 142.29 | 8,110.53 | 55 | 4,214.60 | 92.44 | 0.924 | Energy | 0.97 | 0.027 | 0.051 | 221.16 |
VVV | 40.00 | 42.69 | 1,707.60 | 40 | 827.58 | 106.34 | 1.063 | Materials | 0.13 | 0.012 | 0.024 | 20.00 |
APD | 16.00 | 234.19 | 3,747.04 | 16 | 4,100.37 | -8.62 | -0.086 | Materials | 1.62 | 0.028 | 0.025 | 103.68 |
NTR | 13.00 | 52.38 | 680.94 | 13 | 659.50 | 3.25 | 0.033 | Industrials | 0.45 | 0.034 | 0.035 | 23.40 |
SCCO | 20.00 | 80.72 | 1,614.40 | 20 | 1,280.00 | 26.13 | 0.261 | Industrials | 1.00 | 0.050 | 0.063 | 80.00 |
GPC | 122.00 | 149.08 | 18,187.76 | 119 | 10,141.64 | 79.34 | 0.793 | Consumer Discretionary | 0.90 | 0.024 | 0.042 | 439.20 |
SHW | 28.00 | 331.13 | 9,271.64 | 28 | 6,695.87 | 38.47 | 0.385 | Consumer Discretionary | 0.60 | 0.007 | 0.010 | 67.20 |
GT | 55.00 | 11.87 | 652.85 | 55 | 1,020.25 | -36.01 | -0.360 | Consumer Discretionary | 0.00 | 0.000 | 0.000 | 0.00 |
V | 149.00 | 283.32 | 42,214.68 | 149 | 23,217.68 | 81.82 | 0.818 | Information Technology | 0.38 | 0.005 | 0.010 | 223.50 |
KHC | 27.00 | 35.17 | 949.59 | 27 | 1,602.00 | -40.72 | -0.407 | Consumer Staples | 0.40 | 0.045 | 0.027 | 43.20 |
UPS | 37.00 | 148.32 | 5,487.84 | 37 | 3,709.73 | 47.93 | 0.479 | Industrials | 1.52 | 0.041 | 0.061 | 224.96 |
FDX | 10.00 | 247.68 | 2,476.80 | 10 | 1,692.18 | 46.37 | 0.464 | Industrials | 0.75 | 0.012 | 0.018 | 30.00 |
AXP | 55.00 | 219.22 | 12,057.10 | 55 | 4,693.93 | 156.87 | 1.569 | Financials | 0.52 | 0.009 | 0.024 | 114.40 |
VFC | 21.31 | 16.20 | 345.22 | 20 | 1,015.80 | -66.01 | -0.660 | Consumer Discretionary | 0.50 | 0.123 | 0.039 | 42.62 |
PFE | 305.00 | 26.79 | 8,170.95 | 285 | 9,410.52 | -13.17 | -0.132 | Health Care | 0.40 | 0.060 | 0.048 | 488.00 |
VTRS | 315.00 | 12.20 | 3,843.00 | 288 | 3,545.00 | 8.41 | 0.084 | Health Care | 0.11 | 0.036 | 0.036 | 138.60 |
ABBV | 45.00 | 176.58 | 7,946.10 | 45 | 3,820.45 | 107.99 | 1.080 | Health Care | 1.41 | 0.032 | 0.066 | 253.80 |
MRK | 60.00 | 127.62 | 7,657.20 | 60 | 4,419.30 | 73.27 | 0.733 | Health Care | 0.65 | 0.020 | 0.035 | 156.00 |
MCK | 10.00 | 520.14 | 5,201.40 | 10 | 1,515.55 | 243.20 | 2.432 | Health Care | 0.42 | 0.003 | 0.011 | 16.80 |
GILD | 35.00 | 72.47 | 2,536.45 | 35 | 2,272.85 | 11.60 | 0.116 | Health Care | 0.73 | 0.040 | 0.045 | 102.20 |
BMY | 50.00 | 50.82 | 2,541.00 | 50 | 2,918.70 | -12.94 | -0.129 | Health Care | 0.49 | 0.039 | 0.034 | 98.00 |
AMGN | 10.00 | 276.76 | 2,767.60 | 10 | 2,248.60 | 23.08 | 0.231 | Health Care | 1.94 | 0.028 | 0.035 | 77.60 |
IRM | 212.00 | 79.09 | 16,767.08 | 177 | 6,018.46 | 178.59 | 1.786 | Real Estate | 0.62 | 0.031 | 0.073 | 525.76 |
HRL | 115.00 | 34.92 | 4,015.80 | 115 | 4,082.75 | -1.64 | -0.016 | Consumer Staples | 0.26 | 0.030 | 0.029 | 119.60 |
K | 57.00 | 55.39 | 3,157.23 | 57 | 3,628.26 | -12.98 | -0.130 | Consumer Staples | 0.57 | 0.041 | 0.036 | 129.96 |
TAP | 48.00 | 62.65 | 3,007.20 | 48 | 2,744.06 | 9.59 | 0.096 | Consumer Staples | 0.38 | 0.024 | 0.027 | 72.96 |
STZ | 18.00 | 247.48 | 4,454.64 | 18 | 3,394.52 | 31.23 | 0.312 | Consumer Staples | 0.80 | 0.013 | 0.017 | 57.60 |
BUD | 15.00 | 60.45 | 906.75 | 15 | 1,515.92 | -40.18 | -0.402 | Consumer Staples | 0.60 | 0.010 | 0.006 | 9.02 |
MDLZ | 90.00 | 73.21 | 6,588.90 | 90 | 4,428.45 | 48.79 | 0.488 | Consumer Staples | 0.32 | 0.017 | 0.026 | 115.20 |
CAG | 140.00 | 27.98 | 3,917.20 | 140 | 4,638.92 | -15.56 | -0.156 | Consumer Staples | 0.31 | 0.044 | 0.037 | 173.60 |
DE | 11.00 | 364.02 | 4,004.22 | 11 | 1,284.96 | 211.62 | 2.116 | Industrials | 1.05 | 0.012 | 0.036 | 46.20 |
D | 75.00 | 47.96 | 3,597.00 | 75 | 5,580.90 | -35.55 | -0.355 | Utilities | 0.67 | 0.056 | 0.036 | 200.25 |
DLR | 41.00 | 146.26 | 5,996.66 | 41 | 4,808.90 | 24.70 | 0.247 | Real Estate | 1.22 | 0.033 | 0.042 | 200.08 |
NNN | 102.00 | 40.96 | 4,177.92 | 87 | 3,725.98 | 12.13 | 0.121 | Real Estate | 0.53 | 0.052 | 0.050 | 216.24 |
KIM | 28.16 | 19.70 | 554.75 | 28 | 563.00 | -1.47 | -0.015 | Real Estate | 0.19 | 0.039 | 0.038 | 21.40 |
LMT | 33.00 | 429.06 | 14,158.98 | 33 | 10,711.84 | 32.18 | 0.322 | Industrials | 2.80 | 0.026 | 0.035 | 369.60 |
NOC | 10.00 | 459.51 | 4,595.10 | 10 | 2,901.22 | 58.39 | 0.584 | Industrials | 1.73 | 0.015 | 0.024 | 69.20 |
HSY | 22.00 | 187.37 | 4,122.14 | 22 | 2,050.59 | 101.02 | 1.010 | Consumer Staples | 0.90 | 0.019 | 0.039 | 79.20 |
VTR | 30.00 | 42.22 | 1,266.60 | 30 | 1,563.60 | -18.99 | -0.190 | Real Estate | 0.45 | 0.043 | 0.035 | 54.00 |
CVS | 194.23 | 73.97 | 14,367.28 | 183 | 13,296.66 | 8.05 | 0.081 | Consumer Staples | 0.55 | 0.030 | 0.030 | 427.31 |
WBA | 50.00 | 21.14 | 1,057.00 | 50 | 3,576.95 | -70.45 | -0.704 | Consumer Staples | 0.48 | 0.091 | 0.027 | 96.00 |
WPC | 30.00 | 56.52 | 1,695.60 | 30 | 2,001.30 | -15.28 | -0.153 | Real Estate | 1.06 | 0.075 | 0.064 | 127.20 |
CCI | 16.00 | 110.81 | 1,772.96 | 16 | 2,035.76 | -12.91 | -0.129 | Real Estate | 1.47 | 0.053 | 0.046 | 94.08 |
AMT | 20.00 | 200.64 | 4,012.80 | 20 | 4,436.10 | -9.54 | -0.095 | Real Estate | 1.47 | 0.029 | 0.027 | 117.60 |
QCOM | 54.00 | 157.88 | 8,525.52 | 54 | 3,089.58 | 175.94 | 1.759 | Information Technology | 0.75 | 0.019 | 0.052 | 162.00 |
TXN | 56.00 | 166.97 | 9,350.32 | 56 | 6,920.55 | 35.11 | 0.351 | Information Technology | 1.15 | 0.028 | 0.037 | 257.60 |
CSCO | 175.00 | 48.35 | 8,461.25 | 171 | 6,816.71 | 24.13 | 0.241 | Information Technology | 0.38 | 0.031 | 0.038 | 266.00 |
IBM | 66.00 | 185.10 | 12,216.60 | 65 | 9,698.20 | 25.97 | 0.260 | Information Technology | 1.65 | 0.036 | 0.044 | 435.60 |
PGX | 45.71 | 11.84 | 541.21 | 35 | 508.90 | 6.35 | 0.063 | Other | 0.07 | 0.070 | 0.057 | 37.85 |
AFINP | 10.00 | 25.29 | 252.90 | 10 | 256.00 | -1.21 | -0.012 | Other | 0.47 | 0.074 | 0.073 | 18.80 |
CBRL | 10.00 | 65.72 | 657.20 | 10 | 1,588.00 | -58.61 | -0.586 | Consumer Discretionary | 2.30 | 0.035 | 0.014 | 23.00 |
MCD | 32.07 | 292.13 | 9,369.11 | 31 | 3,131.48 | 199.19 | 1.992 | Consumer Discretionary | 1.38 | 0.019 | 0.055 | 177.04 |
PM | 63.70 | 90.04 | 5,735.98 | 63 | 6,528.40 | -12.14 | -0.121 | Consumer Staples | 1.20 | 0.053 | 0.046 | 305.78 |
DFS | 113.00 | 121.89 | 13,773.57 | 105 | 6,812.72 | 102.17 | 1.022 | Financials | 0.60 | 0.020 | 0.037 | 271.20 |
KR | 226.00 | 49.37 | 11,157.62 | 215 | 5,459.10 | 104.39 | 1.044 | Consumer Staples | 0.21 | 0.017 | 0.033 | 189.84 |
QQQ | 46.00 | 438.75 | 20,182.50 | 46 | 8,124.23 | 148.42 | 1.484 | ETF | 1.41 | 0.003 | 0.008 | 64.86 |
QYLD | 133.00 | 17.85 | 2,374.05 | 132 | 2,804.90 | -15.36 | -0.154 | ETF | 0.23 | 0.153 | 0.129 | 364.37 |
SCHD | 390.00 | 77.75 | 30,322.50 | 375 | 18,429.84 | 64.53 | 0.645 | ETF | 1.44 | 0.019 | 0.029 | 561.60 |
SWPPX | 125.00 | 77.87 | 9,733.75 | 125 | 2,711.25 | 259.01 | 2.590 | ETF | 0.79 | 0.010 | 0.036 | 98.75 |
JEPI | 191.00 | 57.05 | 10,896.55 | 191 | 10,499.00 | 3.79 | 0.038 | ETF | 0.35 | 0.073 | 0.076 | 793.03 |
JEPQ | 115.00 | 53.29 | 6,128.35 | 115 | 4,872.70 | 25.77 | 0.258 | ETF | 0.40 | 0.090 | 0.113 | 552.00 |
NUSI | 76.00 | 23.29 | 1,770.04 | 76 | 2,099.15 | -15.68 | -0.157 | ETF | 0.19 | 0.096 | 0.081 | 170.54 |
Symbol | Total Shares | Current Price | Market Value | Initial Shares | Purchase Price | % Return | Sector | Quarterly Dividend | Current Yield | Yield ON Cost | Estimated Annual Income | |
∑ = 1,395,398.18 | ∑ = 925,468.92 | ∑ = 34,101.85 |
Here is a link to the Dividend Portfolio Spreadsheet
The dividend portfolio spreadsheet auto calculates the stock price, dividend yield, dividend yield on cost, total position value, total return, portfolio weight and estimated annual dividend income.
All you have to do is enter your ticker symbol, shares owned and purchase price and it will do everything else for you. You can make a copy of my dividend portfolio spreadsheet by clicking the link above that takes you to the google sheet. Then go to File, Make a copy… to save an editable copy for your own dividend stocks. Have fun!