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
Over the years, I have observed that there are many ways to earn a good return in the market. In addition to buy and hold , some have succe...
Linked here is a detailed quantitative analysis of International Business Machines Corp. (IBM). Below are some highlights from the above li...
Linked here is a detailed quantitative analysis of Medtronic Inc. (MDT). Below are some highlights from the above linked analysis: Compan...
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 ...
To succeed as a dividend growth investor you must identify and purchase stocks with sustainable dividend growth. Inertia is powerful force....
D4L-Premium Services is designed to provide the busy dividend growth investor with a wealth of relevant information. Each week the D4L-Premi...
Since its introduction in July 2009, the D4L Premium Services has seen excellent growth in both features and subscribers. It started with t...
Presented below are are my Dividend Growth Stocks portfolio holdings. This is not a recommendation to buy these securities. I have classifi...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life
The D4L-Premium Services website went down Sunday morning January 17, 2016. I quickly put together an alternative means to deliver the premi...