NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9.680 $8.760 Property, plant, and equipment (net) 2.040 1.830 Other assets 1,490 1.640 $13.210 $12.230 $3,267 $3,310 Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity 1.276 1.370 8,667 7.550 $13.210 $12.230 (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.680 $8.760 $ 920 10.5 2,040 1,830 210 115 Property, plant, and equipment (net) Other assets 1.490 1.640 -150 -9.1 Total assets $13.210 $12.230 $ 980 8 96 Liabilities and Stockholders' Equity Current Liabilities $3.267 $3,310 $ 95 Long-term liabilities 1.276 1,370 Stockholders' equity 8.667 7.550 96 Total liabilities and stockholders equity $13.210 $12.230 $ (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Increase (Decrease) Percentage Change from 2021 Assets Current Assets $9.680 $8.760 $ 920 10.5 Property, plant, and equipment (net) 2.040 1.830 210 115 96 Other assets 1,490 1.640 -150 -9.1 Total assets $13.210 $12,230 $ 980 8 Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities $3.267 $3.310 $ 1.276 1,370 Stockholders' equity 8.667 7.550 96 Total liabilities and stockholders equity $13.210 $12.230 S (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.680 96 Property, plant, and equipment (net) 2,040 95 Other assets 1,490 95 Total assets $13.210 96 Liabilities and Stockholders' Equity Current Liabilities $3.267 96 Long-term Liabilities 1.276 95 Stockholders' equity 8,667 96 Total liabilities and stockholders' equity $13.210 96