hypothetical balance sheets of Nike, Inc. are presented here .

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%.)

b) Prepare a vertical analysis of the balance sheet data for Nike for 2022.

Hypothetical balance sheets of Nike, Inc. are presented here. 2021 NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 Assets Current Assets $9,734 Property, plant, and equipment (net) 1,958 Other assets 1,558 Total assets $13,250 Liabilities and Stockholders' Equity Current Liabilities $3,277 Long-term liabilities 1,280 Stockholders' equity 8,693 Total liabilities and stockholders' equity $13,250 $8,839 1,891 1,713 $12,443 $3,322 1,296 7,825 $12,443 (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.734 $8,839 $ % Property, plant, and equipment (net) 1.958 1,891 % Other assets 1.558 1,713 96 $13,250 $12,443 $ %6 Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity $3,277 $3,322 $ % 1,280 1.296 % 8,693 7,825 % Total liabilities and stockholders' equity $13,250 $12.443 $ (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,734 Property, plant, and equipment (net) 1,958 96 Other assets 1,558 % $13,250 Total assets Liabilities and Stockholders' Equity Current Liabilities $3,277 % Long-term Liabilities 1,280 % Stockholders' equity 8,693 Total liabilities and stockholders' equity $13,250 %