hello i have 12 ratios and percentages for 3 years of nike. i have the balance sheet and income statements for 4 years. i have done all the work and am having issues with return on total assets. also please check my other numbers. not each year but say the most recent year to make sure im getting corrcet numbers from financial statements and such. please take your time im not in a hurry i only want to make sure all ratios and percentages are correct. please and thank you very much

Number 17 =B15-816 F G A B C D E NIKE, INC. Consolidated Statements of Income For years ended MAY 31, 2021 2020,2019,2018(in millions, except per sahre data) Years ended 2021 2020 2019 2018 Revenues S 44,538.00 37403 39117 36397 Cost of Sales $ 24,576 $ 21.162 $ 21643 $ 20,441 Gross Profit 19,982 16241 17474 15 956 0 Demand creation expense 3.1.14 3,592 3.753 3,577 Operating overhead expense 9,911 9,534 8,949 7,934 2Total selling and administrative expense 13,025 13.126 12,702 11,511 Interest expense (income), net 262 89 49 54 Other (income) expense, net 14 139 (78) 66 $ Income before tax expense 6.661 2887 4,801 4,325 6 Income tax expense 934 348 772 2,392 Net Income 5,727 2,539 4,029 1,933 18 20 22 3 G 7 NIKE, INC. 3 4 CONSOLIDATED BALANCE SHEETS As of (MAY 31.) (dollars in millions) 5 6 7 2021 2020 2019 2018 ASSETS: 9 Current assets 10 Cash and cash equivalents 11 Short-term investments 12 Accounts receivable, net Inventoreis 14 Prepaid expenses and other current assets 15 Total current assets Property plant and equipment, net 17 operating lease nght-of-use assets, net 18 Identifiable intangible assets, net 19 Goodwill 20 Deffered income taxes and other assets 21 Total Assets 22 Liabilites and shareholders equity 20 Current Liabilties 24 current portion of long-term debt 2 Notes payable 26 accounts payable z current portion of operating lease liabilities 20 Accured liabilties 29 income tax payable Total current liabilities 11 long-term debt 12 operating lease liabetes S 9,889 $ 8,348 S 4,466 $ 4249 3,587 s 439 $ 197 s 996 4.463 S 2,749 $ 4,272 $ 3,498 6.854 $ 7.367 $ 5,622 S 5,261 1.498 $ 1,653 $ 1,968 $ 1.130 28,291 20,556 16,525 15,134 4.904 4,866 4,744 4,454 3113 3097 0 0 269 274 283 285 242 223 154 154 2,921 2,326 2,011 2,509 S 37 740.00 $ 31 342 00 $ 23 717 00 $ 22.536.00 6 9 2612 SONIDO 0 2 2838 467 6003 306 9674 9413 2931 2955 3 248 2248 445 5184 156 B284 9406 2013 284 5010 229 7886 3464 0 3347 6 336 2279 0 3209 150 6040 3468 0 3216 B D E 242 223 154 154 2,921 2,326 2,011 2,509 $ 37,740.00 $ 31, 342.00 $ 23,717.00 $ 22,536.00 0 2 2836 467 19 Goodwill 20 Deffered income taxes and other assets 21 Total Assets 22 Liabilites and shareholders equity 23 Current Liabilties 24 current portion of long-term debt 25 Noles payable 26 accounts payable 27 current portion of operating lease liabilities 28 Accured habilities 29 income tax payable 30 Total current liabilities 31 long term debt 32 operating lease liabilites 33 deferred income taxes and other habilites 34 Commitments and contigencies (note 18) 35 Redeemable preffered stok 36 shareholders equity 37 common stock at stated value 38 Class A convertible - 305 and 315 shares outstanding 30 Class B-1273 and 1,243 shares outstanding 40 capital in excess of state value 41 accumulated other comprehensive income (loss) 42 Retained earnings (deficit) 43 Total shareholders equity 44 Total Liabilities and shareholders equity 6063 306 9674 9413 2931 2955 3 248 2248 445 5184 156 8284 9406 2913 2684 6 9 2612 0 5010 229 7866 3464 0 3347 6 336 2279 0 3269 150 6040 3468 0 3216 3 3 3 3 9965 8299 7163 6384 380 56 231 -92 3179 191 1643 3517 12767 8055 9040 9812 $ 37,740.00 $ 31,342.00 S 23,717 00 $ 22,536.00 45 15 47 48 49 50 51 Font Paragraph Net Profit Margin Percentage 2021 572744538.00 = 1285 . 1288 x 100 = 12.858 net income/sales 2020 2539 + 37403 = .0678 06788 x 100 = 6.788 2019 4029+39117=1029 1029 x 100 = 10.299 12.86 6.79 10.30 Return on total assets =net income interest expense x{1-tax rate)/average total assets) 2020 348 1 2887 23717 +31342 2539+ (89 2 2021 5727 934 1 - 6661 37740+ 31342 + (262 x 2 2019 1- 4801 4029+(49 x 2371 +22536 2 .65 Return on equity net income/average stockholders equity 2020 2019 2021 =5727/6 3274031342 16.58 Working capital 2021 current assets-current liabilities 2020 20556 - 8284 12272 2019 26291-9674 16525 - 7866 16617 8659 2019 Current ratio 2021 26291/9674 2.72 Current assets/current liabilities 2020 20556/8284 2.48 1652577866 2.10 Acid test (quick) ratio cash marketable securities +accounts receivable / current liabilities 2020 (8348 + 0 + 27497/8284 134 2021 (9889 +04 4463/9674 1.48 TC Acty good to 2019 (4466 +0+ 4272)7866 1.11 OS 2019 26291-9674 20556 - 8284 16617 16525-7866 12272 8659 Current ratio 2021 26291/9674 2.72 Current assets/current liabilities 2020 20556/8284 2.48 2019 16525/7866 2.10 Acid test (quick) ratio =cash+ marketable securities +accounts receivable / current liabilities 2020 (8348 + 0 + 2749)/8284 1.34 2021 (9889 + 0 + 4463)/9674 1.48 2019 =(4466 +0+ 4272)/7866 1.11 Accessibility: Good to go Accounts receivable turnover 2021 4463+2749 44538/6 2 12.35 sales on account/average accounts receivable balance 2020 2749 + 4272 37403/6 2 10.65 2749 4273 2019 4272 +3498 39117/ 2 10.07 Average collection period 2021 =365/accounts receivable turnover 2020 365/10.65 34 365/12.35 2019 =365/10.07 36 30 Inventory turnover 2021 6854 + 7367 24576/6 2 3.46 =COG/average inventory balance 2020 7367 +5622 21162/6 2 3.26 2019 (5622 +5261 21643/C 5261) 3.98 2019 Average sale period 2021 365/3.46 105 =365/inventory turnover 2020 365/3.26 112 365 3.98 92 Debt to equity ratio 2021 =total liabilities/stockholders equity 2020 8284/8055 1.03 2019 9674/12767 7866/9040 .76 87 Times interest earned ratio Earnings before interest expense and income taxes/ interest expense 2020 3115/89 35 2019 2021 6937/262 4772/49 97.39 26.48 play Settings Focus