PepsoCo Financial Analysis Project.
I’m working on a Excel exercise and need support.
The attached assignment provides a framework for general financial analysis.
To help you through the analysis, a sample analysis is also included for you to study.
Pick up a company in the product-based industry (instead of service-based). The market value (cap) has to be less than < 200 billion. To avoid redundant choice, please post your choice on the discussion board.
- Step 1:
Use the following template to work out data collection and ratio calculation.