It’s time for the weekly review of positions in the HYHRD (High Yield High Return Dividend) portfolio.
The spreadsheet for each individual account are now found in the Google docs spreadsheet.
This post examines the spreadsheet for all positions sold in the accounts. The only screenshot from the MS Excel workbook that I will post has all the aggregate information (the tradelogs spreadsheet).
I will also post screenshots (see below) from the Thomas Dividend Manager program (link below in the weekly update) for each account in our portfolio.
Not currently tracked or reported is my wife’s TSA, except for quarterly updates on the 2016 Balances sheet.
“Smithers, release the hounds!”
- To date:
- ind-PandA (formerly brokerage-A) shows Total Net Profit of $4,869.31.
- Roth-A shows Total Net Profit of $6,755.30.
- IRA-A shows Total Net Loss of -$5,281.17.
- PandAjoint (formerly Computershare, formerly brokerage-P) shows Total Net Profit of $1,888.84.
- Roth IRA-P shows Total Net Gain of $2,867.35.
- IRA-P shows Total Net Loss of -$3,368.02.
- Overall, the HYHRD (High Yield High Return Dividend) portfolio shows a Total Net Loss of -$5,640.46.
- This figure has been adversely affected by the conversion of IRA assets to our Roth IRAs.
- Recent sale(s) of depressed holdings and subsequent purchase(s) of Preferred shares also resulted in temporary losses.
- The recent sale of PGH at an almost 500% REALIZED LOSS is also a factor, as is recent price (re)actions on other stocks.
- Recent sales of some preferred holdings and subsequent purchases/sales of regular shares resulted in some nice gains.
- Expected Dividends now shows $16,859.06 per year (from the Google sheets, for all holdings).
All figures are ‘since inception in 2012’ and dates vary from account to account.
Let’s see how the rest of it breaks down;
Here’s what the #HYHRD (High Yield High Return Dividend) portfolio tradelogs spreadsheet looks like today;
This spreadsheet shows;
- Total NET Profit / Loss and breaks it down for each account
- Total Dividends Received each year and breaks it down for each account
- Due to adustments in cost basis from converting IRA holdings to Roth IRA holdings, losses have now been REALIZED.
- Of course, any REALIZED losses also resulted in a lower cost basis in the Roth IRA account(s).
- Losses have also been realized from sales of underperforming stocks. Proceeds have been invested in preferred shares.
This data is further broken down on each separate sheet in this spreadsheet (but not shown to save time and space).
- May 28th Update
- I continue to use the new program called TDM (Thomas Dividend Manager) from www.dividendsoftware.com.
- Monthly withdrawals from settled cash in our accounts continue to augment our income.
- Withdrawals are subject to a minimum withdrawal amount of $10.00 (No withdrawals will be taken if under $10.00).
- Most holdings show major declines in equity. I will no longer reinvest dividends except in my IRA and 1 other stock.
- Capital One Investing (sharebuilder) Automatic Investment Plan invested $65 each in cxe, mav, & mhi on 5/24/16.
- Automatic investments will usually take place on the 2nd & 4th Tuesday of every month.
- Our portfolio stopped hemorrhaging equity momentarily, and the wound appeared to be healing nicely. We now have unrealized capital gain of 1.47%.
- When annual dividends are factored in, our unrealized capital gain is 1.49%.
- All of this is AFTER the REALIZED losses in our IRA accounts after the Roth conversions!
- All of this is AFTER the REALIZED losses in our accounts after sales of underperforming positions!
- Many dividends have been cut, some quite substantially, but dividends are still coming in. Economic rebound, my ass!
- No stocks will be DRIPped. Preferred shares can NOT be DRIPped (They are, after all, for income & not growth).
- On 2/22, STO 3 GSB Jun 17 2016 $5 Calls for $.15 with $7.20 commission for net proceeds of $37.80
- On 3/23, STO 2 AI OCT 21 2016 15.00 CALLs for $.25 with $6.45 commission for net proceeds of $43.55
- On 4/12, STO 3 CNSL Oct 21 2016 $25 Calls for $1.20 with $7.20 commission for net proceeds of $352.80
- On 4/12, STO 1 DRAD Sep 16 2016 $7.50 Call for $.05 with $4.99 commission for net proceeds of $0.01
- On 5/23, STO 5 BGCP Aug 19 2016 $10 Calls for $.10 with $8.70 commission for net proceeds of $41.30
Here’s a look at our balances from the 2016 Balances sheet (updated ~monthly, and usually a week or so late) WARNING: It is NOT pretty!;
And, here are the current screenshots of the accounts in our portfolio from the TDM program (also not pretty);
IRA-A (Since there are no positions and no further dividends expected, there are no further updates scheduled for this account at this time.)