Suppose the hypothetical comparative condensed balance sheets of Nike, Inc. are presented here. 2021 NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 Assets Current Assets $9.500 Property, plant, and equipment (net) 1,900 Other assets 1,450 Total assets $12,850 Liabilities and Stockholders' Equity Current Liabilities $3,150 Long-term liabilities 1,200 Stockholders' equity 8,500 Total liabilities and stockholders' equity $12,850 $8,700 1,800 1,600 $12,100 $3,300 1,290 7,510 $12,100 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.2%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Percentage Increase Change 2021 (Decrease) from 2021 Assets Current Assets $9.500 $8,700 $ 9.2 Property, plant, and 1.900 1,800 96 equipment (net) Other assets 1.450 1,600 2022 800 DR 100 5.6 - 150 -9.4 Total assets $12,850 $12,100 $ 750 6.2 % Liabilities and Stockholders' Equity Current Liabilities $3,150 $3,300 $ -150 -4.5 % Long-term liabilities 1,200 1,290 -90 -7.0 % Stockholders' equity 8,500 7,510 990 13.2 96 Total liabilities and stockholders' equity $12,850 $12,100 $ 750 62 Prepare a vertical analysis of the balance sheet data for Nike for 2022. (Round percentages to 1 decimal place, eg. 12.1%) NIKE, INC. Condensed Balance Sheet For the Year Ended May 31, 2022 May 31, 2022 For the Month Ended May 31, 2022 Percent Assets Current Assets $9,500 % Property, plant, and equipment (net) 1,900 % % Other assets 1,450 $12,850 % Total assets Liabilities and Stockholders' Equity Current Liabilities $3,150 % Long-term Liabilities 1,200 96 Stockholders' equity 8,500 % $12,850 Total liabilities and stockholders' equity %