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)
~
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...
-
The best dividend stocks have one thing in common: resiliency. They can continue increasing their dividends even in the harshest economic en...
-
Investors wanting to enjoy steady and consistent income should consider dividend aristocrats. In fact, even in these chaotic times, dividend...
-
Dividends and diversification -- those two things can help you achieve a comfortable retirement when combined with the income you will recei...
-
Higher dividend yields often imply that the underlying company paying the dividend has a higher risk profile. However, that's not always...
-
It's hard to beat a sustainable, high-yield dividend paired with a beaten-down valuation. The best dividend stocks offer high yields and...
-
When hunting for discounted investments, one excellent starting point is to look for businesses with dividend yields trading above their fiv...
-
Strange but true: seniors fear death less than running out of money in retirement. And unfortunately, even retirees who have built a nest eg...
-
Today we'll talk dividend deals. Big payers. Stocks yielding up to 10.3% and trading for as little as three-times free cash flow (FCF). ...
-
How high is too high when it comes to dividend stocks? Of course, every income investor wants as much yield as possible. However, they also ...
0 comments
Post a Comment
Post a Comment
Note: Only a member of this blog may post a comment.