Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,880 $8.810 Property, plant, and equipment (net) 1,940 1.830 Other assets 1,580 1.700 Total assets $13.400 $12,340 Liabilities and Stockholders' Equity Current Liabilities $3,300 $3,390 Long-term liabilities 1.350 1.450 Stockholders' equity 8.750 7.500 Total liabilities and stockholders' equity $13,400 $12,340 (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) Percentage Increase 2022 (Decrease) Change from 2021 Assets Current Assets $9,880 $8,810 12.1 Property, plant, and 1,940 6.0 equipment (net) Other assets 1.580 (120) 2021 $ 1070 1.830 110 1.700 -7.1 % $13,400 $12.340 1060 8.6 $3,300 $3,390 $ 90 26.7 % Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity 1,350 1.450 100 4.7 8.750 7.500 (1250) 12.9 % $13.400 $12,340 $ 1060 8.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.880 71.4 % 1.940 14.8 % 1.580 13.8 $13.400 100 % Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities Stockholders' equity Total liabilities and stockholders' equity $3,300 26.7 1.350 10.5 % 8.750 62.8 $13,400 100