SECTION I 1. Indicate the name of the targeted company you are going to analyze. The targeted company's segments must have operating income, revenue and assets in each division. Please provide the weblink of its 2019 10-K: (I have confirmed that Amazon (AMZN), Walmart (WMT) and FedEx (FDX) 2019 10-ks have data needed). 2. Locate the Table of Contents in the 10-K. The Table of Contents for all 10-Ks follow a standard format 3. What is "Item 1" in the 10-K Table of Contents? 4. Go to "Item 1" i. Read through the subsections of "Item I" that describes "General" and "Segment Information". What are the reportable segments (use their abbreviations)? 5. Go back to the Table of Contents for the entire 10-K. i. What Item # are the Financial Statements in a 10-K? Item ii. The Notes to the Financial Statements ALWAYS follow immediately after the financial statements. Which "Note to the consolidated financial statements contains segment reporting information? Note # iii. What page does your Note about Segments begin on? Go to that page. Skim through the Note until you find the tables that contain the financial data for the segments you listed earlier SECTION II 1. In an Excel spreadsheet, set up column headings for: Division; Assets; Operating Income; Revenue. (Note: some companies present those accounts balance in multiple tables). 2. Input the 2019 data (use division name abbreviations). (Only include the divisions you listed in Section 1). Expand column widths as needed. 1 3. Use the "Number" section of the menu bar to format the data as "currency" (dollar signs and commas). Use the Decrease decimal button to delete unnecessary decimals. 4. Use "Format as a Table to improve the visual look of your data table. Play around with the different design options. 5. 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. Choose an appropriate layout from those available. Add a title to your chart. Expand the chart size if needed. 6. Add a new table somewhere below the first section in the same spreadsheet. The second table should have the following column headings: Division, Profit margin, and ROI. "Copy" and "paste" the division names into the new table. 7. For each division listed, insert formula commands to calculate Profit margin and ROI. -Profit margin is defined as operating income divided by revenue. - ROI is defined as operating income divided by assets. 8. Use the "%" on the Number" section of the menu bar to format the ROI and Profit margin as percentages. 9. Add a column graph that compares the Profit margin of each division. Add a title and size the graph as needed. (Only the graph of the Profit margin is required.) Required: 1. Complete Section I. 2. Import the segment data from the targeted company's 10-Ks, copy the tables and graphs from the spreadsheet and paste on the word document to earn your project credit. 3. Produce several paragraphs in the word file and respond the following questions: i. Briefly describe the segments. Give some examples of the products or describe geographical territory. ii. Comment on the first graph. What stands out to you? iii. Profit Margin: What does Profit Margin tell management? Which divisions have the best and worst or are they roughly the same? How do they compare? How could a division of this company improve its Profit Margin? Give an example of a specific action that could be taken to improve Profit Margin. 4. When comparing Starbucks financial statements with your targeted research company, do you agree if Starbuck made better financial disclosure on its segment report? Please provide your comparative analysis on the disclosure quality of Starbucks and your targeted research company. SECTION I 1. Indicate the name of the targeted company you are going to analyze. The targeted company's segments must have operating income, revenue and assets in each division. Please provide the weblink of its 2019 10-K: (I have confirmed that Amazon (AMZN), Walmart (WMT) and FedEx (FDX) 2019 10-ks have data needed). 2. Locate the Table of Contents in the 10-K. The Table of Contents for all 10-Ks follow a standard format 3. What is "Item 1" in the 10-K Table of Contents? 4. Go to "Item 1" i. Read through the subsections of "Item I" that describes "General" and "Segment Information". What are the reportable segments (use their abbreviations)? 5. Go back to the Table of Contents for the entire 10-K. i. What Item # are the Financial Statements in a 10-K? Item ii. The Notes to the Financial Statements ALWAYS follow immediately after the financial statements. Which "Note to the consolidated financial statements contains segment reporting information? Note # iii. What page does your Note about Segments begin on? Go to that page. Skim through the Note until you find the tables that contain the financial data for the segments you listed earlier SECTION II 1. In an Excel spreadsheet, set up column headings for: Division; Assets; Operating Income; Revenue. (Note: some companies present those accounts balance in multiple tables). 2. Input the 2019 data (use division name abbreviations). (Only include the divisions you listed in Section 1). Expand column widths as needed. 1 3. Use the "Number" section of the menu bar to format the data as "currency" (dollar signs and commas). Use the Decrease decimal button to delete unnecessary decimals. 4. Use "Format as a Table to improve the visual look of your data table. Play around with the different design options. 5. 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. Choose an appropriate layout from those available. Add a title to your chart. Expand the chart size if needed. 6. Add a new table somewhere below the first section in the same spreadsheet. The second table should have the following column headings: Division, Profit margin, and ROI. "Copy" and "paste" the division names into the new table. 7. For each division listed, insert formula commands to calculate Profit margin and ROI. -Profit margin is defined as operating income divided by revenue. - ROI is defined as operating income divided by assets. 8. Use the "%" on the Number" section of the menu bar to format the ROI and Profit margin as percentages. 9. Add a column graph that compares the Profit margin of each division. Add a title and size the graph as needed. (Only the graph of the Profit margin is required.) Required: 1. Complete Section I. 2. Import the segment data from the targeted company's 10-Ks, copy the tables and graphs from the spreadsheet and paste on the word document to earn your project credit. 3. Produce several paragraphs in the word file and respond the following questions: i. Briefly describe the segments. Give some examples of the products or describe geographical territory. ii. Comment on the first graph. What stands out to you? iii. Profit Margin: What does Profit Margin tell management? Which divisions have the best and worst or are they roughly the same? How do they compare? How could a division of this company improve its Profit Margin? Give an example of a specific action that could be taken to improve Profit Margin. 4. When comparing Starbucks financial statements with your targeted research company, do you agree if Starbuck made better financial disclosure on its segment report? Please provide your comparative analysis on the disclosure quality of Starbucks and your targeted research company