Can you please assit with the questions please check both attachments for numbers.

HOME DEPOT INC $ in millions Year Ending NET SALES Cost of sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME 1/29/2017 $94,595 62,282 32,313 1/31/2016 $88,519 58,254 30,265 2/1/2015 $83,176 54,787 28,389 2/2/2014 $78,812 51,897 26,915 17,132 1,754 18,886 13,427 16,801 1,690 18,491 11,774 16,280 1,640 17,920 10,469 16,122 1,627 17,749 9,166 936 12,491 4,534 $7,957 753 11,021 4,012 $7,009 493 9,976 3,631 $6,345 699 8,467 3,082 $5,385 Basic earnings per share Diluted earnings per share $6.47 $6.45 $5.49 $5.46 $4.74 $4.71 $3.78 $3.76 Dividends per share $2.76 $2.36 $1.88 $1.56 Interest and Other, net Earnings before income taxes Provision for Income Taxes NET EARNINGS HOME DEPOT INC $ in millions As of 1/29/2017 1/31/2016 2/1/2015 2/2/2014 ASSETS Current assets: Cash and cash equivalents Accounts receivable, net Merechandise inventories Other current assets $2,538 2,029 12,549 608 $2,216 1,890 11,809 569 $1,723 1,484 11,079 1,016 $1,929 1,448 11,439 795 Total Current Assets 17,724 16,484 15,302 15,611 Property & Equipment, at cost Less Accumulated Depreciation and Amortization Net Property & Equipment 40,426 18,512 21,914 39,266 17,075 22,191 38,513 15,793 22,720 39,064 15,716 23,348 Goodwill Other assets TOTAL ASSETS 2,093 1,235 $42,966 2,102 1,196 $41,973 1,353 571 $39,946 1,289 602 $40,850 $710 7,000 1,484 508 1,669 25 542 2,195 $350 6,565 1,515 476 1,566 34 77 1,941 $290 5,807 1,391 434 1,468 35 38 1,806 $0 6,071 1,428 396 1,337 12 33 1,646 LIABILITIES AND SHAREHOLDERS EQUITY Current liabilities: Short-term debt Accounts payable Accrued salaries & related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Other accrued expenses Total current liabilities 14,133 12,524 11,269 10,923 Long-term debt, excluding current installments Other long-term liabilities Deferred income taxes Total liabilities 22,349 1,855 296 38,633 20,789 1,965 379 35,657 16,869 1,844 642 30,624 14,691 2,200 514 28,328 Shareholders equity: Common stock Paid-in capital Retained earnings Accumulated other comprehensive income (loss) Treasury stock, at cost Total shareholders equity 88 9,787 35,519 (867) (40,194) 4,333 88 9,347 30,973 (898) (33,194) 6,316 88 8,885 26,995 (452) (26,194) 9,322 88 8,402 23,180 46 (19,194) 12,522 TOTAL LIABILITIES AND SHAREHOLDERS EQUITY $42,966 $41,973 $39,946 $40,850 HOME DEPOT INC $ in millions Year Ending OPERATING ACTIVITIES: Net earnings Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Stock-based compensation expense Gain on sales of investments Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net Merchandise inventories Other current assets Accounts payable and accrued expenses Deferred revenue Income taxes payable Deferred income taxes Other Net cash provided by operating activities INVESTING ACTIVITIES: Capital expenditures Proceeds from sales of investments Payments for business acquired Proceeds from sales of property & equipment Net cash used by investing activities FINANCING ACTIVITIES: Proceeds from short-term borrowings, net Proceeds from long-term borrowings, net of discount Repayments of long-term debt 1/29/2017 1/31/2016 2/1/2015 2/2/2014 $7,957 $7,009 $6,345 $5,385 1,973 267 0 1,990 244 (144) 1,940 225 (323) 1,927 228 0 (138) (769) (48) 446 99 109 (117) 4 (181) (673) (5) 888 109 154 15 (33) (81) (278) (199) 244 146 168 159 (104) (15) (625) (5) 605 75 119 (31) (35) $9,783 $9,373 $8,242 $7,628 (1,621) 0 0 38 (1,503) 144 (1,666) 43 (1,442) 323 (200) 48 (1,389) 0 (206) 88 ($1,583) ($2,982) ($1,271) ($1,507) 360 4,959 (3,045) 60 3,991 (39) 290 1,981 (39) 0 5,222 (1,289) Repurchases of common stock Proceeds from sales of common stock Cash dividends paid to stockholders Other financing activities (6,880) 218 (3,404) (78) (7,000) 228 (3,031) 4 (7,000) 252 (2,530) (25) (8,546) 241 (2,243) (37) Net cash used by financing activities ($7,870) ($5,787) ($7,071) ($6,652) $330 (8) $604 (111) ($100) (106) ($531) (34) Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year 2,216 $2,538 1,723 $2,216 1,929 $1,723 2,494 $1,929 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest Income taxes $924 $4,623 $874 $3,853 $782 $3,435 $639 $2,839 Change in Cash and Cash Equivalents Effect of exchange rate changes on cash and cash equivalents ACT 5140 - Accounting for Decision Makers HW #1 - Appendix A Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please \"cut and paste\" your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file. The assignment is due by 11:59 PM Eastern on August 27. Please run spell check and proofread your answers. If you have any questions, please e-mail me at af878@nova.edu or andrew.felo@gmail.com. Good luck! NOTE: This assignment is the intellectual property of Dr. Andrew J. Felo. It may not be posted to any website without the express written consent of Dr. Felo. Question #1 Using the accompanying financial statements (Excel Workbook), assess The Home Depot concerning liquidity, solvency, profitability, and stock performance. For each area, you should calculate the ratios we discussed in class and provide a brief analysis of the ratios calculated. You do not need to perform vertical analysis for this assignment. I include historical stock price information and outstanding common share information below. You do not need to look beyond the financial statements to complete this assignment. Fiscal Year Ended 1/29/2017 1/31/2016 Adjusted Closing Price $136.70 $121.69 Common Shares Outstanding (millions) 1,203 1,252 2/1/2015 $99.05 2/2/2014 $71.36 1,307 1,380