Exercise 13-5 Suppose the comparative balance sheets of Shamrock, Inc. are presented here. SHAMROCK, INC Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Assets Current Assets Property, plant, and equipment (net) other assets Total assets Liabilities and Stockholders' Equity Grrent Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity $9,670 $8,740 1,850 1,590 1,690 $13,160$12.280 1,900 $3,200 $3,320 1,2701,320 7,840 $13,160 $12.280 8690 (a) Prepare a hortzontal analysis of the balance shoot data for Shamrock, using 2016 as a base. (Of amount and percentage are a decroase show the numbers as negative, a.g -55,000, -20 (55,000), (20%), Round percentages to l decimal place, eg. 12.1%) or SHAMROCK, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Tcresse Change from 2016 Assets $9,870 $8,740 1,900 1,850 ,590 1,690 $13,160 $12,280 Current Assets Property, plant, and equipment (net) Other assets Total assets Llabilities and Stockholders' Equity 3,200 $3.320 1,270 1,320 8,690 7,640 $13,160 $12,280 Current Liabilities Long-term lablities Stockholders' equity Total liabilities and stockhoiders' equity b) Prepare a vertical analysis of the balance sheet data for Shamrock for 2017. SHAMROCK, INC. Condensed Balance Sheet $On millions)Percent Assets Current Assets $9,670 1,900 1,590 $13,160 Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity 3,200 1,270 8,690 $13,160 Current Liabilities Long-term Liabilities Stockholders' equity Total liabilities and stockholders equity