Price:
11-21-2007: $67.75
02-11-2008: $62.03 (Good!)
P/E:
11-21-2007: 19
02-11-2008: 17.3 (Good!)
Yield:
11-21-2007: 2.48%
02-11-2008: 2.64% (Good!)
Avg. P/E Price:
11-21-2007: Unfavorable
02-11-2008: Favaorable (Good!)
Years to MMA:
11-21-2007: 14
02-11-2008: 11 (still one more than I prefer as a maximum, by 1 year)
NPV MMA Diff:
11-21-2007: $471
02-11-2008: $2,517 (More than 5 times the November 21st amount)
Since new dividend data was available, I used my model D4L-PreScreen.xls to update some of the above analysis. I input the following data:
Symbol: JNJ
Year: 2007
Current Yield: 2.64%
Calc. Div. Growth: 11.0%
MMA Yield: 4.86%
Max Div. Growth: 20.0%
Override Div. Gro: 0.0%
Dividends:
2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997
1.62 1.46 1.28 1.10 0.93 0.80 0.70 0.62 0.55 0.49 0.43
The calculated NPV MMA Diff only changed slightly. I determined that it would take a dividend growth rate of 11.7% to get the Years to MMA down to 10 (the maximum I like to see). Since I use a conservative method of estimating the dividend growth rate, a 11.7% is not unrealistic given the 11-year average is 14.0%. Using the Override Div. Gro. field I entered 14.0% to see what that did to the NPV MMA Diff - it increased to $8,132. I entered 5,000 in cell C25 then pressed the button in D12 to backsolved for the growth rate needed to give me a NPV MMA Diff of $5,000. It was 12.6% which is not unreasonable.
My conclusion: Buy. Like General Electric Company (GE), JNJ is one of those boring predictable companies that finds its way into most every dividend investor's portfolio. JNJ is a well-managed, well-run company and has been that way for decades. I like owning companies like JNJ and GE because it offsets some of my more riskier investments, but I will not buy in at just any price. I purchased a small block of JNJ and will continue to watch it for opportunities to add to my position.
Full Disclosure: At the time of this writing, I proudly own shares of JNJ.
Tomorrow: What did I sell to buy JNJ and why?
Related Articles:
- Stock Analysis: Johnson & Johnson (JNJ)
- It Was An Odd Odyssey
- General Electric Company (GE)
- Citigroup Inc. (C)
- Sometimes Things Aren't As They Appear
- More Stock Analyses
