Please answer problem #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 $ 9,640 $ 8,720 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 % Property, plant, and equipment (net) 2,010 1.840 170 9.2 96 Other assets 1.450 1.730 % $ Total assets $ 810 6.6 96 13,100 12.290 Liabilities and Stockholders' Equity Current Liabilities $ 3.340 $ $ 26 3,240 Long-term liabilities 1.265 1,340 % Stockholders' equity 8,595 7.610 985 129 96 Total liabilities and stockholders equity $ 13,100 $ 12,290 810 6.6 % (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 % de Property, plant, and equipment (net) 2,010 15.3 % se Other assets 1.450 11.1 se Total assets $ 13,100 100.0 % Liabilities and Stockholders' Equity Current Liabilities $3,240 24.7 % Long-term Liabilities 1,265 9.7 % Stockholders' equity 8,595 65.6 % Total liabilities and stockholders' equity $ 13,100 100.0 de %