(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. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9.600 $8,700 Property, plant, and equipment (net) 2.050 1,840 Other assets 1,540 1,740 Total assets $13,190 $12,280 Liabilities and Stockholders' Equity Current Liabilities $3,220 $3,340 Long-term llabilities 1,300 1.330 Stockholders' equity 8.670 7,610 Total liabilities and stockholders' equity $13.190 $12,280(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%.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Percentage 2027 2021 Increase Change (Decrease) from 2021 Assets Current Assets $9,600 $8,700 Property, plant, and equipment (net) 2.050 1,840 % Other assets 1,540 1,740 Total assets $13,190 $12,280 Liabilities and Stockholders' Equity Current Liabilities $3,220 $3.340 S Long-term liabilities 1,300 1.330 Stockholders' equity 8.670 7.610 Total liabilities and stockholders' $13,190 $12,280 S equityNIKE, INC. Condensed Balance Sheet $ (in millions) Percent Assets Current Assets $9.600 % Property, plant, and equipment (net) 2.050 9% Other assets 1,540 Total assets $13,190 Liabilities and Stockholders' Equity Current Liabilities $3.220 Long-term Liabilities 1,300 Stockholders equity 8.670 Total liabilities and stockholders' equity $13,190 eTextbook and Media