Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,770 $8,770 Property, plant, and equipment (net) 1,820 1,800 Other assets 1,600 1,740 Total assets $13,190 $12,310 Liabilities and Stockholders' Equity Current Liabilities $3,262 $3,340 Long-term liabilities 1,274 1,380 Stockholders' equity 8,654 7,590 Total liabilities and stockholders' equity $13,190 $12,310 (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%.) Assets NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Increase (Decrease) Percentage Change from 2021 11.2 % % -140 -14.2 % Current Assets $9,770 $8,770 $ 1,000 Property, plant, and equipment 1,820 1,800 20 (net) Other assets 1,600 1,740 Total assets $13,190 $12,310 $ 880 Liabilities and Stockholders' Equity Current Liabilities $3,262 $3,340 $ -78 -2.6 Long-term liabilities 1,274 1,380 -106 -3.1 Stockholders' equity 8,654 7,590 1,064 13.2 Total liabilities and stockholders' equity $13,190 $12,310 $ 880 % % % % olo do olo % (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,770 74.7 % Property, plant, and equipment (net) 1,820 13.6 % Other assets 1,600 12.8 do Total assets $13,190 100.0 % Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities Stockholders' equity $3,262 25 % 1,274 10.1 % 8,654 66.3 % 100.0 % Total liabilities and stockholders' equity $13,190