Reference no: EM132244625 , Length: word count:1600
Assignment -
Instructions: Use ONLY the data provided (in attached file) answers the questions below.
Required -
1. Compute the five component ratios of a decomposition of ROE for Pepsico's 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 in attached file 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.
Attachment:- Assignment File.rar