Obtain the balance sheet and income statement from Walmart from their latest 10-K annual reports.

Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (e.g., # shares of stock issued, outstanding, eps for other than the net income, etc.), Compute the ratios and financial analysis for each company as indicated below:

1. Horizontal analysis of the balance sheet and income statement (% change from year to year) for all the years presented.
2. Vertical analysis of the balance sheet and income statement for all years shown.
3. Ratio Analysis (Illustration 5A-1 p. 232) for two years for each company
   1. Current ratio
   2. Quick ratio
   3. Profit Margin on Sales
   4. Price-Earnings ratio (you will have to google stock price on the balance sheet date)
   5. Debt to Assets ratio