CALCULATOR ES tv Exercise 9-5 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 $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,250 $3,340 Long-term abilities 1,290 1,340 Stockholders' equity 8,560 7,610 Total liabilities and stockholders equity $13,100 $12,290 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, c.9. -55,000, -20% or (55,000). (20%). Round percentages to 1 decimal place, e.g. 12.29.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Percentage Increase Change 2017 2016 (Decrease) from 2016 Assets Current Assets $9,640 58,720 $ Property, plant, and equipment (net) 2,010 1,840 Other assets 1.450 1,730 RCES t1 study Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 as a base. (ar 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.2%) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Percentage Increase Change 2017 2016 (Decrease) from 2016 Assets Current Assets $9.640 $5,720 Property, plant, and copmart (net) 2,010 1,840 Otherwise 1,450 1,730 $13,100 $12,290 Total assets Liabilities and Stockholders' Equity Current Liabilities $3,250 $3,340 1,290 Long-term ilities 1,340 3.560 Stockholders' equity 7,610 Total sabates and stockholders' equity $13,100 $12,290 LINK TO TENT 2. nadimallace, ca. 12.1. Prepare a vertical analysis of the balance sheet data for Nike for 2017. (Round percentages to I decimal place, e.g. 12.1%.) NIKE, INC. Condensed Balance Sheet $ (in millions) Percent Assets Current Assets $9,640 % Property, plant, and equipment (net) 2,010 % Other assets 1,450 % $13,100 % Total assets Liabilities and Stockholders' Equity Current Liabilities $3,250 % 1,290 9% Long-term Liabilities Stockholders' equity 8,560 % $13,100 Total liabilities and stockholders' equity % Click if you would like to Show Work for this question: Open Show Work