It’s time for the weekly review of positions in the HYHRD (High Yield High Return Dividend) portfolio.
The spreadsheet for each individual account, along with the monthly balances and yearly dividends are now found in the tradelogs workbook.
This post will examine those spreadsheets for all positions held in the accounts (i.e.; positions not held will not appear on the spreadsheets). The only screenshot from that workbook that I will post has all the aggregate information, and that’s 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 2015 Balances sheet.
“Smithers, release the hounds!”
- To date:
- ind-PandA (formerly brokerage-A) shows Total Net Profit of $8,290.88.
- Roth-A shows Total Net Profit of $8,636.30.
- IRA-A shows Total Net Profit of $20,580.29.
- Computershare (formerly brokerage-P) shows Total Net Profit of $1,895.79.
- Roth IRA-P shows Total Net Profit of $2,897.51.
- IRA-P shows Total Net Profit of $20,550.98.
- Overall, the HYHRD (High Yield High Return Dividend) portfolio shows a Total Net Profit of $49,167.32.
- Expected Dividends shows $25,447.89 per year.
All figures are ‘since inception in 2012’ and dates vary from account to account.
Let’s see how 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
- 2014 Total Dividends Received and breaks it down for each account
- a wealth of other information, such as Percentage Gain / Loss and Return On Investment for each account, etc.
- changed the Return on Investment metric to now subtract trade fees
- a NEW metric, Return on Investment with dividends added (and trade fees subtracted)
- I have found a few errors and mistakes with some of the formulas and have made some corrections to the trade logs.
- Let me know if you see any errors. You have to download the spreadsheet to check the formulas, I think.
- You probably should not compare the 2/24/13 spreadsheet figures with prior weeks. (They won’t ‘jive’.)
- I do believe the figures are now backward-compatible starting with the 2/24/13 figures on a go-forward basis.
- With the transfer of accounts to fidelity I will now use the Fidelity history for accounting figures.
- On 1/31, I found and corrected errors calculating the total NET profit/loss, and the result is sobering.
- It seems I was not accounting for previous HUGE losses from auto-trading options, and added dividends twice.
- As I’ve said, the results of these corrections were quite sobering, but at least I’m still showing a NET profit.
- On 3/28/15 I found and corrected another error in computing the ROI% on the tradelogs spreadsheet.
- On 5/15/15 I decided to eliminate ETF/ETN screening, as I was not utilizing the results.
- On 5/25/15 I changed the screening procedure and later that week the procedure for looking at charts.
- For the week ending 5/30/15, our total net profit since inception exceeded $40,000.00 for the first time.
- For the week ending 7/4/15, our total net profit since inception exceeded $41,000.00 for the first time.
- This was before I discovered the error that was NOT including the trade fees, which are quite hefty.
- AI has reclassified all 2014 dividends as a return of capital, which requires adjustments to cost basis.
- Joy of joys, this also means an amended tax return is in my future. Oh, what fresh hell is this?
- Cost basis adjustment has just been completed for our joint taxable account, dividends and trade logs updated.
- This also affected the Computershare account because it was formerly tracked as an individual brokerage account.
- Cost basis adjustment has just been started for my Roth account, dividends and trade logs to be updated.
- Cost basis adjustment for our other accounts is in queue.
- The first weekly purchase of shares in the Capital One Investing (sharebuilder) account took place on 7/7/15.
- On 8/27, I found and corrected an error that was NOT including the trade fees, which are quite hefty.
- For the week ending 9/5/15, our total net profit since inception exceeded $41,000.00 for the first (second) time.
- PGH has suspended their DRIP & OCP plans. Computershare no longer shows any info for this company.
- All shares of PGH were moved to Capital One Investing (sharebuilder), so the dividends would be reinvested.
- These shares will sit and reinvest what little dividends there are until I either sell ALL shares, or die.
- For the week ending 10/24/15, our total net profit since inception exceeded $44,000.00 for the first time.
- For the week ending 10/31/15, our total net profit since inception exceeded $47,000.00 for the first time.
- For the week ending 11/14/15, our total net profit since inception exceeded $48,000.00 for the first time.
- On 11/20, 2015 dividends received exceeded the 2014 total dividends received, with almost 6 weeks to go yet!
- For the week ending 12/5/15, our total net profit since inception exceeded $49,000.00 for the first time.
This data is further broken down on each separate sheet in this spreadsheet (but not shown to save time and space).
- December 19th Update
- I continue to use the new program called TDM (Thomas Dividend Manager) from www.dividendsoftware.com.
- Monthly partial withdrawals from settled cash in our accounts continue to augment our income.
- I have added some calculations on the Expected Dividends page that show tax info for the current year, up until the first RMD.
- The point of this being, of course, to avoid paying unnecessary taxes (might happen as soon as this year!)
- In the meantime, we will continue to live quite comfortably on a fairly low income.
- I met with my tax advisor to go over the plan to minimize taxes. I am quite happy with the result.
- Both workbooks have now been combined into one, for ease of use.
- As of 6/2/15, partial withdrawals from settled cash will be taken monthly instead of weekly from each account.
- 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 attempt to counteract this partially by reinvestment of some dividends.
- Capital One Investing (sharebuilder) Automatic Investment Plan invested $364 each in drad, ebf, gsb, npk, pulb, & ufpi on 12/8/15.
- Next Automatic investment will take place on Dec. 22nd, as I have switched to automatic investing on the 2nd & 4th Tuesday.
- Our portfolio continues to hemorrhage equity. We now have unrealized capital losses of 37.78%.
- When annual dividends are factored in, our unrealized capital loss is then 27.42%.
- I have been circling the wagons and battening down the hatches for a while, and made quite a few changes.
- Many dividends have been cut, some quite substantially, but dividends are still coming in. Economic rebound, my ass!
- I have decided that only stocks held @ Capital One Investing (sharebuilder) will be DRIPped.
Here’s a look at our balances from the 2015 Balances sheet (updated ~monthly) WARNING: It is NOT pretty!;
And, here are the current screenshots of the accounts in our portfolio from the TDM program (also not pretty);