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!
- 7 Stocks Delivering Higher Dividends
- Dividend Stock Analysis: Leggett & Platt, A Solid Steady Performer
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...
Many Americans are worried that they might not have enough money for retirement. Women who outlive their husbands are at special risk, with ...
We have all heard it... Stodgy, for old people, yawn, boring! These have all been used to describe investing in dividend growth stocks. Neve...
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...
Linked here is a detailed quantitative analysis of AFLAC Incorporated (AFL). Below are some highlights from the above linked analysis: Co...
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...
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 ...
The Pocket Change Portfolio (PCP) was first introduced on September 13, 2008 as a real money dividend income portfolio funded by the "...
Linked here is a detailed quantitative analysis of Archer Daniels Midland Company (ADM). Below are some highlights from the above linked an...