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 with quarterly updates on the 2015 Balances sheet.
“Smithers, release the hounds!”
- This week:
- ind-PandA (formerly brokerage-A) shows Total Net Profit of $6,538.90.
- Roth-A shows Total Net Profit of $7,330.36.
- IRA-A shows Total Net Profit of $16,708.29.
- Computershare (formerly brokerage-P) shows Total Net Profit of $2,859.49.
- Roth IRA-P shows Total Net Profit of $2,557.02.
- IRA-P shows Total Net Profit of $16,726.79.
- Overall, the HYHRD (High Yield High Return Dividend) portfolio shows a Total Net Profit of $39,036.42.
- Expected Dividends shows $30,593.65 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 adding 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.
This data is further broken down on each separate sheet in this spreadsheet (but not shown to save time and space).
- May 16th Update
- I continue to use the new program called TDM (Thomas Dividend Manager) from www.dividendsoftware.com.
- Weekly partial withdrawals from 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 3/6/15, partial withdrawals will be taken weekly instead of monthly from each account.
- Withdrawals will only be taken on an ‘as-needed’ basis.
- Withdrawals are subject to a minimum withdrawal amount of $10.00 (No withdrawals will be taken if under $10.00).
- I continue to accumulate more PGH through both their discounted DRIP and OCP (Optional Cash Purchase) plan.
- I have limit orders to sell a partial stake in my AI, CNSL, CYS, MORL, NYMT, & ORC positions.
- On 5/12 I sold 500 shares of LOAN in our joint account, and 945 shares of ORC in our IRAs.
- On 5/12 I bought 100 shares BGCP in our joint account, and 120 shares AGNC, 1,000 shares LOAN, 100 NRF, & 100 WMC in our IRAs.
- On 5/13 I bought 100 shares BGCP in our joint account and in my IRA.
Here’s a look at our balances from the 2015 Balances sheet (updated ~monthly);
And, here are the current screenshots of the accounts in our portfolio from the TDM program (not correctly projecting current month dividend amounts, the programmer was notified);