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
-
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...
-
When a company pays a dividend, it's a good thing for shareholders. When a company consistently pays a dividend every quarter, it's ...
-
If you've been holding back from investing in your future just because you don't have a lot of extra cash to spare, I've got gre...
-
If you are looking for high-yield dividend stocks that can beat the market, you might want to check out these three companies. They all have...
-
If you are here to build a portfolio that thrives in all seasons, consider dividend stocks. They can generate steady returns and provide sta...
-
My top financial goal is to eventually become financially independent. The foundation of my strategy is to make investments that produce an ...
-
One way to achieve financial freedom is to create passive income, or income that does not depend on your active involvement beyond a certain...
-
The company's remarkable consistency and low-risk business model make it a "first-choice investment opportunity," according to...
-
Since 1926, dividends have contributed approximately 32% of the total return for the S&P 500, while capital appreciations have contribut...
0 comments
Post a Comment
Post a Comment
Note: Only a member of this blog may post a comment.