The instructions on how to do the problem is on the first picture. Where the answers go is on the last picture attached 
The Income Statement and Balance Sheet for The Home Depot, Inc. can be found as separate worksheets on tabs (a) and (b), respectively. On worksheet O, prepare a ratio analysis for 2017 and 2016 that includes the following ratios: Current ratio Net income to average common stockholder's equity Inventory turnover Number of days' sales in accounts receivable (assume 365 days in a year) Equity ratio Profit Margin Total Assets turnover Acid-test (quick ratio) For three ratios (current ratio, inventory turnover, and profit margin) include your interpretation of the results of your analysis. Your interpretation should include what the ratio measures, whether it is increasing or decreasing, and whether the company should be concerned about the change in the ratio. The Home Depot, Inc Income Statement For the years endec (all numbers in millions) January 29,2017 January 31, 2016 February 1,2015 Revenue: Total Revenue Cost of Revenue (COGS) 94,595 62,282 32,313 88,519 58,254 30,265 83,176 54,787 28,389 Gross profit Operating Expenses Selling, General & Administrative Other Expense 17,132 1,754 18,886 16,801 1,690 18,491 16,280 1,640 17,920 Total Operating Expense Operating Income 13,427 11,774 10,469 166 11,940 919 11,021 4,012 7,009 Other Income 36 13,463 972 12,491 4,534 7,957 337 10,806 830 9,976 3,631 6,345 Earnings before Income and Taxes Interest Expense Income before Tax Income Tax Expense Net Income (al numbers in mwons) Current Assets Cash and Cash Equivalents Net Receivables Inventory Other Current Assets 2,538 2,029 12,549 608 17,724 2,216 1,890 11,809 569 16,484 1,723 1,484 11,079 1,016 15,302 Total Current Assets Long-term Assets Property, Plant&Equipment Goodwill Other 21,914 2,093 1,235 25,242 42,966 22,191 2,102 1,196 25,489 41,973 22,720 1,353 571 24,644 39,946 Total Long-term Assets Total Assets Current Liabilities Accounts Payable Short-term debt Other current liabilities 9,473 11,212 1,252 1,669 14,133 10,531 1,566 12,524 1,468 11,269 Total Current Liabilities Long-term Liabilities Long-term Debt Other Deferred Liabilities 22,349 1,855 296 24,500 38,633 20,789 1,965 379 23,133 35,657 16,869 1,844 642 19,355 30,624 Total Long-term Liabilities Total Liabilities Stockholders Equity Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity 35,519 (40,194) 9,787 30,973 (33,194) 9,347 (898) 6,316 26,995 (26,194) 8,885 Total Stockholder's Equity 4,333 9,322 Total Liabilities and Stockholder's Equity 42,966 41,973 39,946 2017 2016 Interpret Current Ratio (Interpret) Net Income to average common eauitv Inventory Turnover (Interpret) Number of days sales in accounts receivable Equity ratio Net Profi Margin (Interpret) Total Assets Turnover Acid-test (quick) ratio
