Answered>Order 6657

1.    Compute the five component ratios of a decomposition of ROE fiscal years 2013-2017 (present your results)

2.    What patterns do you see?

3.    Compute the year-to-year change in Revenues and Operating profit for each of Pepsico’s segments (present your results).

4.    What patterns do you see?

5.    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 (present your results).

7.    What patterns to you see?

8.    Which segment(s) are positively (negatively) influencing Pepsico’s recent performance?

9.    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 shouldcause 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 also included as a “picture.” Be careful in doing so, to insure the accuracy of your inputs.