(a) Prepare a horizontal analysis of the balance sheet data for Shamrock, using 2019 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.1%.)

Note: Assets and Liabilities don't add up to the same value but I was told to answer as-is.

Suppose the comparative balance sheets of Shamrock, Inc. are presented here. 2019 SHAMROCK, INC. Condensed Balance Sheet May 31 ($ in millions) 2020 Assets Current Assets $9,600 Property, plant, and equipment (net) 2,810 Other assets 1.580 Total assets $13.990 Liabilities and Stockholders' Equity Current Liabilities $3.170 Long-term liabilities 1,230 Stockholders' equity 8.590 Total liabilities and stockholders' equity $13.990 $8,790 1,800 1,710 $12.300 $3.300 1,390 7.610 $12,300 SHAMROCK, INC. Condensed Balance Sheet May 31 ($ in millions) Increase (Decrease) Percentage Change from 2019 2020 2019 $9,600 $8.790 $ % Assets Current Assets Property, plant, and equipment (net) Other assets 2,810 1,800 % 1,580 1.710 $13.990 $12.300 $ % $3,170 $3,300 $ % Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity 1.230 1,390 % 8.590 7.610 % $13,990 $12.300 $ % (b) Prepare a vertical analysis of the balance sheet data for Nike for 2020. SHAMROCK, INC. Condensed Balance Sheet $ (in millions) Percent Assets Current Assets $9.600 % 2,810 se Property, plant, and equipment (net) Other assets 1,580 % $13.990 % Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term Liabilities Stockholders' equity $3.170 % 1.230 % 8.590 % Total liabilities and stockholders' equity $13,990 %