MENTION URGENT CARE AND WAIT TIME Pepsico Final Ea3-Micasoft Word y,A- E , ? I ?!.la-La . || ,Nemal ‘No saa Headng 1 Heading2 Titte Subtitte Sutte Em. Emenasis intense E- St Required: 1. Compute the five component ratios of a decomposition of ROE for Pepsico’s fiscal years 2013-2017 (present your results) What patterns do you see Compute the year-to-year change in Revenues and Operating profit for each of Pepsico’s 2. 3. segments (present your results). 4. What patterns do you see? . Compute the operating margin for each of Pepsico’s segments (present your results). 6. Compute the year-to-year change in operating margin for each of Pepsico’s segments 7. 8. 9. present your results). What patterns to you see? Which segment(s) are positively (negatively) influencing Pepsico’s recent performance? What does your analysis indicate regarding Pepsico’s future performance? To facilitate your analysis, the data below are inserted into this document as an Excel Objects. The images appear fuzzy but clicking on the data should cause it to open in an Excel spreadsheet. If, however, a spreadsheet does not open, you will have to enter the data manually. The data is The IP 10.27.197.96
