The D4L-PreScreen.xls model continues to be the most downloaded and used model in my toolbox. I have just completed an update on it. This update includes some minor tweaks and updates on interest rates used in the model. The changes are described below:
D4L-PreScreen.xls Model – August 2009 Update
Updated D4L-PreScreen.xls Model
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:
Dividend Investing vs. S&P Index Fund
Part of my kids’ college fund is invested in Vanguard’s S&P 500 Index Fund (VFINX). When I opened the October statement, I was mildly surprised to see the net asset value had fell below the September 1997 level when the account was first opened. Over the year I have become somewhat disenchanted with mutual funds, ETFs and CEFs due to their recent poor performance relative to my dividend investments.
This Sword Has Two Edges!
Last Saturday in my article “You Can’t Beat the Herd by Following the Herd“, I promised to share a MSN Stock Screen that helped me identify some exceptional stocks, and got me into some trouble.
The D4L High Yield Stocks is a screen that I have used in the past to find some real jewels Note: You will likely not be able to view this screen unless you are using Internet Explorer. Here are the criteria used in this screen:
You Can’t Beat the Herd by Following the Herd
“You can’t beat the herd by following the herd.” If you have read this blog for any period of time you have likely seen me use the above statement.
As noted in “Fishing in the Bathtub“, the S&P 500 Dividend Aristocrats and Mergent’s Broad Dividend Achievers are two places I frequent when looking for potential dividend investments, as do most all dividend investors. But for my more risky higher-return dividend investments, I have to look elsewhere. One of these places is the MSN Stock Screener.
Updating the MMA Rate
You may have noticed the Money Market Account (MMA) rate that I am using in my stock analyses has been dropping. It ended the year at 5.11% and is currently 4.61%. As noted in my Dividend Income vs. MMA post, I have historically used the highest rate of the MMAs that I personally own (realistic opportunity cost).
New Tool For The Toolbox
Jake at The Dividend Investing Blog has coded a New Dividend Tool. Jake described it as such:
Read more…
Dividends4Life Toolbox
Presented here are some models and tools you might find useful:
Excel Models:
D4L-Portfolio.xls (alt.1) is a subset of my Portfolio tab contained within one of my two financial spreadsheets. It illustrates several basic concepts as noted in these articles:
Read more…









Tools To Calculate Investment Returns
The ability to track and calculate a total rate of return for your your portfolio, and subsets of it, is an important management tool. To calculate an annual and life-to-date rate of return for an individual stock, I will refer you to my article “The Winning Score – Part 2 of 2″. This same technique could be used for calculating a return on an entire portfolio, or subsets of it; however, it would be extremely cumbersome and time consuming. Besides, there are much better tools to do it such as the one I use, MSN’s Deluxe Portfolio at MoneyCentral (MSNDP).
Read more…