1 Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Assets 2022 2021 Current Assets $9,550 $8,880 Property, plant, and equipment (net) 2,050 1,840 Other assets 1,480 1,780 Total assets $13,080 $12,500 Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity $3,230 $3,330 1,270 1,370 8.580 7.800 Total assets Liabilities and Stockholders' Equity $13,080 $12,500 Current Liabilities $3,230 $3,330 Long-term liabilities 1.270 1,370 Stockholders' equity 8,580 7,800 Total liabilities and stockholders' equity $13,080 $12,500 (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) (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) Assets 2022 2021 Percentage Increase (Decrease) Change from 2021 Current Assets $9,550 $8,880 $ % Property, plant, and equipment 2,050 1,840 % (net) Other assets 1,480 1,780 Total assets $13,080 $12,500 $ % S (net) 2,050 1,840 Other assets 1,480 1,780 Total assets Liabilities and Stockholders' $13,080 $12,500 $ % Equity Current Liabilities: $3,230 $3.330 $ Long-term liabilities 1,270 1.370 Stockholders' equity 8,580 7,800 Total liabilities and stockholders' $13,080 $12,500 $ equity (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. SUPP Assets Current Assets NIKE, INC. Condensed Balance Sheet Property, plant, and equipment (net) Other assets Total assets $ (in millions) Percent Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities $9,550 2,050 1,480 $13,080 de % % de de % de % $3,230 % 1,270 % Current Assets $9,550 Property, plant, and equipment (net) 2,050 Other assets 1,480 Total assets. Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities Stockholders' equity $13,080 $3,230 1,270 de % de % de % de % de % de % 8,580 % Total liabilities and stockholders' equity $13,080 de %