Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,630 $8,710 Property, plant, and equipment (net) 2,000 1,850 Other assets 1,530 1,600 Total assets $13,160 $12,160 Liabilities and Stockholders' Equity Current Liabilities $3,240 $3,330 Long-term liabilities 1,290 1,350 Stockholders' equity 8,630 7.480 Total liabilities and stockholders' equity $13,160 $12,160 2.241 (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, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.5%.) NIKE, INC. Condensed Balance Sheet May 31 Assets ($ in millions) 2022 2021 Increase (Decrease) Percentage Change from 2021 Current Assets $9,630 $8,710 $ 920 10.56 % Property, plant, and equipment 2,000 1,850 150 811 % (net) Other assets 1,530 1,600 70 4.38 % Total assets $13,160 $12.160 $ 1000 1.22 % Liabilities and Stockholders' Equity Current Liabilities $3,240 $3,330 $ 90 -2.70 Long-term liabilities 1,290 1,350 Stockholders' equity 8,630 7,480 1150 Total liabilities and stockholders' $13,160 $12,160 $ 1000 022 equity (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,630 73.20 Property, plant, and equipment (net) 2,000 15.20 % Other assets 1,530 11.60 % Total assets $13,160 100 % Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities $3,240 24.60 1,290 9.80 % Stockholders' equity 8,630 66 % Total liabilities and stockholders' equity $13,160 100 % MacBook Pro