B C D E F G H 1 J K L M N 0 P Q R Common Size Income statemnet 2016 2015 2014) 2013 Use 2013 as base year calculate the trend index on 2016 Sales Revenue COGS Gross profit 2014 118,364 90,069 28,295 13,326 3,543 311 642 17,822 10,473 Your opinion on the trend index and implications A 1 2 3 Fiscal years ended October 31, 4 Sales revenue 5 Cost of goods sold (COGS) 6 Gross profit 7 SGA 8 R&D 9 Restructuring changes 10 Other operating expenses 11 Total operating expenses 12 Operating income 13 Interest inc (exp) and other 14 Total nonoper rev (exp) 15 Income before income tax 16 Provision for income tax 17 Income from cont oper 18 Nonrecurring items / Mint 19 Net income 20 21 22 23 24 25 2016 126,033 96,089 29.944 12,585 2,959 1,144 1,777 18,465 11,479 505 505 10,974 2.213 8,761 2015 114,552 87,524 27,028 11,613 2,819 640 1,820 16,892 10,136 721 721 9,415 1,755 7,660 2013 104.286 78,887 25,399 12,226 3,611 387 456 16,680 8,719 458 458 9,177 1,913 7.264 2015 2014 2013 Calculate 2016 Gross profit Margin Net profit margin 10,473 2.144 8,329 Your opinion for the differences, also explain the trend 8,761 7,660 8.329 7,264 Are you going to invent in the company? Provide 4 reasons Sheet1 + Ready