Linked here is a PDF copy of my analysis of Procter & Gamble Co. (PG) (alt.1, alt.2). Below are some highlights from the above linked analysis:
Company Description: The Procter & Gamble Company (P&G) is focused on providing branded consumer goods products. The Company markets its products in more than 180 countries.
Fair Value: I consider four calculations of fair value, see page 2 of the linked PDF for a detailed description: 1.) Avg. High Yield Price, 2.) 20-Year DCF Price, 3.) Avg. P/E Price and 4.) Graham Number. PG is trading at a discount to 1.) and 3.) above. If I exclude the high and low valuation, and average the remaining two valuations, PG is trading at a 12.9% premium. Since PG is trading at a price in excess of a 5% premium, a Star is deducted.
Dividend Analytical Data: In this section I consider five factors, see page 2 of the linked PDF for a detailed description: 1.) Rolling 4-yr Div. > 15%, 2.) Dividend Growth Rate, 3.) Years of Div. Growth, 4.) 1-Yr. > 5-Yr Growth and 5.) Payout 15% of avg. PG earned Stars in 3.) Years of Div. Growth above - it has increased its dividend for 10+ years.
Dividend Income vs. MMA: Why would you assume the equity risk and invest in a dividend stock if you could earn a better return in a much less risky money market account (MMA)? This section compares the earning ability of this stock with a high yield MMA. Two items are considered in this section, see page 2 of the linked PDF for a detailed description: 1.) NPV MMA Diff. and 2.) Years to >MMA. PG did not earn any Stars in this section. In fact, one Star was deducted since the NPV MMA Diff. was ($900) negative. This means for every $1,000 invested, on a net present value basis (NPV), you would be $900 better off by investing in a MMA at earning 4.61%.
Other: PG is a well-managed company that produces consumer staples. PG's ability to consistently grow its dividend over different economic cycles has made it a staple in most dividend investors portfolio.
Conclusion: PG lost one Star in the Fair Value section, earned one Stars in the Dividend Analytical Data section and lost one Stars in the Dividend Income vs. MMA section for a total of Minus-One Stars, which is one below my scale's floor of zero, which rates it as a 0-Star Avoid stock.
PG is one of those Blue-Chip stocks that I would love to have in my portfolio, but not at this price. Using my D4L-PreScreen.xls model I determined that the dividend growth rate would have to increase to 11.7% for PG's NPV of MMA Differential to reach $1,000. Alternatevely, the share price would have to fall an additional 18% for PG's NPV of MMA Differential to reach $1,000. Near-term, I see neither happening. I will continue to monitor PG for buying opportunities.
Disclaimer: Material presented here is for informational purposes only. The above quantitative stock analysis, including the Star rating, is mechanically calculated and is based on historical information. The analysis assumes the stock will perform in the future as it has in the past. This is generally never true. Before buying or selling any stock you should do your own research and reach your own conclusion. See my Disclaimer for more information.
Full Disclosure: At the time of this writing, I do not own shares of PG (0.0% of my Income Portfolio).
What are your thoughts on PG?
Recent Stock Analyses:
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...
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...
Linked here is a detailed quantitative analysis of AFLAC Incorporated (AFL). Below are some highlights from the above linked analysis: Co...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life
We all know what surprising the street will do to a stock's price. The street focuses on quarterly revenue, EPS, EBIT, EBITDA and margi...
When to buy a stock and at what price are very important decisions. However, serious investors will tell you the most important decision is ...
Linked here is a detailed quantitative analysis of Archer Daniels Midland Company (ADM). Below are some highlights from the above linked an...