Computational Problems 15.1 PGJ is a large producer of food products. In 2018, the percentage breakdown of revenues and profits was as follows: Profits (5) Food service-other Revenues (%) 12 100 6 100 Revenues (%) 41 28 Packaged foods Coffee Processed meat Profils (%) 62 19 per- International operations account for about 22 cent of sales and 17 percent of operating profit. For the 2014-2018 fiscal years, the number of shares out- standing (in millions) and selected income statement data were (in millions of dollars) as follows: 19 13 Shares Outst. 49.93 49.97 49.43 19.45 51.92 Year 2014 2015 2016 2017 2018 Revenues $5,472 5,960 6,601 8,351 8,256 Oper. Inc. $524 534 565 Cap. Exp. $121 262 187 Deprec. $77 78 89 Int. Exp. $31 39 50 152 139 Net Income Before Tax After Tax $452 $232 470 256 473 255 418 221 535 289 694 283 266 131 139 721 Year 2014 2015 2016 2017 2018 Cash $291 178 309 165 Assets $1,736 1.951 2,019 2,254 2,315 Current Liabilities $845 1,017 929 1,215 1,342 Long-Term Debt $251 255 Total Assets $2,565 2,978 3,103 3,861 4,310 Common Equity $1,321 1,480 1,610 1,626 1.872 891 731 285 736 419 Spreadsheet Exercises (c) On the basis of these calculations, evaluate the current health of PGJ and the changes over the period. For each year calculate: (a) Operating income as a percent of revenue, net profit as a percent of revenue (net profit margin). EBIT, and profit per share outstanding (EPS). (b) Current ratio, long-term debt to equity, book value of equity per share, ROE, ROA, leverage total asset turnover, and operating efficiency