1. Do the following:

• Complete the Nike, Inc. Problem (page 879) in the textbook. You must use Microsoft Excel to complete this problem. Complete both questions (#1 and #2) listed on page 879.
  • Make sure the calculations and answers you provide in response to Question 1 are clearly indicated for both of the years required in the problem.
  • To compute some of the ratios listed in Question #1, you will need to compute an Average. Thus, when computing an average for a 2016 ratio, you would use the appropriate amounts for 2016 & 2015. To compute an average for a 2015 ratio, you would use the appropriate amounts for 2015 & 2014.
  • Make sure you provide an answer for Question 2 (at least 1 paragraph in length).
  • You must use Appendix D located in the text on pages D-1 to D-8.
  • The financial statements are located on pages D-4 to D-8. But you will need to refer to the additional information provided on page 879 in order to calculate some of the ratios for 2015.
  • You must round to one decimal place in your final answers.

Please help me there are two questions to answer. Thank you.

Can someone please help me.

Nike, Inc., Problem a Hi Financial statement analysis vise at diam. The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information in thousands): Accounts receivable at May 31, 2014 $ 3,117 Inventories at May 31, 2014 4,142 Son Total assets at May 31, 2014 18,594 Stockholders' equity at May 31, 2014 12,000 Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days' sales in receivables f. Inventory turnover g. Number of days' sales in inventory h. Ratio of liabilities to stockholders' equity i. Asset turnover j. Return on total assets. k. Return on common stockholders' equity 1. Price-earnings ratio, assuming that the market price was $54.90 per share on May 29, 2016, and $52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales What conclusions can be drawn from these analyses? 2. D-4 Appendix D Selected Excerpts from Nike Inc, Form 10-K for the Fiscal Year Ended May 31, 2016 NIKE, Inc. Consolidated Statements of Income $ S (In millions, except per share data) Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net Other (income) expense, net Income before income taxes Income tax expense NET INCOME Year Ended May 31, 2016 2015 32,376 $ 30.601 17,405 16,534 14,971 14,067 3,278 3.213 7.191 6.679 10,469 9,892 19 28 (140) (58) 4,623 4,205 863 932 3,760 $ 3.273 2014 27.799 15,353 12.446 3,031 5,735 8,766 33 103 3,544 851 2,693 $ $ Earnings per common share: Basic Diluted 2.21 2.16 $ $ 1.90 1.85 $ $ 1.52 1.49 Dividends declared per common share 0.62 0.54 $ 0.47 Appendix D Selected Excerpts from Nike Inc., Form 10-K for the Fiscal Year Ended May 31, 2016 D-5 NIKE, Inc. Consolidated Statements of comprehensive Income 2015 2016 3,760 2014 2,693 Net income 3,273 S (20) 1,188 (32) (161) 4 (189) 2,504 $ (In millions) Year Ended May 31, Other comprehensive income (loss), net of tax Change in net foreign currency translation adjustment (176) Change in net gains (losses) on cash flow hedges (757) Change in net gains (losses) on other Total other comprehensive income (loss), net of tax (928) 1.161 TOTAL COMPREHENSIVE INCOME 4,434 (1) Net of tax benefit (expense) of $0 million. $0 million and $0 million, respectively. (2) Net of tax benefit (expense) of $35 million $(31) million and $18 million, respectively. (3) Net of tax benefit (expense) of $0 million. $0 million and $0 million, respectively. The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement nion website at CengageBrain.com $ $ 2,832 D-6 Appendix D Selected Excerpts from Nike Inc. Form 10-K for the Fiscal Year Ended May 31, 2016 NIKE, Inc. Consolidated Balance Sheets May 31 2016 2015 $ $ 3.138 2,319 3,241 4,838 1.489 15.025 3,520 281 3.852 2,072 3,358 4,337 1,963 15.587 3,011 281 131 2,587 21,597 131 2,439 21,396 $ Un millions) ASSETS Current assets: Cash and equivalents Short-term investments Accounts receivable, not Inventories Prepaid expenses and other current assets Total current assets Property, plant and equipment, not Identifiable intangible assets, net Goodwill Deferred income taxes and other assets TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long-term debt Deferred income taxes and other liabilities Commitments and contingencies Redeemable preferred stock Shareholders' equity: Common stock at stated value: Class A convertible - 353 and 355 shares outstanding Class B-1,329 and 1,357 shares outstanding Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 44 1 2.191 3,037 85 5,358 2,010 1.770 107 74 2.131 3,949 71 6,332 1,079 1,479 7.786 318 4.151 12,258 21,396 3 6.773 1.246 4,685 12,707 21.597 $ The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement. Appendix D Selected Excerpts from Nikein Form 10-K for the Fiscal Year Ended May 31, 2016 D-7 NIKE, Inc. Consolidated Statements of Cash Flows Un milions) Year Ended May 31, Cash provided by operations: Net income 2016 2015 2014 Income charges (credits) not affecting cash: $ 3.273 $ 518 (11) 177 68 56 Depreciation 3.760 2,693 Deferred Income taxes Stock-based compensation 649 606 Amortization and other (20) (113) Net foreign currency adjustments 236 191 Changes in certain working capital components and other assets and 13 43 liabilities: 98 424 Decrease increase) in accounts receivable (Increase) in Inventories (Increase in prepaid expenses and other current assets 60 (216) (298) (Decrease) increase in accounts payable, accrued liabilities and (590) (621) (505) (161) (144) (210) income taxes payable Cash provided by operations (889) 1.237 525 Cash used by investing activities: 3.096 4,680 3.013 Purchases of short-term investments Maturities of short-term investments (5.367) (4.936) (5,386) Sales of short-term investments 2,924 3,655 3,932 Investments in reverse repurchase agreements 2,386 2.216 1.126 Additions to property, plant and equipment 150 (150) Disposals of property, plant and equipment (1.143) (963) (880) 10 3 3 Decrease increase) in other assets, net of other liabilities 6 Cash used by investing activities (2) (1034) (175) (1.207) Cash used by financing activities: Net proceeds from long-term debt issuance 981 Long-term debt payments, including current portion (106) (7) (60) (Decrease) increase in notes payable (67) (63) 75 Payments on capital lease obligations (7) (19) (17) Proceeds from exercise of stock options and other stock issuances 507 514 383 Excess tax benefits from share-based payment arrangements 281 132 Repurchase of common stock (3,238) (2,534) (2.628) Dividends - common and preferred (1.022 (899 (799) (2,671) (2.790) (2.914) Cash used by financing activities 105 (83 (9) Effect of exchange rate changes on cash and equivalents (714) 1,632 (1.117) Net (decrease) increase in cash and equivalents 3,852 2.220 3,337 Cash and equivalents, beginning of year $ 3,138 $ 3,852 $ 2,220 CASH AND EQUIVALENTS, END OF YEAR Supplemental disclosure of cash flow information: Cash paid during the year for. 70 $ $ 53 Interest, net of capitalized interest 748 1.262 856 Income taxes 252 206 167 271 240 209 Non-cash additions to property, plant and equipment Dividends declared and not paid mi Notes to the Consolidated Financial Statements are an integral part of this statement 218 53 D-8 Appendix D Selected Excerpts from Nike Inc. Form 10-K for the Fiscal Year Ended May 31, 2016 NIKE, Inc. Consolidated Statements of Shareholders' Equity Retained Earnings Total $ 5,620 $ 11,081 445 (2.617) (2.628) (821) (821) 78 177 e (4) (12) 2,693 2,693 (189) $ 4.871 $ 10,824 639 (2,525) (2,534) Capital in Accumulated Common Stock Excess Other Class A Class B of Stated Comprehensive (In millions except per share dato) Shares Amount Shares Amount Valua Income Balance at May 31, 2013 356 5 1,433 $ 3 $ 5,184 S 274 Stock options exercised (1) 22 445 Conversion to Class B Common Stock Repurchase of Class B Common Stock (73) (11) Dividends on common stock ($0.47 per share) Issuance of shares to employees 3 78 Stock-based compensation 177 Forfeiture of shares from employees (8) Not income Other comprehensive income (loss) (189) Balance at May 31, 2014 355 $ 1,385 $ 3 s 5,865 $ 85 Stock options exercised 27 639 Repurchase of Class B Common Stock (58) (9) Dividends on common stock ($0.54 per share) Issuance of shares to employees 92 Stock-based compensation 191 Forfeiture of shares from employees Net Income (5) Other comprehensive income lass) 1,161 Balance at May 31, 2015 355 $ 1,357 $ 3 $ 6,773 $ 1,246 Stock options exercised 680 Conversion to Class B Common Stock (2) 2 Repurchase of Class B Common Stock (55) Dividends on common stock (50.62 (8) per share) Issuance of shares to employees 3 115 Stock-based compensation 236 Forfeiture of shares from employees Net income (10) Other comprehensive income (loss) Balance at May 31, 2016 353 $ (928) 1,329 $ 3 7,786 $ 318 (931) (931) 92 191 (3) (8) 3,273 3.273 1.161 $ 4,685 $ 12,707 680 22 (3.230) (3,238) (1053) (1.053) 115 236 (11) (21) 3.760 3.760 (928) $ 4,151 $ 12,258 The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement