SECTION I Background Data 1. Google the 2022 10K for PepsiCo. 2. Locate the Table of Contents in the 10K. The Table of Contents is ALWAYS the same for all 10Ks. (Hint: Use Control F and type in Table of Contents.) 3. Go to Item 1 in the 10K Table of Contents and read through the subsection of Item I that describes Business. Look for Our Operations on this page. Review the list of segments (subdivisions) on pages 2 and 3 and review their descriptions on pages 3 and 4. 4. Go back to the Table of Contents. Find the item listing the Financial Statements. The Notes to the financial statements ALWAYS follow immediately after the financial statements. They will be marked as Note 1, etc., in sequential order. NOTE: Despite what it says, the financial statements actually start on page 60 (they have an error in their table of contents). Go to Note 1 (following the financial statements). Skim through the Note until you find the tables that contain the segment data you need to perform ROI, margin, and residual income calculations. You will need to reference multiple tables to find the data you need. SECTION II 1. Open a new Excel spreadsheet and set up four column headings: Division Name; Assets; Operating Profit/(Loss); Net Revenue. Expand column widths as needed. 2. Save the Excel spreadsheet with the name Project 3 Your Name. 3. List the seven division names using their abbreviations. 4. Input the 2022 data for each segment. (Do not include corporate unallocated or the total of all divisions.) 5. Use the Number section of the menu bar to format the data as currency (dollar signs and commas). Use the decimal remove button to delete unnecessary decimals. 6. Use Format as a Table or shading to improve the visual look of your data table. Play around with the different design options. 7. Next, you will be adding a graph to visually display this data. To do this, highlight the entire table. Then click on the insert tab on the menu bar. Then click on the Column chart. (Depending on your version of Excel, you might need to click on Recommended Charts. Choose an appropriate layout from those available. Add the title Segment Data to your chart. Expand the chart size if needed. 8. Add a textbox (Insert on menu bar; Textbox) and answer the following questions: i. Briefly describe each of the segments AND give some examples of the products or geographical territory. (Remember pages 2, 3 and 4 from above.) ii. Comment on the graph: What stands out to you?

PLEASE ANSWER THE QUESTIONS FROM SECTION II