In Wednesday's article "Pre-Screening Dividend Stocks - Part II", I posted a link to [D4L-PreScreen.xls]. This was a cleaned up version of a tiny section of my two massive financial spreadsheets.
My wife would tell you that I am practical to a fault. I am not into appearance for the sake of appearance. I drive an inexpensive practical car and don't spend a lot of time fretting over how it looks. With that said, I thought some of you would enjoy a glimpse of my pre-screen model embedded in one of my two massive spreadsheets. Here's a peek at it:
Some of the items should look familiar to you. In cell F1 is the "Max Div. Growth" input; "Symbol" is in cell A132; the "NPV of MMA Differential" is calculated in cell D132; "Current Yield" is entered in I132; the outcome/action is in cell A134; the comment is in cell C134; "MMA Yield" is entered in C137. You will also notice my "Stocks to Pre-Screen" section around cell A144. My file is horizontal with each stock contained on a single row.
At the time of this writing there are approximately 100 securities that I am tracking in this file. This tab is linked to another tab where prices and yields are updated daily, which in turn will recalc NPV of MMA Differential for each file. This allows me to monitor securities such as JNJ that are on the borderline.
I must admit to a little spreadsheet envy after I built [D4L-PreScreen.xls]. However, the one above has been serving me well for many years, so I think I will keep her.
TV Trivia Question: What popular mid '60s to mid '70s TV show introduced the word "Epilogue" into the main-stream? Leave a comment with your guess. Don't know? Check back tomorrow for the answer!
- Yum! Brands And 5 Other Stocks Just Gave Their Shareholders A Raise
- Lockheed Martin Corp. Priced To Buy
Popular Posts - Last 7 days
Presented below are my dividend stock and ETF/CEF holdings. This is not a recommendation to buy these securities. I have classified some of...
A pessimist might say life is a series of bad things happening, then we die. I certainty wouldn't go that far, but life often deals us u...
Linked here is a detailed quantitative analysis of Medtronic Inc. (MDT). Below are some highlights from the above linked analysis: Compan...
Each Sunday I highlight any notable articles that I came across over the past week, along with any Carnivals I participated in. For those re...
Monday, October 31, 2011 will mark my fourth full year of writing as Dividends4Life . It is hard to believe another year has passed. Like th...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life
When to buy a stock and at what price are very important decisions. However, serious investors will tell you the most important decision is ...
Long considered the domain of “ widows and orphans ”, utilities have developed a somewhat stodgy reputation. Why are utilities considered...
Once again it is time for a goals/progress update. I am pleased to report that annualized dividend income increased in August, extending th...
The Broad Dividend Achievers™ Index is comprised of companies incorporated in the United States or its territories, trade on the NYSE, NASDA...