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
Dividend sustainability is paramount for the high-yield investor. Having a stock cut its dividend could potentially crush their income. A hi...
A stock with a high yield doesn't mean much if the dividend is cut or eliminated, and the stock price declines significantly. Sometimes...
Each Sunday I highlight any notable articles that I came across over the past week. Though I may not always agree with each of the articles ...
Linked here is a detailed quantitative analysis of Microsoft Corporation (MSFT). Below are some highlights from the above linked analysis: ...
Linked here is a detailed quantitative analysis of Nucor Corporation (NUE). Below are some highlights from the above linked analysis: Com...
Presented below are my dividend stock and ETF/CEF holdings. This is not a recommendation to buy these securities. I have classified some of...
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...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life
Linked here is a detailed quantitative analysis of Chevron Corporation (CVX). Below are some highlights from the above linked analysis: C...
Microsoft (MSFT) was founded by Bill Gates and Paul Allen on April 4, 1975. Gates and Allen were childhood friends with a passion for comput...