1.Obtain the 10K for Starbucks for the year ended September 30, 2018.It is available at: https://www.sec.gov/Archives/edgar/data/829224/000082922418000052/sbux-9302018x10xk.htm

SECTION II

1.In an Excel spreadsheet, set up four column headings:one column for each Division (use their abbreviations).Set up rows for: Assets; Operating Income; Revenue. Input the 2018 data.

2.Next, a graph to visually display this data.for doing 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.

i.Briefly describe the segments.Give some examples of the products or geographical territory.

ii.Comment on the graph:What stands out to you?

SECTION III

3.new table somewhere below the first section.The second data table should have the following column headings:Division, ROI and Residual Income.For the rows "Copy" and "paste" the division names into the new table.

4.For the first company division listed, insert formula commands to calculate ROI and Residual income (assume the company has a 25% 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.

9. the "%" on the "Number" section of the menu bar to format the ROI as a percentage.Format the residual income as a dollar amount.

10. a column graph that compares the ROI of each division.Add a title and size the graph as needed.

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 an example of a specific action that could be taken to improve ROI.

ii.Residual Income:

What does Residual Income tell management?

Does of the divisions fall short of management's expectations?How can you tell?

iii.Allocation decision:

If you were upper management (CEO of the whole corporation), and had excess funds to allocate among divisions, based on the calculations above which division would you allocate those funds to and why? Explain elaborately