Hello, I need formulas explaining the answers, thank you.Please calculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on the trend. Please do the following ratios:NIKE, Inc. Consolidated Balance Sheets1. Horizontal analysis for sales and Account receivable, comment on your answer -- good news or bad news2. Calculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on the trend.May 31,3. Activity Ratio --- Account Receivable (Turnover Ratio and Days to Collect) for 2 years(In millions)201820174. Activity Ratio --- Inventory (Turnover Ratio and Days to Collect for 2 yearsASSETSCurrent assets:Cash and equivalents4,249 $3,808NIKE, Inc. Consolidated Statements of IncomeShort-term investments9962,371Accounts receivable, net3,4983,677Inventories5,2615,055Prepaid expenses and other current assets1,1301,150Total current assets15,13416.061Year Ended May 31.Property, plant and equipment, net4,4543,989(In millions, except per share data)201820172016Identifiable intangible assets, net285283Goodwill154139Revenues36,397 $34,350%2432,376Deferred income taxes and other assets2,5092.787Cost of sales20,44119.03817.405TOTAL ASSETSLIABILITIES AND SHAREHOLDERS' EQUITY22,53623,259Gross profit15,95615,31214,971Current liabilities:Demand creation expense3,5773,3413.278Current portion of long-term debt6 SOperating overhead expense7,9347,2227,191Notes payable325336Accounts payable2,2792.048Total seling and administrative expense11,51110,56310,469Accrued liabilities3,2693,011Interest expense (income), net545919Income taxes payable1508466Total current liabilitiesOther expense (income), net(196)6,0405,474(140)Long-term debt3,4683,471Income before income taxes4,3254,8864,623Deferred income taxes and other liabilities3,2161,907Income tax expense2.392646863Commitments and contingencies (Note 15)Redeemable preferred stockNET INCOME1,933 $4,240 S3,760Shareholders' equity:Common stock at stated value:Class A convertible - 329 and 329 shares outstandingEamings per common share:Class B-1,272 and 1,314 shares outstanding3.3Basic1.19 $2.56 S221Capital in excess of stated value6,3845,7105,710Diluted241.17 $2.51 $2.16Accumulated other comprehensive loss(92)(213)Retained earningsTotal shareholders' equity3,5176.9079,81212,407Dividends declared per common share0.70 S22,5360.78 $0.62TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY23,259The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement.The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement.

Name: Hello, I need formulas explaining the answers, thank you.Please calcul
Uploaded: 2022-11-18T00:26:54.000Z
Channel: Bartleby
Description: Hello, I need formulas explaining the answers, thank you.Please calculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on the trend. Please do the following ratios:NIKE, Inc. Consolidated Balance Sheets1. Horizontal

Formula's: Current Ratio = Current Assets / Current liabilities Quick Ratio = Quick Assets / Current…

Business

Accounting

NIKE, Inc. Consolidated Balance Sheets Piease do the following ratios: 1. Horizontal analysis for sales and Account receivable, comment on your answer- good news or bad news 2. Calculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on the trend. 3. Activity Ratio -- Account Receivable (Turnover Ratio and Days to Collect) for 2 years 4. Activity Ratio - Inventory (Turnover Ratio and Days to Collect for 2 years May 31. nion 2018 2017 ASSETS Cument asses Cash and equivalents 4249 S 3808 NIKE, Inc. Consolidated Statements of Income Shoteminestmert 2371 Accounts recelvable, net 34 3677 Inventories 5.21 5.05 Prepaid expenses and other oument assets 1,130 1,150 Total oument assets 15,134 16.061 Year Ended May 31, Property, plant and equipment, net 4,454 3.90 (in millions, except per share data) 2018 2017 2016 Identfable intangble assets, net 25 283 Goodwill 154 139 Revenues 36,397 34,350 $ 32.376 Delemed income taves and other assets 2.509 2.787 Cost of sales 20,441 19.038 17.405 TOTAL ASSETS LIABILITES AND SHAREHOLDERS EQUITY 22.534 S 23.259 Gross proft 15,956 15.312 14.971 Cument lables Demand creation expense 3,577 3.341 3.278 Cument portion of longterm debt Operating overhead expense 7.934 7.222 7,191 Ntes payable 336 325 Accourts payable 2.279 2048 Total selling and administrative expense 11,511 10.563 10,469 Acoued labiles 3.209 3,011 Interest expense (income), net 54 59 19 Income taes payable 150 84 Oher expense (ncome), net Income before income taxes 66 (196) (140) Total curent lablites 6,040 5474 Longm de 3,48 3471 4,325 4,886 4,623 Defemed income taes and oher lablites 3.216 1.907 Income tax expense 2.392 646 863 Commitments and contingencies (Note 15 Redeemable prefered stock NET INCOME 1,933 4,240 S 3,760 Sharholdersuty Common stock at stated valu Cass A conventle-329 and 329 shares outstanding Eamings per common share: Class-1272 and 1314 shares outstanding Capitalin ecess of stated value Basic 1.19 $ 2.56 S 221 6.34 5.710 Diluted 1.17 S 2.51 $ 2.16 Accumulated other comprehensive loss 213 Retained eamings 6.907 3.517 Total shareholders equity 9.812 12.407 Dividends declared per common share TOTAL LIABLITIES AND SHAREHOLDERS EQUITY The accompanying Notesohe Consolidated Financia Statements are an integral part of ths statement 0.78 $ 0.70 $ 0.62 22.534 23.259 The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement.