Need help creating your own Dividend Meter spreadsheet ...

Imported Current

a

Shares Symbol

Company Name

Value

Price Dividend Dividend Yield Annual Income

186 GIS General Mills, Inc.

$10,765.68 $57.88

$1.92

$1.92

3.32%

$357.12

222 MET Metlife Inc

$11,495.16 $51.78

347 PFE Pfizer Inc.

$11,707.78 $33.74

157 ETN Eaton Corporation, PLC Ordinary Shares $11,622.71 $74.03

120 WM Waste Management, Inc.

$8,740.80 $72.84

87 JNJ Johnson & Johnson

$10,602.69 $121.87

269 PPL PPL Corp

$10,168.20 $37.80

75 AAPL Apple Inc.

$10,683.00 $142.44

$1.60 $1.28 $2.40 $1.70 $3.20 $1.58 $2.28

$1.60 $1.28 $2.40 $1.70 $3.20 $1.58 $2.28

3.09% 3.79% 3.24% 2.33% 2.63% 4.18% 1.60%

$355.20

$444.16

$376.80

sp$r2e04a.0d0sheeSEt?LL

$278.40

$425.02

$171.00

SELL

Need help creating your own Dividend Meter

Buy the Dividend Meter Aristocrats Template and

make it your own:

686

F

Ford Motor Company

276 OHI Omega Healthcare Investors Inc

279 HCP HCP, Inc.

$7,868.42 $9,646.20 $9,073.08

$11.47 $34.95 $32.52

$0.60 $2.52 $1.48

$0.60 $2.52 $1.48

5.23% 7.21% 4.55%

$411.60 $695.52 $412.92

BUY

. com/member-sheet/

52 AMGN Amgen, Inc.

$8,426.08 $162.04

$4.60

$4.60

2.84%

$239.20

BUY

168 AWR American States Water Co

$7,561.68 $45.01

$0.97

$0.97

2.16%

$162.96

120 SBUX Starbucks Corporation

$7,209.60 $60.08

$0.90

$1.00

1.66%

$120.00

116 SIX Six Flags Entertainment Corp

$7,092.24 $61.14

$2.56

$2.56

4.19%

$296.96

190 OGE OGE Energy Corp.

$6,600.60 $34.74

$1.21

$1.21

3.48%

$229.90

61 DPS Dr Pepper Snapple Group Inc.

$5,983.49 $98.09

$2.32

$2.32

2.37%

$141.52

100 RDS.B Royal Dutch Shell plc (ADR)

$5,335.00 $53.35

$3.76

$3.76

7.05%

$376.00

74 AFL AFLAC Incorporated

$5,488.58 $74.17

$1.72

$1.72

2.32%

$127.28

99 QCOM QUALCOMM, Inc.

$5,213.34 $52.66

$2.28

$2.28

4.33%

$225.72

BUY

81 DFS Discover Financial Services

$5,401.89 $66.69

$1.20

$1.20

1.80%

$97.20

29 BA Boeing Co

$5,199.70 $179.30

$5.68

$5.68

3.17%

$164.72

100 VZ Verizon Communications Inc.

$4,841.00 $48.41

$2.31

$2.31

4.77%

$231.00

40 HSY Hershey Co

$4,352.00 $108.80

$2.47

$2.47

2.27%

$98.80

100 FAF First American Financial Corp

$3,931.00 $39.31

$1.36

$1.36

3.46%

$136.00

BUY

53 KSS Kohl's Corporation

$2,160.28 $40.76

$2.05

$2.20

5.40%

$116.60

BUY

20 ADP Automatic Data Processing

$2,060.80 $103.04

$2.28

$2.28

2.21%

$45.60

25 PII Polaris Industries Inc.

$2,033.50 $81.34

$2.32

$2.32

2.85%

$58.00

BUY

16 PEP PepsiCo, Inc.

$1,817.44 $113.59

$3.01

$3.01

2.65%

$48.16

20 AVY Avery Dennison Corp

$1,644.00 $82.20

$1.64

$1.64

2.00%

$32.80

SELL

30 DIN DineEquity Inc

$1,686.90 $56.23

$3.88

$3.88

6.90%

$116.40

200 GMRE Global Medical REIT Inc

$1,884.00 $9.42

$0.80

$0.80

8.49%

$160.00

147 SNR New Senior Investment Group Inc

$1,581.72 $10.76

$1.04

$1.04

9.67%

$152.88

Dividends $7,509.44

** Disclaimer: The Buy / Sell indicators in column J do not constitute recommendations to buy or sell securities.



Date 4/19/2017 4/12/2017 3/22/2017 3/21/2017 3/13/2017 3/7/2017 2/23/2017 2/22/2017 2/14/2017 2/14/2017 2/7/2017 1/23/2017 1/19/2017 1/5/2017 1/4/2017 12/23/2016 12/21/2016 12/20/2016 12/19/2016 12/15/2016 12/13/2016 12/12/2016 11/15/2016 11/14/2016 11/8/2016 11/8/2016 11/4/2016 11/3/2016 11/3/2016 11/3/2016 10/28/2016 10/27/2016 10/19/2016 10/18/2016

Total Annual Dividends $7,509.44 $7,498.40 $7,440.40 $7,423.00 $7,391.08 $7,274.68 $7,261.08 $7,250.48 $7,231.64 $7,197.84 $7,185.64 $7,169.50 $7,122.86 $7,111.82 $7,056.82 $7,008.06 $6,934.54 $6,903.34 $6,838.15 $6,779.75 $6,768.95 $6,741.19 $6,730.07 $6,650.07 $6,579.31 $6,576.11 $6,548.27 $6,777.05 $6,760.18 $6,736.18 $6,710.74 $6,704.82 $6,682.42 $6,659.24

Notes OHI dividend increase, raises meter reading $11.04 Added $2,000 to Roth IRA towards 2017 contribution, bought 25 PII, raises meter reading by $58.00 Bought 29 shares of F in IRA Rollover #2 with just over $300 in accumulated cash dividends, raises meter reading $17.40 With $800+ in accumulated cash dividends in IRA Rollover account #1, bought 14 shares of QCOM, raises meter reading $31.92 Added $1,500 to Roth IRA towards 2017 contribution, bought 30 DIN with new deposit and some accumulated cash dividends, raises meter reading by $116.40 QCOM dividend increase, raises meter reading $13.60 KSS dividend increase, raises meter reading $10.60 ETN dividend increase, raises meter reading $18.84 Sold 30 WM, bought 40 QCOM with proceeds and approx. $100 worth of accumulated cash dividends, raises meter reading by $33.80 DPS dividend increase, raises meter reading $12.20 PPL dividend increase, raises meter reading $16.14 Added $1,000 to Roth IRA for 2017 contribution, bought 22 QCOM with new deposit and some accumulated cash dividends, raises meter by $46.64 OHI dividend increase, raises meter reading $11.04 Sold 30 WM, bought 53 KSS with proceeds and a small amount of accumulated dividends, raises meter reading $55.00 Bought 23 QCOM with new $1500 savings, raises meter reading $48.76 Sold 40 AAPL, bought 29 BA, raises meter reading $73.52 AMGN dividend increase, raises meter reading $31.20 Sold 73 AWR, used proceeds and about $370 in accumulated dividends to buy 100 FAF, raises meter reading $65.19 Sold 58 DFS, used proceeds and $500+ in accumulated dividends to buy 32 AMGN, raises meter reading $58.40 WM dividend increase, raises meter reading $10.80 PFE dividend increase, raises meter reading $27.76 Fixed a dividend formula error on spreadsheet for DFS dividend, correct amount should be $1.20 (had $1.12), raises meter reading $11.12 Added new savings, bought 20 shares of AMGN in regular brokerage account, establishing a new position and raising meter reading $80.00 Sold 55 QCP (spinoff shares from HCP), used proceeds and a small amount of accumulated dividends to buy 29 shares of OHI, raises meter reading $70.76 ADP dividend increase, raises meter reading $3.20 SIX dividend increase, raises meter reading $27.84 HCP spins off QCP, cutting dividend to $1.48/share, keeping HCP, likely selling QCP soon due to "dividend cut", lowers meter reading $228.78 AWR dividend increase, raises meter reading $16.87 SBUX dividend increase, raises meter reading $24.00 Bought 12 shares DPS with new savings, raises meter reading $25.44 AFL dividend increase, raises meter reading $5.92 Bought 28 shares of SBUX in regular account with new savings, raises meter reading $22.40 Sold 10 shares of AAPL, bought 38 shares of OGE, raises meter reading $23.18 Bought 8 shares of ADP in regular brokerage acount with new savings, raises meter reading $16.96

10/18/2016 10/16/2016 9/30/2016 9/14/2016 9/14/2016

9/6/2016 9/6/2016 9/6/2016 9/1/2016 8/29/2016 8/19/2016 7/31/2016 7/18/2016 7/1/2016 6/30/2016 6/27/2016 6/27/2016 6/24/2016 6/6/2016 6/3/2016 5/27/2016 5/23/2016 5/16/2016 5/3/2016 5/1/2016 4/30/2016 4/30/2016 4/30/2016 4/25/2016 4/22/2016 4/17/2016 4/14/2016 3/29/2016 3/24/2016 3/21/2016

$6,642.28 $6,628.48 $6,618.60 $6,601.88 $6,441.88 $6,415.48 $6,410.48 $6,417.60 $6,377.86 $6,359.62 $6,303.12 $6,249.92 $6,244.32 $6,225.44 $6,186.17 $6,153.05 $6,171.29 $6,109.13 $6,109.13 $6,092.33 $6,071.53 $6,026.73 $6,023.53 $6,015.53 $5,983.53 $5,937.93 $5,955.33 $5,980.33 $5,923.73 $5,881.33 $5,751.09 $5,744.93 $5,719.49 $5,668.37 $5,661.17

Bought 23 shares F with accumulated dividends in IRA Rollover #2, raises meter reading $13.80 OHI dividend increase, raises meter reading $9.88 OGE dividend increase, raises meter reading $16.72 GMRE officially declares .20 quarterly dividend, raises meter reading by $160.00 Bought 11 shares of OHI with accumulated dividends in IRA Rollover #1, raises meter reading $26.40 VZ dividend increase, raises meter reading $5.00 Sold 400 DAKT in IRA Rollover#2, bought 200 GMRE and 147 SNR, lowers meter reading $7.20, but manually inputing zero for GMRE until official dividend declaration Sold 800 DAKT in regular account, bought 75 VZ and 82 SIX, raises meter reading $39.74 Bought 12 PPL with accumulated dividends in IRA Rollover #2, raises meter reading $18.24 Bought 25 VZ (new position) with a combination of new savings and accumulated dividends Sold 54 COP, bought 67 MET with proceeds and about $350 of accumulated dividends HSY dividend increase, raises meter reading $5.60 OHI dividend increase, raises meter reading $18.88 Sold 17 HSY, bought 34 SIX, raises meter reading $39.27 GIS dividend increase, raises meter reading $14.88 Sold 27 WM, bought 147 F, raises meter reading $43.92 Bought 8 shares ETN with new savings and some accumulated dividends, raises meter reading $18.24 Manually adjusted DAKT dividend to reflect regular + special dividend Bought 28 F with accumulated dividend in IRA Rollover #2, raises meter reading $16.80 Bought 13 MET with accumulated dividends in IRA Rollover #1, raises meter reading $20.80 Sold 35 COP, used proceeds and accumlated dividends to buy 133 F in Roth IRA, raises meter reading $44.80 PEP dividend increase, raises meter reading $3.20 Bought 10 SBUX with new savings, raises meter reading $8.00 Fixed manually-entered dividend for RDS/B (from $3.44 to $3.76, raises meter reading $32.00 AVY dividend increase, raises meter reading $3.20 MET dividend increase, raises meter reading $14.20 JNJ dividend increase, raises meter reading $17.40 AAPL dividend increase, raises meter reading $25.00 Bought 20 DPS with money ($1700.00) earned from cleaning out the garage, raises meter reading $42.40 Sold 60 COP, bought 82 OHI, raises meter reading $130.24 OHI dividend increase, raises meter reading $6.16 Bought 12 DPS with new $1000 savings, raises meter reading $25.44 Sold 100 CALM, bought 154 OHI Added $500.00 new savings to TradeKing account, bought 9 SBUX Sold 100 COP, bought 326 F, raises meter $95.60

3/12/2016 3/8/2016 3/3/2016 3/3/2016 2/29/2016 2/26/2016 2/25/2016 2/15/2016 2/8/2016 2/5/2016 2/4/2016 2/2/2016 2/1/2016 1/22/2016 1/14/2016 1/4/2016 12/18/2015 12/17/2015 12/9/2015 12/8/2015 12/2/2015 12/1/2015 11/13/2015 10/30/2015 10/27/2015 10/15/2015 9/11/2015 9/3/2015 9/1/2015 8/30/2015

$5,565.57 $5,550.69 $5,492.99 $5,513.69 $5,484.03 $5,472.11 $5,449.11 $5,436.39 $5,432.99 $5,430.42 $5,006.22 $5,884.67 $5,872.35 $5,869.19 $5,865.19 $5,852.47 $5,732.07 $5,690.27 $5,662.51 $5,526.91 $5,883.91 $5,840.97 $5,802.97 $5,756.37 $5,754.45 $5,740.45 $5,689.85 $5,649.85 $5,634.45 $5,618.85

GIS dividend increase, raises meter reading $14.88 Sold 100 GIS, bought 142 MET Bought 8 shares DFS with accumulated dividends in IRA Rollover#1 WM dividend increase, raises meter reading $20.70 ETN dividend increase, raises meter reading $11.92 Sold 32 COP in regular account (get tax write-off) and bought 50 OGE Bought 6 shares of ADP in TradeKing account with new $500 savings DPS dividend increase, raises meter reading $3.40 PPL dividend increase, raises meter reading $2.57 Sold 206 COP and 50 AAPL, bought 100 RDS/B, 100 CALM , and 82 OGE Sold 200 AWR, bought 257 PPL, COP cuts dividend 66% OUCH!!!, sold 200 COP, bought 200 HCP Bought 11 DFS with new savings in TradeKing account HCP dividend increase, raises meter reading $3.16 annually Added 5 shares of SBUX in new TradeKing account after earnings announcement dip Bought 6 shares of ADP in new TradeKing account Invested 2016 Roth IRA contribution - 50 AFL and 48 SBUX Bought 19 shares of ETN in regular account with KMI sales proceeds & fantasy football winnings PFE Dividend Increase (.08 per year) Bought 60 shares of HCP in IRA Rollover#1 (with KMI sales proceeds) Sold 175 shares of KMI (150 in IRA Rollover#1 and 25 in taxable account Bought 19 shares of HCP with accumulated dividends in IRA Rollover#1 Bought 20 shares of SBUX with new savings in taxable account, and 20 shares of OGE with accumulated dividends in IRA Rollover#2 Bought 20 shares of HSY with part of annual bonus AFL dividend increase from $1.56 to $1.64 KMI dividend increase from $1.96 to $2.04 Bought 23 shares ETN with new savings Bought 100 shares DAKT with new savings Bought 7 shares ETN (Reinvestment of dividends) Bought 10 shares AFL (Reinvestment of dividends) Created the Dividend Meter on 8/30/2015

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download