working on Mondelez International Inc. CI A and Hewlett package enterprise Co here is the task:

4. Obtain industry averages for each firm and a. Compare each firms ratios to the available industry ratios for the most recent year. (Ignore the Company column as your calculations will be different.) b. Analyze the performance of each firm versus the industry and comment on any trends in each individual firms performance. Identify any strengths or weaknesses you find in each firm. ll

B D E F 1 VALUATION RATIOS industry 28,45 2 3 P/E Ratio (TTM) 4 P/E High - Last 5 Yrs. 5 P/E Low - Last 5 Yrs. MDLZ, 2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 42,22 23,141 17,56 20,78 co Na industry MDLZ,2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 -5,25 -4,74 -8,97 8 Market-book ratio 4,52 9 10 11 PROFITABILITY RATIOS industry 12 13 Operating margin Operating margin. 5 years 14 avg MDLZ.2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 0,0327 0,0781 0,09980, 1098 industry 15 16 17 Net profit margine Net profit margine, 5 18 years aya MDLZ, 2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 0,06 0,11 0,13 0.15 industry 20 21 Return on equity MDLZ,2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 0,07 0,11 0,13 22 23 FINANCIAL STRENGTH 24 RATIOS 25 26 Current ratio industry MDLZ, 2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 0,59 0.48 0,45 0,50 27 28 29 Book debt-equity ratio industry MDLZ,2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 -3,68 -2.78 -2,63 -3,02 30 31 32 Interest coverage ratio industry MDLZ 2016 MDLZ, 2017 MDLZ, 2018 MDLZ, 2019 4.83 -2.80 8.77 8.10 33 34 35