#HYHRD: Expected dividends-current holdings-actual yield as of 11/21 $HTBK $ANCX $DRAD

This is the regular posting of the review of “Expected dividends, current portfolio holdings, (and) actual yield” of the #HYHRD portfolio.

The title reflects expected dividends for next week.

The spreadsheet for each individual account, along with the monthly balances and yearly dividends are now found in the tradelogs workbook. However, only the tradelogs page with all the aggregate information is posted, the individual account pages, etc., are not posted (to save time and space).

This post will examine all those spreadsheets not previously covered for all positions held in the accounts (i.e.; positions not held will not appear on the spreadsheets).

Google Drive has the most recent workbooks accessible, in my public files area.

This MS Excel workbook now shows not only the Expected Dividends from the currently held positions across the HYHRD portfolio ($25,665.66/year), but now I have also added in the Equal Weight spreadsheet that shows the dollar amounts invested in each stock totaling ($246,758.56). This also enables me to calculate the ACTUAL YIELD for the portfolio holdings, and adds another spreadsheet called, amazingly enough, Actual Yield! From this sheet, I can further determine the most ‘bang for the buck’ by calculating the dividend expected per dollar invested! Um, please don’t put too much faith on that and base your investment on it, as I just wanted to calculate how much each stock would potentially earn (This portfolio should be expected to return about 10.401123% in dividends alone, according to the calculations that were just done). This does NOT consider capital gain/loss, like the new ‘scoring’ procedure does. I now use this new ‘scoring’ procedure along with all of the other indicators and sometimes my ‘gut feeling’ as to what and how to invest. Do your homework and do your own due diligence! YMMV!

I recently posted on my blog in response to a blog post from Chris Perruna, an excellent stock market blogger and financially astute person (IMHO), about my ‘gut feelings’ alluded to above. You can find my post here, with a link in it to Chris’s blog post. I highly recommend that you subscribe to his blog, and mine if you are so inclined.

The large variations in dividend income each month is due to the ‘small month, small month, big month’ dividend cycle, when some quarterly paying dividend stocks do not pay a dividend until 1 or 2 months later. At that time, we will witness the ‘big month’ dividend cycle (usually January, April, July, October). The recent portfolio reset is also a factor.

Mr. Market may have different ideas than you or I, so it’s always a good idea to at least have a look each day. I don’t like buying when the market is going down, but I don’t mind buying so much when the market is going up.

I have recently combined several spreadsheets to make them easier for me to get the info I need. The combined spreadsheets are the HYHRD screening spreadsheet, the Corepicks spreadsheet, and Investment amount spreadsheet. They are all now found in the Expected Dividends workbook. The spreadsheets will show $ Rank, Yield Rank, Score Rank, Avg., and Overall Rank which should help me tremendously in deciding where to invest our money! Previously, investing decisions were harder to make because I had to look at many different spreadsheets and pick the best choice(s) from each sheet and then take an (un?)educated guess as to where I should invest. All the spreadsheets are still there, but the Equal Weight spreadsheet will pull all the data together and show it all side by side.

While we’re on the subject of dividends;

Qualified dividends are a type of dividend to which capital gains tax rates are applied. These tax rates are usually lower than regular income tax rates. To this end, I will aim to hold mostly qualified dividend paying stocks in our joint (taxable) brokerage account. Here are the tax brackets for 2014;

2014taxbrackets

Here are the tax brackets for 2015;

2015taxbrackets

I have transferred all holdings of shares held at Computershare ($PGH, $PGF.CA or PGF.TO) where I used to reinvest shares at 95% of the share price and I am also no longer taking part in their discounted OCP that allowed me to purchase additional shares at 95% of the share price (both were suspended, effective with the quarterly dividend payable on September 15, 2015). This was a ‘lottery play’ on a Canadian oil stock. ALL shares have now been transferred to Capital One Investing (sharebuilder), and ALL dividends in this taxable account will be DRIPped. In the tax-advantaged accounts, I have decided that all dividends will also be DRIPped. Part (or ALL) of the cash in our accounts will be withdrawn each month on an ‘as needed’ basis. The available withdrawal amounts are shown on the Expected Dividends Part 4 spreadsheet.

Here are the static images as of this writing;

Expected Dividends part 1

expecteddividends1

Expected Dividends part 1a (showing IRA withdrawal amounts YTD, only changes after withdrawals)

expecteddividends1a

Expected Dividends part 2

expecteddividends2

Expected Dividends part 3

expecteddividends3

Expected Dividends part 4 (showing calculated and actual withdrawal amounts from each account)

expecteddividends4

Equal Weight (showing ‘overweight positions’ in each account)

equalweight

Actual Yield

actualyield

About PandA Trader

I am, I think... "Disobedience, in the eyes of anyone who has read history, is man's original virtue. It is through disobedience and rebellion that progress has been made." -- Oscar Wilde
This entry was posted in dividend portfolio. Bookmark the permalink.

Don't be shy! Leave a Reply...

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s