By far, my most used and most downloaded model is the D4L-PreScreen.xls model. I have just completed an update on it. This update includes the normal year-end changes, plus some rework on the Projected Information section. The changes are described below:
Normal Year-End Updates
The 3.54% rate is an average of the last two years highest ending MMA rate that I held. The rate will fluctuate +/- 0.5% as MMA rates change. In addition, I will continue to compare the rate to The 20-Year Treasury Yield. On December 1st, this rate was 3.51%; however, it has continued to drop since then. I will monitor the rate and adjust accordingly in the future.
Projected Information Section
This section was significantly reworked and expanded. Recently, I noticed a logic flaw in the NPV of MMA Differential calculation. The NPV was being calculated on a series of differences between the cumulative values of the stock and MMA. I added an annual calculation (row 23), below the errant calculation (row 22), which I left and continue to calculate a NPV of. The errant calculation generally followed the correct annual calculation and when calculating a NPV allowed for a wider range. The new correct NPV is found in cell B50. In an effort to calibrate the correct calculation, I will watch both during 2009.
Previous models only included the No Price Appreciation calculation. In his version, I added two other alternatives: Price Appreciation = Dividend Growth and Dividends/Interest Not Reinvested. Each are described below:
No Price Appreciation
This model assumes that the share price remains constant, thus the dividend yield grows each year based on the dividend growth rate. It also assumes all dividends and interest are reinvested.
Price Appreciation = Dividend Growth
This model assumes that the share price grows at the dividend growth rate, thus the dividend yield remains constant. It also assumes all dividends and interest are reinvested.
Dividends/Interest Not Reinvested
This model is identical to the No Price Appreciation model, except the dividends and interest are not reinvested.
The NPV of MMA Differential and the Sum of MMA Differential for each of the above calculations is found on rows 50 and 51.
Of the various models, I think that the Price Appreciation = Dividend Growth model provides the most realist results, but I generally do not use it because it includes capital growth, which is not accessible unless you sell the security. This runs counter to a income-based buy-and-hold philosophy.
If you run across any bugs or glitches, please be sure to let me know.
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:
Updated D4L-PreScreen.xls Model
Posted by D4L | Saturday, December 27, 2008 | models, tools | 0 comments »________________________________________________________________
Subscribe to:
Post Comments (Atom)
~
Popular Posts Last 30 Days
-
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...
-
GameStop (NYSE:GME) lost about 40% of its market value over the past three years, as rising digital downloads and declining mall traffic thr...
-
In a capitalistic society, opportunities to generate (mostly) passive income are all around us. Dividend growth investing is one of the most...
-
These elite income producers have rallied this year. Their brilliance at producing passive income seems to have caught the market's eye ...
-
Investors buy dividend stocks for a few reasons. For one, they provide income via dividends that act as a bonus on top of capital appreciati...
-
While optimism in the broader market remains robust – particularly for hyped-up sectors like technology – investors may still want to consid...
-
If you are looking for reliable dividends, these three Dividend Kings should be right up your alley. Dividends are paid at the discretion of...
-
Buying dividend stocks can be tricky. Oftentimes, stocks that pay exorbitantly high dividends have underlying financial problems, and their ...
-
Since the market highs in July, stocks have been under considerable pressure. Indeed, 10-year Treasury yields are at the highest level since...
-
A strong dividend investing strategy may be to focus on high-quality names that score well on several dividend-related metrics. In other wor...
0 comments
Post a Comment
Post a Comment
Note: Only a member of this blog may post a comment.