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!
Related Articles:
Pre-Screening Dividend Stocks - Epilogue
Posted by D4L | Saturday, January 26, 2008 | personal, process | 0 comments »________________________________________________________________
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...
-
My top financial goal is to eventually become financially independent. The foundation of my strategy is to make investments that produce an ...
-
Dividend growth stocks can be incredibly attractive investments if you crave recurring income. As these types of stocks raise their dividend...
-
In my opinion, there are three criteria investors should consider when evaluating a particular stock for their portfolio. The first is histo...
-
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 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.