P&G Expected Price Worksheet

P&G Expected Price Worksheet - 78,938 79,029 83,503...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Current Price= $61.00 Valuation Data 2011 2010 2009 2008 2007 2006 ## Tangible Bk. Val. NM NM NM NM NM NM ## Cash Flow 4.88 4.53 4.5 4.54 4.3 3.56 ## Earnings 3.93 3.53 3.58 3.64 3.04 2.64 ## Dividends 1.97 1.8 1.64 1.45 1.28 1.15 ## Payout Ratio 50% 51% 46% 40% 42% 44% ## Prices - High 67.72 65.38 63.48 73.81 75.18 64.73 ## 57.56 39.37 43.93 54.92 60.42 52.75 ## P/E Ratio - High 17 19 18 20 25 25 ## - Low 15 11 12 15 20 20 ## Financial Data (From Income Statement) 2011 2010 2009 2008 2007 2006 Net Inc. 11,797 10,946 11,293 12,075 10,340 8,684 Depr. 2,838 3,108 3,082 3,166 3,130 2,627 Int. Exp. 831 946 1,358 1,467 1,304 1,119 Eff. Tax Rate 26% 25% 30% 30% Pretax Inc. 15,189 15,047 15,325 16,078 14,710 12,413 Oper. Inc. 18,656 19,129 19,205 20,249 18,580 15,876 Revs. 82,559
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 78,938 79,029 83,503 76,476 68,222 # Of shares outstanding (in millions) 3001.781 3100.850 3154.469 3317.308 3401.316 3289.394 Sales Per Share 27.503 25.457 25.053 25.172 22.484 20.740 Avg Annual P/E Ratio 18.0833 16.000 15.000 15.000 17.500 22.500 22.500 Avg Annual P/S Ratio 2.6908 2.286 2.316 2.114 2.489 3.643 3.298 Avg Annual P/CF Ratio 13.8551 12.885 11.689 11.933 14.031 15.907 16.685 Estimated Financial Growth 3.00% Expected Upside from current stock price Exprcted Prices P/E Ratio $73.20 20.0% P/S Ratio $70.55 15.7% P/CF Ratio $69.64 14.2%- Low...
View Full Document

Ask a homework question - tutors are online