Financial Analysis for Pepsico

Using ONLY the data provided in the Word document attached, answer the
questions below.

  • 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?