Procter & Gamble Co (PG)

OPPORTUNITIES: High Owner Earnings FCF Consistency and 50% DCF MoS
PRE-SCREEN: Dividends covered by FCF since 1999
PRE-SCREEN: High Consistency Owner Earnings FCF
DIVIDEND STOCKS: US Broad Dividend Achievers
DIVIDEND STOCKS: US Dividend Aristocrats
DIVIDEND STOCKS: US Dividend Champions
GURU LIST: Warren Buffet Portfolio
STOCKS LIST: NYSE Large-Cap 1% Dividend Stocks

Valuation Chart

Valuation Chart

The Procter & Gamble Company (P&G) is focused on providing branded consumer packaged goods. The Companys products are sold in over 180 countries worldwide primarily through mass merchandisers, grocery stores, membership club stores, drug stores and in high-frequency stores, the neighborhood stores, which serve consumers in developing markets. As of June 30, 2009, the Company was organized into three Global Business Units: Beauty; Health and Well-Being, and Household Care. The Company had six business segments under United States Generally Accepted Accounting Principles (GAAP): Beauty; Grooming; Health Care; Snacks and Pet Care; Fabric Care and Home Care, and Baby Care and Family Care. In August 2009, AnimalScan, LLC announced that it has acquired Iams Pet Imaging, LLC from The Procter & Gamble Company and ProScan Imaging. In November 2008, the Company completed the divestiture of its Coffee business through the merger of its Folgers coffee subsidiary into The J.M. Smucker Company.
See also: MorningStar | Yahoo! | Motley Fool

Margin of Safety
Ticker Cap $B CAPM Asset EPV DCF Graham Price to Book (MRQ vs 5 Yr Avg) Price to Sales (TTM vs 5 Yr Avg) Price to Cash Flow (TTM vs 3 Yr Avg) P/E Ratio (TTM vs 5 Yr Avg) Current Price
PG 185 6.0 -50% 14% 101% -24% 5% 12% 2% 10% 63.7
CL 42 5.7 -75% -4% -18% -60% 52% 3% -18% 15% 84.2
KMB 25 5.5 -50% 17% 18% -46% 14% 22% 3% 25% 60.1
AVP 13 9.9 -42% -8% -56% -46% 63% 18% -67% 6% 31.3

Valuation
Ticker Cap $B CAPM P/E Ratio (TTM) Price to Sales (TTM) Price to Book (MRQ) Price to Tangible Book (MRQ) Price to Cash Flow (TTM) Price to Free Cash Flow (TTM) EV / Revenue (TTM) EV / EBITDA (TTM) Earnings Yield
PG 185 6.0 18.0 2.4 2.8 0.0 13.4 21.0 2.7 10.7 9%
CL 42 5.7 19.3 2.7 14.1 0.0 15.3 24.1 2.9 11.2 9%
KMB 25 5.5 13.3 1.3 4.6 11.7 9.6 15.2 1.6 8.0 12%
AVP 13 9.9 21.4 1.3 10.4 14.3 16.2 109.5 1.4 10.4 10%

Financial Health
Ticker MS Style Box MStar Piotroski F-Score Altman Z-Score Quick Ratio (MRQ) Current Ratio (MRQ) LT Debt to Equity (MRQ) Total Debt to Equity (MRQ) Interest Coverage (TTM)
PG Classic Growth A 6 3.3 0.6 0.9 32.5 43.8 11.5
CL Aggressive Growth A 7 7.3 0.7 1.1 90.5 102.1 32.3
KMB Classic Growth A 6 3.4 0.8 1.2 88.6 99.9 9.9
AVP Aggressive Growth B 4 4.7 1.4 1.8 181.4 192.2 21.2

Growth
Ticker Cap $B CAPM MStar Sales (MRQ) vs Qtr 1 Yr Ago Sales (TTM) vs TTM 1 Yr Ago Sales 5 Yr Growth Rate EPS (MRQ) vs Qtr 1 Yr Ago EPS (TTM) vs TTM 1 Yr Ago EPS 5 Yr Growth Rate Capital Spending 5 Yr Growth Dividend 5 Yr Growth
PG 185 6.0 C 6.4 2.4 8.3 13.8 -0.8 9.5 9.9 12.0
CL 42 5.7 C 11.4 2.7 7.7 28.6 19.3 13.4 10.6 12.4
KMB 25 5.5 C 8.4 1.3 4.9 16.0 11.5 5.0 9.7 8.5
AVP 13 9.9 C 13.3 1.3 6.0 14.2 -29.0 -3.9 3.5 8.5

Profitability
Ticker Cap $B CAPM MStar ROA (TTM) ROA 5 Yr Avg ROI (TTM) ROI 5 Yr Avg ROE (TTM) ROE 5 Yr Avg. Payout Ratio (TTM) Dividend Yield
PG 185 6.0 C 8.0 8.2 10.3 10.7 16.7 18.5 46.7 2.8%
CL 42 5.7 B 22.7 18.8 33.5 28.4 96.4 105.9 37.8 2.5%
KMB 25 5.5 A 9.8 9.3 13.6 13.2 40.6 31.7 52.9 4.4%
AVP 13 9.9 A 9.8 12.4 16.5 23.7 63.7 81.9 57.8 2.8%

Margins
Ticker Cap $B CAPM Gross (TTM) Gross 5 Yr Avg EBITD (TTM) EBITD 5 Yr Avg Operating (TTM) Operating 5 Yr Avg Net Profit (TTM) Net Profit 5 Yr Avg Return on Capital
PG 185 6.0 51.2 50.7 24.9 23.8 20.9 20.9 14.2 13.4 84%
CL 42 5.7 58.8 57.0 25.9 23.0 23.6 23.6 15.6 13.1 96%
KMB 25 5.5 33.6 31.5 18.9 18.5 14.8 14.8 9.6 9.2 43%
AVP 13 9.9 62.2 61.4 11.6 12.5 9.8 9.8 6.1 7.0 48%

Growth Chart

Profitability Chart

Margins Chart

Legend:
Trailing Twelve Months
Most Recent Quarter

Risk Free Rate: 3.41%
US Equity Market Risk Premium: 4.44%

S&P 500 Ratios
P/E: 20.2
Price/Book: 3.94
Price/Sales: 2.17
Price/Cash Flow: 14.40
Dividend Yield: 2.00%

Excel Stock Valuation Spreadsheet Last Weekly Update:
03-05-2010

Credits:
Stock Market Functions Add-in
Old School Value
DRiP Investing
Damodaran Online
MorningStar
L’investisseur heureux

Important:
Frequently Asked Questions
Disclaimer