In many parts of the United States this time of year, people are blowing large sums of money on fireworks. I used to do that sort of thing. But this year, I resisted the impulsive fireworks stand drive-by purchase and used the savings to buy a favorite dividend stock instead, Eaton (ETN), on sale during the Brexit-induced stock market sell off. Here’s a summary of June’s dividend portfolio activity:
|6/3/2016||$6,092.33||Bought 13 MET with accumulated dividends in IRA Rollover #1, raises meter reading $20.80|
|6/6/2016||$6,109.13||Bought 28 F with accumulated dividend in IRA Rollover #2, raises meter reading $16.80|
|6/24/2016||$6,109.13||Manually adjusted DAKT dividend to reflect regular + special dividend|
|6/27/2016||$6,153.05||Sold 27 WM, bought 147 F, raises meter reading $43.92|
|6/27/2016||$6,171.29||Bought 8 shares ETN with new savings and some accumulated dividends, raises meter reading $18.24|
|6/30/2016||$6,186.17||GIS dividend increase, raises meter reading $14.88|
During June, I took advantage of the recent stock price increase in Waste Management (WM) to trim a few shares, using the proceeds to buy Ford (F) during the Brexit sell-off. After their most recent disappointing earnings report, I was concerned Daktronics (DAKT) wouldn’t be able to continue paying a 10 cent per share regular quarterly dividend. DAKT did in fact cut their regular dividend payout to 6 cents per share, which normally would result in liquidation of the position from my portfolio. However, in my opinion, DAKT made a couple of smart moves which are keeping me in the stock for now. First, the company approved a $40 million stock buyback, and second, they are paying a 4 cent special dividend this quarter, which combined with the 6 cent regular dividend, is keeping the total quarterly payout at 10 cents. For spreadsheet purposes, I’ve had to make a manually adjustment to DAKT’s dividend figure by replacing the import formula with a manual entry of a projected annual 40 cent dividend.
A reminder: you can access a live view of my investment spreadsheet by joining the Members Club. Already in July, I’ve broken the $6,200.00 barrier by selling a few shares of Hershey (HSY), taking advantage of the Mondelez buyout rumors, to add a new position to the portfolio: Six Flags (SIX).
Happy Fourth of July,
-The Meter Man
In May, the Dividend Meter broke through the $6k barrier, setting a new high of $6,071.53 in annual dividend income. Overall, portfolio activity was limited the past month – here’s a summary of what happened in May:
|5/1/2016||$5,983.53||AVY dividend increase, raises meter reading $3.20|
|5/3/2016||$6,015.53||Fixed manually-entered dividend for RDS/B (from $3.44 to $3.76, raises meter reading $32.00|
|5/16/2016||$6,023.53||Bought 10 SBUX with new savings, raises meter reading $8.00|
|5/23/2016||$6,026.73||PEP dividend increase, raises meter reading $3.20|
|5/27/2016||$6,071.53||Sold 35 COP, used proceeds and accumulated dividends to buy 133 F in Roth IRA, raises meter reading $44.80|
Hopefully, the $6k+ mark holds over the next few months. This week, DAKT (Daktronics), released another disappointing earnings report, raising the question of dividend sustainability. If DAKT can at least maintain the current dividend payout, while they work on restoring the company to profitability, I will continue to hold the stock.
Also, as indicated in May’s update, I’m now making available a view-only version of my actual spreadsheet available to registered Member’s Club users, instead of the PDF copy. This will make it easier to copy and paste formulas and you’ll be able to see the current status of the portfolio at any given moment rather than waiting for the month-end report.
Almost…. The Dividend Meter portfolio almost cracked the $6k mark in annual dividend income in April. After two oil crash-related dividend cuts in the previous few months, it’s exciting to see my investment spreadsheet reflect a new high for dividend income in such a short period of time after KMI and COP slashed their dividend payouts recently.
I just love how the spreadsheet helps identify buying opportunities. In April, I took advantage of a buying opportunity in DPS, Dr. Pepper Snapple, by making two purchases with new savings added to the portfolio. $1,700.00 of the new investment dollars came from finally cleaning out my garage this year (completing a 2016 New Year’s goal). Now, I can actually park a car in the garage, and it’s a great feeling to convert unused stuff into passive income by simply selling a few dusty video games and old building materials from a kitchen remodel on Craigslist. Less really does become more sometimes – what’s lurking in your garage or hiding in a closet that could be providing you growing passive income?
Also in April, as the price of oil moved higher, I continued to sell more shares of COP, increasing my position of OHI Omega Healthcare Investors Inc. with the proceeds. Several positions announced dividend increases in April: OHI, MET, JNJ, and AAPL. Here’s a complete summary of April’s activity, copied and pasted from the spreadsheet:
|4/14/2016||$5,744.93||Bought 12 DPS with new $1000 savings, raises meter reading $25.44|
|4/17/2016||$5,751.09||OHI dividend increase, raises meter reading $6.16|
|4/22/2016||$5,881.33||Sold 60 COP, bought 82 OHI, raises meter reading $130.24|
|4/25/2016||$5,923.73||Bought 20 DPS with money ($1700.00) earned from cleaning out the garage, raises meter reading $42.40|
|4/30/2016||$5,937.93||MET dividend increase, raises meter reading $14.20|
|4/30/2016||$5,955.33||JNJ dividend increase, raises meter reading $17.40|
|4/30/2016||$5,980.33||AAPL dividend increase, raises meter reading $25.00|
You can download a pdf copy of my updated dividend spreadsheet on the Member’s Club page. For those following along, please note that I’ve moved the complete history of notes to a new tab in the spreadsheet, as it’s getting quite lengthy. The complete history of notes will be available again soon after I make a few changes to the Member’s Club in May – changes that will enable registered users to also see a real-time View-only version of my actual Google Sheet, instead of just seeing a month-end pdf version.
I hope everyone has a great May – remember Mother’s Day is coming up soon!
My dividend spreadsheet is broken. Today is April Fool’s Day, but this is no joke. Myself and others have been experiencing problems this past week with the IMPORTDATA formula properly updating the annual dividend figure in the spreadsheet. Yesterday, changing the small case “d” to an upper case “D” in the following column G formula did improve performance for me:
I remember this same problem happening a few months ago, and performance cleared up on its own despite changing anything from lower to upper case. This appears to be a frustrating recurring reliability issue with Google Sheets. Another tip: add another tab to your spreadsheet to duplicate your Dividend Meter, and replace the IMPORTDATA formula in column G with the actual annual dividend amount. Unfortunately, this tab won’t automatically update with dividends raises or cuts, but everything else should update fine.
This is a good time to solicit any app developers out there who might want to partner with me to create a “Dividend Meter” app. How cool would be to have a Dividend Meter app that could instantly show a reliable meter reading, and provide buy and sell notifications based on your custom yield triggers? If you’re interested in helping with this endeavor visit the Contact page and drop me a line.
Anyway, let’s talk about happened in March to the Dividend Meter. Despite the poor spreadsheet performance, my Buy/Sell indicators worked fantastic this month for exposing three trade opportunities that contributed to raising the overall annual meter reading by $235.46. In March, one new position, OHI (Omega Healthcare Investors Inc.), was added to the spreadsheet and acquired. Here’s a summary of March’s activity:
|3/3/2016||$5,492.99||Bought 8 shares DFS with accumulated dividends in IRA Rollover#1|
|3/3/2016||$5,513.69||WM dividend increase, raises meter reading $20.70|
|3/8/2016||$5,550.69||Sold 100 GIS, bought 142 MET|
|3/12/2016||$5,565.57||GIS Dividend increase, raises meter reading $14.88|
|3/21/2016||$5,661.17||Sold 100 COP, bought 326 F, raises meter $95.60|
|3/24/2016||$5,668.37||Added $500.00 new savings to TradeKing account, bought 9 SBUX|
|3/29/2016||$5,719.49||Sold 100 CALM, bought 154 OHI|
To view a snapshot of the entire Dividend Meter spreadsheet at the end of March, visit the Member’s Club page.