To get started:
- Review the attached PPT and WORD files on analysis of financial data.
- Open the attached Excel document. Rename and save the document to your computer.
The Balance Sheet and Income Statement for Wal-Mart, Inc. are provided in the Walmart excel file, along with the worksheet you will complete.
On the Ratio Analysis worksheet, complete a ratio analysis of Walmartbased on the five categories of analysis discussed in the PPT lesson.
In EXCEL format, calculate at least two ratios from each category of Liquidity, Activity, Debt, Profitability, and Market, using the figures in the Jan 2011 and Jan 2012 columns.
This is a ratio calculation assignment- no written analysis.
For the Market/Book and Price/Book Ratios, you will need to find the current stock price for WalMart online.
If you do not have MS Excel, this assignment can be done in OpenOffice.
1/31/2012 1/31/2011 1/31/2010 1/31/2009 1/31/2008 1/31/2007 443854 418952 405046 401244 374526 344992 -335127 -315287 -304657 -306158 -286515 -264152 108727 103665 100389 95086 88011 80840 3096 2897 3168 4363 4273 3658 -85265 -81020 -79607 -76651 -70288 -64001 26558 25542 23950 22798 21996 20497 -2322 -2205 -2065 -2184 -2103 -1809 162 201 181 284 305 280 -2160 -2004 -1884 -1900 -1798 -1529 24398 23538 22066 20898 20198 18968 -7944 -7579 -7139 -7145 -6908 -6365 16454 15959 14927 13753 13290 12603 -67 1034 -79 146 -153 -894 16387 16993 14848 13899 13137 11709 -688 -604 -513 -499 -406 -425 15699 16389 14335 13400 12731 11284 1/31/2012 1/31/2011 1/31/2010 1/31/2009 1/31/2008 1/31/2007 6550 7395 7907 7275 5569 7373 5937 5089 4144 3905 3654 2840 40714 36318 33160 34511 35180 33685 1685 2960 2980 3063 3182 2690 89 131 140 195 54975 51893 48331 48949 47585 46588 109603 105098 99544 92856 93875 85390 2721 2780 2763 2797 3142 3050 112324 107878 102307 95653 97017 88440 20651 16763 16126 15260 16071 13759 5456 4129 3942 3567 2841 2406 138431 128770 122375 114480 115929 104605 193406 180663 170706 163429 163514 151193 1/31/2012 1/31/2011 1/31/2010 1/31/2009 1/31/2008 1/31/2007 4047 1031 523 1506 5040 2570 36608 33557 30451 28849 30370 28090 5089 5895 5986 5577 5247 5347 3638 3447 3224 3108 2907 2954 9427 9359 9524 9427 7645 6374 18154 18701 18734 18112 15799 14675 1164 157 1365 677 1016 706 1975 4655 4050 5848 5913 5428 326 336 346 315 316 285 26 47 92 83 62300 58484 55561 55390 58454 51754 44070 40692 33231 31349 29799 27222 3009 3150 3170 3200 3603 3513 7862 6682 5508 6014 5111 4971 54941 50524 41909 40563 38513 35706 117241 109008 97470 95953 96967 87460 404 408 307 397 342 352 378 393 397 413 3692 3577 3803 3920 3028 2834 68691 63967 66638 63660 57319 55818 -1410 646 -70 -2688 3864 2508 71315 68542 70749 65285 64608 61573 4446 2705 2180 1794 1939 2160 75761 71247 72…
Attachments:
0513.doc
0513.ppt
of_walmart_20….xlsx