Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,800 $8,760 Property, plant, and equipment (net) 1,970 1,800 Other assets 1,550 1,770 Total assets $13,320 $12,330 Liabilities and Stockholders' Equity Current Liabilities $3,294 $3,320 Long-term liabilities 1.287 1,350 Stockholders' equity 8,739 7,660 Total liabilities and stockholders' equity $13,320 $12,330 (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, e.g. 12.5%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,800 $8,760 $ Property, plant, and equipment 1,970 1,800 (net) Other assets Total assets Liabilities and Stockholders' Increase (Decrease) Percentage Change from 2021 % % 1,550 1,770 % $13,320 $12,330 $ % Equity Current Liabilities $3,294 $3,320 $ Long-term liabilities 1,287 1,350 Stockholders' equity 8,739 7,660 Total liabilities and stockholders' equity $13,320 $12,330 $ **** % (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. Condensed Balance Sheet Assets Current Assets Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities Stockholders' equity $ (in millions) Percent $9,800 % 1,970. % 1,550 % $13,320 $3,294 % 1,287 % 8,739 % Total liabilities and stockholders' equity $13,320 %