Current Attempt in Progress Hypothetical balance sheets of Nike, Inc. are presented here NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,600 Property, plant, and equipment (net) $8,730 1.830 1.910 Other assets 1.470 1,620 Total assets $12,980 $12,180 Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities $3,210 1.254 Stockholders' equity Total liabilities and stockholders' equity $3,370 1,330 _7.480 $12,180 8.516 $12,980 (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. Of amount and percentage are a decrease show the numbers as negative, es.-55,000, -20% or (55,0001. (20%). Round percentages to 1 decimal place, s. 12.5%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Increase (Decrease) Percentage Change strictinstructure.com/courses/68067/assignments/922409 (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, eg.-55,000, -20% or (55,000). (2096). Round percentages to 1 decimal place, eg. 12.5%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Increase (Decrease) Percentage Change from 2016 Assets Current Assets $9,600 1.910 $8,730 $ 1,830 Property, plant, and equipment (net) R RR 1.470 1.620 Other assets $12.980 $12,180 $ Total assets Liabilities and Stockholders' Equity $3.210 $ Current Liabilities $3,370 1.330 1.254 Long-term liabilities 8,516 7.480 Stockholders' equity Total liabilities and stockholders' $12.980 $12.180S equity (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. Condensed Balance Sheet Percent $(in millions) (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022 NIKE, INC. Condensed Balance Sheet $ (in millions) Percent Assets Current Assets $9,600 Property, plant, and equipment (net) 1.910 Other assets 1.470 Total assets $12.980 Liabilities and Stockholders' Equity Current Liabilities $3.210 1.254 Long-term Liabilities 8.516 Stockholders' equity $12.980 Total liabilities and stockholders' equity