Please answer problem #6, SHOWING ALL WORK ACCORDINGLY ON ALL PARTS. 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,580 $ 8,770 Property, plant, and equipment (net) 1,810 1,800 Other assets 1,540 1,670 Total assets $ 12,930 $ 12,240 Liabilities and Stockholders' Equity Current Liabilities $ 3,150 $ 3,320 Long-term liabilities 1,320 1,370 Stockholders' equity 8,460 7,550 Total liabilities and stockholders' equity $ 12,930 $ 12,240 (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.580 $ 8,770 $ 96 1,810 Property, plant, and equipment (net) 1,800 96 Other assets 1,540 1.670 $ 12.930 Total assets $ 12,240 $ Liabilities and Stockholders' Equity $ 96 Current Liabilities 3,150 3,320 % 1,320 1,370 Long-term liabilities % 8,460 7.550 Stockholders' equity $ % Total liabilities and stockholders' equity 12,930 12,240 (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,580 % Property, plant, and equipment (net) 1,810 % Other assets 1,540 % Total assets $ 12,930 %6 Liabilities and Stockholders' Equity Current Liabilities $3,150 % Long-term Liabilities 1,320 % Stockholders' equity 8,460 % Total liabilities and stockholders' equity $ 12,930 % de