As noted in my articles Yield on Cost: Measuring for Success and Investing Goals, I consider Yield on Cost (YOC) an important metric. As such, I track it on each of my individual dividend income investments.
In the article The Winning Score - Part 2 of 2, I extracted from my two massive financial spreadsheets a sample model [it is linked on the tools page as D4L-Portfolio.xls] from the portfolio section. This model contains several elements worthy of discussion. Today we will focus the Yield On Cost (YOC) calculation.
YOC is tracked in columns Q and R. Rows 1, 2 and 3 provide a color-coded key for your reference. Cell Q11 contains the investment's most recent yield, R11 provides a weighted-average YOC for all the shares of the investment held.
Moving down one row, cell Q12 displays what the BAC's yield was on 4/22/2005, when I purchased 34 shares. In this case it was 4.01%, based on a quarterly dividend of $0.45, as shown in cell R13. Since I purchased BAC on 4/22/2005, the quarterly dividend has increased to $0.64 per share. Cell R12 contains the YOC for the 4/22/2005 purchase. You can see the dramatic effect of the three dividend increases, taking the initial yield of 4.01% to a 5.71% YOC.
In cells Q14, Q20, and Q27, you can see BAC has had some impressive dividend increases of 11.11%, 12.00% and 14.29%, respectively. On the date of each subsequent purchase of BAC, the per share price and current yield (col. Q) were higher than my initial purchase. This means the dividend per share was rising faster than the share price - From 04/22/2005 to 07/05/2007 the share price increased 10.8% while the dividend increased 42.2%.
The date in cell A1 has been hard-coded to =DATE(2008,2,4). If you decide to use some variation of this model, you will want to change the formula in cell A1 to =NOW(). This will populate the cell with the current date, which in turn will constantly update the YTD and LTD IRR calculations.
As always, I hope you find this model entertaining and useful.
Disclaimer: This model is for illustrative and educational purposes only. The author and Dividends4Life makes no claims or assertions as to the model's accuracy, completeness, appropriateness of use, or any other claim or assertion. You should not rely on this model or base any financial decisions on it.
Related Articles:
________________________________________________________________
Subscribe to:
Post Comments (Atom)
Dividend Growth Stocks News
~
Popular Posts Last 30 Days
-
If you're worried about inflation rearing its ugly head next year, you should probably worry about more likely catastrophes, such as bei...
-
As a relatively new blogger, the one thing that has stood out in my mind is the number of Canadian bloggers in the areas that I am most inte...
-
We screened our 24/7 Wall St. dividend equity research database and found 5 stocks that combined can generate over $3,000 of annual passive ...
-
The stock market has been on an upward path of late, with some of the most prominent stocks hitting astronomical highs. The dividend yield o...
-
Dividend growth stocks can be incredibly attractive investments if you crave recurring income. As these types of stocks raise their dividend...
-
The most dependable dividend stocks typically have a long track record of sustaining payouts through different market cycles. Companies with...
-
Dividends can be a tremendously powerful part of your investing strategy. Not only can they give you a continuing source of cash to reinvest...
-
In my opinion, there are three criteria investors should consider when evaluating a particular stock for their portfolio. The first is histo...
-
In this article, we discuss 5 best March dividend stocks to buy. If you want to read our detailed analysis of dividend capture strategy and ...
-
As the broader stock rally broadens to some of the more “boring” corners of the market, it’s the higher-yielding dividend plays that could s...
0 comments
Post a Comment
Post a Comment
Note: Only a member of this blog may post a comment.