Hello, I need formulas explaining the answers, thank you.Horizontal analysis for sales and Account receivable, comment on your answer -- good news or bad newsCalculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on the trend.Activity Ratio --- Account Receivable (Turnover Ratio and Days to Collect) for 2 yearsActivity Ratio --- Inventory (Turnover Ratio and Days to Collect for 2 years 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.Horizontal an
Uploaded: 2022-11-18T00:26:54.000Z
Channel: Bartleby
Description: Hello, I need formulas explaining the answers, thank you.Horizontal analysis for sales and Account receivable, comment on your answer -- good news or bad newsCalculate the Current Ratio (for two years) and the Quick Ratio (for two years), comment on

It is the review of the financial statement of any organization over multiple periods. It shows the…

Business

Accounting

NIKE, Inc. Consolidated Balance Sheets Piease do the following ratios: 1. Horizontal analysis for sales and Acount 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 lon 2018 2017 ASSETS Cument asset Cash and eguvalents 4249 S NIKE, Inc. Consolidated Statements of Income Shatmiestnents 2371 Accourts ecalvale net 34 3677 Iventories 5.261 5.065 Prepaid expenses and other oument assets 1,130 1,150 Year Ended May 31,. Total ourent asets 15,134 16.061 Property. plantand ement et 4454 3. (in millions, except per share data) 2018 2017 2016 Identifable intangble assets, net 283 Goodel 154 139 Revenues 36,397 $ 34,350 32.376 Delemed inceme taes and other assets 2.509 2.787 Cost of sales 19.038 20,441 17,405 TOTAL ASSETS 22.534 S 23.20 Gross proft 15,956 15,312 14,971 LIABILITES AND SHAREHOLDERS EQUITY Curent labes Demand creation expense 3,577 3.341 3.278 Cument porton of long term debt Operating overhead expense Total selling and administrative expense 7.934 7.222 7,191 Notes payable 336 325 Accounts payable 2.279 2.048 11,511 10.563 10,469 Acoved labes 3.20 3.011 Interest expense (income), net 54 59 19 Income tas payable 150 Total curent labltes Oher expense (income), net 66 (196) 6.040 5474 (140) Longerm debt 3,48 3471 Income before income taxes 4,325 4,886 4,623 Defemed income taes and oher labites 3.26 1907 Income tax expense NET INCOME 2,392 646 863 Commitments and contingences Note 15 Redeemable prefered stock Sharholders equit 1,933 %24 4.240 S 3,760 y Common stok at sated valu Class A convenble-329 and 329 shares outstanding Cass-1272 and 1314 shares outtanding Capitalin ecess of stated value Accumulated ofher comprehensive loss Eamings per common share Basic 1.19 2.56 S 221 6.34 5.710 Diuted 1.17 2.51 $ 2.16 213) Retained eamings 6.907 Total shareholders equity 12407 Dividends declared per common share The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement. 0.78 0.70 $ 0.62 TOTAL LIABILITIES AND SHAREHOLDERS EQUITY 22.534 23.259 The accompanying Notesohe Consolidated Financial Statements are an integral part of this statement