Wal-Mart Stores Expected Price Worksheet

Wal-Mart Stores Expected Price Worksheet - (in millions)...

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

View Full Document Right Arrow Icon
Current Price= $56.89 Valuation Data 2010 2009 2008 2007 2006 2005 ### Tangible Bk. Val. 25.64 17.97 14.2 13.35 9.11 7.28 ### Cash Flow 9.86 3.51 6.61 3.54 3.24 3 ### Earnings 7.49 1.63 4.76 2.57 2.6 2.45 ### Dividends 0.51 0.25 0.35 0.25 0.24 0.15 ### Payout Ratio 7% 16% 7% 10% 9% 6% ### Prices - High 80.4 48.41 121.95 53.15 27.59 24.81 ### - Low 39.13 11.8 13.73 23 15.69 11.7 ### P/E Ratio - High 11 30 26 21 10 10 ### - Low 5 7 3 9 6 5 ### Financial Data (From Income Statement) 2010 2009 2008 2007 2006 2005 Net Inc. 1,020 205 516 270 280 273 Depr. 322 237 201 107 74 49 Int. Exp. 70 39 40 22 4 5 Eff. Tax Rate 9% 21% 23% 23% 23% Pretax Inc. 1,312 225 681 370 388 368 Oper. Inc. 1,655 589 1,201 473 445 403 Revs. 4,682 2,342 3,609 2,275 1,933 1,753 # Of shares outstanding
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (in millions) 136.182 125.767 108.403 105.058 107.692 111.429 Sales Per Share 34.381 18.622 33.292 21.655 17.949 15.732 Avg Annual P/E Ratio 11.9167 8.000 18.500 14.500 15.000 8.000 7.500 Avg Annual P/S Ratio 2.5960 1.743 7.441 0.710 3.297 1.145 1.240 Avg Annual P/CF Ratio 8.0908 6.077 8.591 10.442 10.890 6.420 6.125 Estimated Financial Growth 4.00% Expected Upside from current stock price Exprcted Prices P/E Ratio $92.83 63.2% P/S Ratio $50.28 -11.6% P/CF Ratio $82.97 45.8% Wal-Mart Stores...
View Full Document

This note was uploaded on 01/24/2012 for the course ECON 101 taught by Professor Newman during the Spring '11 term at Mt. SAC.

Ask a homework question - tutors are online