WHOLE FOOD MKT Expected Price Worksheet

WHOLE FOOD MKT Expected Price Worksheet - 65,968 59,804...

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

View Full Document Right Arrow Icon
Medco Health Solution Current Price= $57.01 Valuation Data 2010 2009 2008 2007 2006 2005 ### Tangible Bk. Val. NM NM NM NM NM NM ### Cash Flow 4.21 3.6 2.98 2.33 1.69 1.63 ### Earnings 3.16 2.61 2.13 1.63 1.05 1.02 ### Dividends NI NI NI NI NI NI ### Payout Ratio NI NI NI NI NI NI ### Prices - High 66.94 66 54.62 51.67 32.06 28.98 ### - Low 43.45 36.46 29.8 26.26 23.54 20.27 ### P/E Ratio - High 21 25 26 32 31 28 ### - Low 14 14 14 16 22 20 ### Financial Data (From Income Statement) 2010 2009 2008 2007 2006 2005 Net Inc. 1,427 1,280 1,103 912 630 602 Depr. 477 485 443 397 392 358 Int. Exp. 172 172 234 134 65.9 73.9 Eff. Tax Rate 39% 38% 39% 38% 37% Pretax Inc. 2,334 2,103 1,791 1,503 1,012 953 Oper. Inc. 2,974 2,750 2,461 2,000 1,470 1,350 Revs.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 65,968 59,804 51,258 44,506 42,544 37,871 # Of shares outstanding (in millions) 451.582 490.421 517.840 559.509 600.000 590.196 Sales Per Share 146.082 121.944 98.984 79.545 70.907 64.167 Avg Annual P/E Ratio 21.9167 17.500 19.500 20.000 24.000 26.500 24.000 Avg Annual P/S Ratio 0.5093 0.379 0.505 0.527 0.643 0.609 0.393 Avg Annual P/CF Ratio 14.9735 13.135 14.138 14.295 16.790 16.464 15.018 Estimated Financial Growth 5.00% Expected Upside from current stock price Exprcted Prices P/E Ratio $72.72 27.6% P/S Ratio $65.21 14.4% P/CF Ratio $66.19 16.1%...
View Full Document

Ask a homework question - tutors are online