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
I know very little about hockey, but I have always loved this quote: I skate to where the puck is going to be, not where it has been. &quo...
Any income investor will tell you that it is important for a company to sustain its dividend . However, as an investor in dividend growth st...
Linked here is a detailed quantitative analysis of Omega Healthcare Investors, Inc. (OHI). Below are some highlights from the above linked ...
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 United Technologies Corp. (UTX). Below are some highlights from the above linked analysi...
Has someone near and dear to you responded with a 'I was only trying to help' after royally messing something up? Have you ever tink...
Presented below are are my Dividend Growth Stocks portfolio holdings. This is not a recommendation to buy these securities. I have classifi...
Linked here is a detailed quantitative analysis of Target Corporation (TGT). Below are some highlights from the above linked analysis: Co...
Linked here is a detailed quantitative analysis of Pfizer Inc. (PFE). Below are some highlights from the above linked analysis: Company ...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life