SECTION I 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 2 Locate the Table of Contents in the 10K The Table of Contents is ALWAYS the same for all 10Ks 3 What is Item 1 in the 10K Table of Contents 4 Go to Item 1 and read through the subsection of Item I that describes Segment Information Which Note to the Consolidated Financial Statements contains the information about the segments for Starbucks Note 5 Go back to the Table of Contents What Item are the Financial Statements What page do the Financial Statements start on The Notes to the financial statements ALWAYS follow immediately after the financial statements They will be marked as Note 1 , etc , in sequential order Go to the financial statements Scroll through the financial statements until you come to the Note on Segment Reporting What page does the Note you are looking for (segment reporting) begin on Skim through the Note until you find the tables that contain the segment data you need to perform ROI and residual income calculations 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 (not include unallocated corporate or the total of all divisions ) Expand column widths as needed 2 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 3 Use Format as a Table or shading to improve the visual look of your data table Play around with the different design options 4 Next, you will be adding a graph to visually display this data 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 5 Add a textbox ( Insert on menu bar Textbox ) and answer the following questions 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 6 Add a 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 7 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 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 as a percentage 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 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 an example of a specific action that could be taken to improve ROI ii Residual Income What does Residual Income tell management Do any 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 Division Evaluation Project Grading Rubric Levels of Achievement Criteria Points Use a 10(K) to find segment data (properly fill out first page) 0 to 5 points Table 1 Proper column headings, data, and formatting 0 to 4 points Graph 1 0 to 5 points Brief description of segments 0 to 4 points Comments about graph 1 0 to 4 points Table 2 Proper calculations and formatting as indicated in the directions 0 to 4 points Graph 2 0 to 5 points ROI questions Define Compare How to improve 0 to 5 points Residual income question Define Which fall short How can you tell 0 to 5 points Allocation of excess funds Explanation of decision 0 to 5 points Assignment is well presented Used proper grammar No spelling or typo errors 0 to 4 points

Question

SECTION I 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 2 Locate the Table of Contents in the 10K The Table of Contents is ALWAYS the same for all 10Ks  3 What is  Item 1  in the 10K Table of Contents                                    4 Go to  Item 1  and read through the subsection of  Item I  that describes  Segment Information  Which Note to the Consolidated Financial Statements contains the information about the segments for Starbucks  Note                   5 Go back to the Table of Contents What  Item    are the Financial Statements            What page do the Financial Statements start on                The Notes to the financial statements ALWAYS follow immediately after the financial statements They will be marked as  Note 1 , etc , in sequential order  Go to the financial statements Scroll through the financial statements until you come to the Note on Segment Reporting What page does the Note you are looking for (segment reporting) begin on              Skim through the Note until you find the tables that contain the segment data you need to perform ROI and residual income calculations  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  (not include  unallocated corporate  or the total of all divisions ) Expand column widths as needed  2 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  3 Use   Format as a Table   or shading to improve the visual look of your data table Play around with the different design options  4 Next, you will be adding a graph to visually display this data  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  5 Add a textbox ( Insert  on menu bar   Textbox ) and answer the following questions  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 6 Add a 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  7 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  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 as a percentage 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  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 an example of a specific action that could be taken to improve ROI  ii  Residual Income  What does Residual Income tell management  Do any 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  Division Evaluation Project   Grading Rubric Levels of Achievement Criteria Points Use a 10(K) to find segment data (properly fill out first page) 0 to 5 points Table 1   Proper column headings, data, and formatting  0 to 4 points Graph 1 0 to 5 points Brief description of segments  0 to 4 points Comments about graph 1 0 to 4 points Table 2   Proper calculations and formatting as indicated in the directions  0 to 4 points Graph 2 0 to 5 points ROI questions   Define  Compare  How to improve 0 to 5 points Residual income question   Define  Which fall short  How can you tell  0 to 5 points Allocation of excess funds  Explanation of decision  0 to 5 points Assignment is well presented  Used proper grammar  No spelling or typo errors  0 to 4 points

Accepted Answer

The Answer is in the image, click to view ...

SECTION I 1.Obtain the 10K for Starbucks for the year ended September 30, 2018.It is available at:

Question:

Entrepreneurship

SECTION I 1.Obtain the 10K for Starbucks for the year ended September 30, 2018.It is available at:

Question:

Expert Answer:

The Answer is in the image, click to view ... View the full answer

Entrepreneurship

Students also viewed these Accounting questions