Suppose the comparative balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Assets Current Assets Property, plant, and equipment (net) $9,710 1,940 1,500 $13,150 $8,720 1,870 1,690 Other assets Total assets $12,280 Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities $3,220 1,330 8,600 $3,330 1,380 7,570 Stockholders' equity Total liabilities and stockholders' equity $13,150 $12,280 (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 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%.) (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 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) Increase Percentage 2017 2016 (Decrease) Change from 2016 Assets Current Assets $9,710 $8,720 % $ Property, plant, and equipment (net) 1,940 1,870 % Other assets 1,500 1,690 % Total assets $13,150 $12,280 % $ $ Liabilities and Stockholders' Equity ' Current Liabilities $3,220 $3,330 % $ Long-term liabilities 1,330 1,380 % Stockholders' equity 8,600 7,570 % Total liabilities and stockholders' equity $13,150 $12,280 $ % (b) Prepare a vertical analysis of the balance sheet data for Nike for 2017. (b) Prepare a vertical analysis of the balance sheet data for Nike for 2017. NIKE, INC. Condensed Balance Sheet V $ (in millions) Percent Assets Current Assets $9,710 % Property, plant, and equipment (net) 1,940 % Other assets 1,500 % Total assets $13,150 % Liabilities and Stockholders' Equity Current Liabilities $3,220 % Long-term Liabilities 1,330 % Stockholders' equity 8,600 % Total liabilities and stockholders' equity $13,150 % Click if you would like to Show Work for this question: Open Show Work