Please answer peoblem #7 on ALL PARTS NOT ANSWERED SHOWING ALL WORK ACCORDINGLY. Thank you!

Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $ 8.720 9.640 Property, plant, and equipment (net) 2,010 1,840 Other assets 1,450 1.730 Total assets $ 13,100 $ 12,290 Liabilities and Stockholders' Equity Current Liabilities $ 3,240 $ 3,340 Long-term liabilities 1,265 1,340 Stockholders' equity 8,595 7,610 Total liabilities and stockholders' equity $ 13,100 $ 12.290 (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). (20%). 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 2021 Assets Current Assets $ 9,640 $ 8.720 $ 920 10.6 96 % Property, plant, and equipment (net) 2,010 1,840 170 9.2 22 %6 Other assets 1.450 1.730 96 Total assets $ 13,100 . $ 12,290 $ 810 6.6 % Liabilities and Stockholders' Equity Current Liabilities $ 3,240 $ 3,340 $ 96 Long-term liabilities 1.265 1.340 %6 Stockholders' equity 8,595 7.610 985 12.9 % Total liabilities and stockholders' equity $ 12,290 $ B10 6.6 96 % 13,100 (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,640 73.6 % 2,010 15.3 Property, plant, and equipment (net) se % 1.450 Other assets 11.1 de $ 13,100 100.0 Total assets de % Liabilities and Stockholders' Equity $3,240 24.7 % de Current Liabilities 1,265 9.7 % Long-term Liabilities 8,595 65.6 % Stockholders' equity $ 13,100 100.0 % Total liabilities and stockholders' equity se