Please answer problem #7 parts A and B, SHOWING ALL WORK ACCORDINGLY ON ALL PARTS. Thank you!

Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $ 9,640 $ 8,720 Property, plant, and equipment (net) 2,010 1,840 Other assets 1,450 1,730 Total assets $ 13,100 $ 12,290 Liabilities and Stockholders' Equity Current Liabilities $ 3,240 $ 3,340 Long-term liabilities 1,265 1,340 Stockholders' equity 8,595 7,610 Total liabilities and stockholders' equity $ 13,100 $ 12,290 (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-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 $ 8.720 $ 96 9.640 Property, plant, and equipment (net) 2,010 1.840 96 Other assets 1.450 1,730 % Total assets $ 13,100 $ 12.290 $ 38 Liabilities and Stockholders' Equity Current Liabilities $ 3,240 3.340 Long-term labilities 1,265 1,340 Stockholders' equity 8,595 7,610 % Total liabilities and stockholders equity $ 13,100 $ 12.290 $ 96 (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,640 % se Property, plant, and equipment (net) 2,010 % Other assets 1.450 de Total assets $ 13,100 % de Liabilities and Stockholders' Equity Current Liabilities $3,240 de Long-term Liabilities 1,265 % Stockholders' equity 8,595 % Total liabilities and stockholders' equity $ 13,100 % se