Hypothetical balance sheets of Nike, Inc. are presented here NIKE, INC. Condensed Balance Sheet May 31 (s in millions) 2022 2021 Assets Current Assets $9.520 $8,800 Property, plant, and equipment (net) 1.990 1,810 Other assets 1.590 1,610 Total assets $13,100 $12.220 Liabilities and Stockholders' Equity Current Liabilities $3,220 $3,380 Long-term liabilities 1.260 1.340 Stockholders' equity 8,620 7.500 Total liabilities and stockholders' equity $13,100 $12,220 8.18 9.94 (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, es 12.5%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Percentage 2022 Increase 2021 Change (Decrease) from 2021 Assets Current Assets $9,520 $8.800 $ 720 % Property, plant, and 1.990 1.810 180 equipment (net) % Other assets 1.590 1.610 -1.24 %6 Total assets $13,100 $12,220 880 7.37 Liabilities and Stockholders' Equity Current Liabilities $3,220 $3,380 $ 160 -4.73 Long-term liabilities 1.260 1.340 -5.97 % Stockholders' equity 8,620 7.500 1120 14.93 Total liabilities and $13.100 $12.220 880 7.20 stockholders' equity 96 % -80 % $ %6 (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. Condensed Balance Sheet May 31, 2022 $ (in millions) Percent Assets Current Assets $9,520 212.5 de Property, plant, and equipment (net) 1,990 % Other assets 1,590 % $13,100 % Total assets Liabilities and Stockholders' Equity Current Liabilities $3,220 % Long-term Liabilities 1,260 % Stockholders' equity 8,620 % Total liabilities and stockholders' equity $13,100 %