Google the 10K (or annual report and 10K) for Fiscal year 2022 for Starbucks

SECTION III

6. Add a new table somewhere below the first section. The second data table should have the following column headings: Division, ROI, Profit Margin, Asset Turnover, and Residual Income. Copy and paste the division names into the new table.

7. For the first company division listed, insert formula commands to calculate ROI, Profit Margin, Asset Turnover, and Residual income (assume the company has a 20% target rate of return). To insert formulas, highlight the cell where you want to place the answer. Then, for example, type in =B2/B3 to divide the figure in cell B2 by the figure in cell B3.

8. Use the Copy and Paste commands to copy the same formulas into the appropriate cell for each division.

9. Use the % on the Number section of the menu bar to format the ROI and Profit Margin as percentages. Use the decimal remove button to decrease the number of decimals on the Asset Turnover statistic (two decimal should be sufficient). Format the Asset Turnover as a plain number. Format the residual income as a dollar amount.

10. Add a column graph that compares the ROI of each division. Add a title and size the graph as needed. (Only the graph of the ROI is required. You do NOT need to make graphs of the other ratios.)

11. Add one textbox for EACH of the following: i. ROI: What does ROI 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 ROI? Give me an example of a specific action that could be taken to improve ROI. ii. 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. iii. Asset Turnover: What does Asset Turnover tell management? Which divisions have the best and worst? How do they compare? How could a division of this company improve its asset turnover? Give me an example of a specific action that could be taken to improve asset turnover. iv. Residual Income: What does Residual Income tell management? Do any of the divisions fall short of managements expectations? How can you tell? v. Allocation decision: If you were upper management (CEO of the whole corporation), and had excess funds to allocate among divisions, which division would you allocate those funds to and why? Grading Rubric Name: