So picture one is the assignment and Section 1 is done. Section 2, is where I need help in how to begin the steps. Second picture is the part I have completed(Does the data come from third pic? If so what numbers are inputted where? In the column names, Americas-Channel Development are the segments mentioned in Section I, Question 4. So what numbers is my prof asking to be inputted there in question 2?
SECTIONI 1. See the 10K (or annual report and 10K) for Fiscal year 2016 for Starbucks. 2. Locate the Table of Contents in the 10K. The Table of Contents for all 10Ks follow a standard format. 3. What is "ltem 1" in the 10K Table of Contents? 4. Go to "tem 1" i. For Starbucks: read through the subsections of "item I" that describes "General "and "Segment Information". What are the 4 reportable segments (use their abbreviations]?L plus Make a mental note about what each segment sells and how they sell (distribution mechanism). Which "Note to the consolidated financial statements" contains segment reporting information? Note # STARBUCKS: Go back to the Table of Contents for the entire 10k. what item # are ALWAYS the Financial Statements in a 10k?--what page contains the index for Notes to the financial Statements? --GO to the index. 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 5 segments you listed earlier. SECTION I In an Excel spreadsheet, set up four column headings: Division; Assets; Operating Income; Revenue. Input the 2016 data (use division name abbreviations). (Do not include the total of all divisions.) Expand column widths as needed 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 Use "Format as a Table" or shading to improve the visual look of your data table. Play around with the different design options. 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. 1. 2. 3. 4. 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 describe geographical territory. Home Layout Tables Charts SmartArt Formulas Edit FillCalibri (Body) 12 AA Paste B2 1 Divisions Assets Operating Income Revenue Americas 3 CAP 4 EMEA 5 Channel Development 6 8 9 10 13 15 Information by geographic arca (in millions): ul Year E Net revenues United States Other countries Total Oct 2, 2016 Sep 27, 2015 Sep 28, 2014 15,774.8 S 5,541.1 21,315.9 S 14,123.7 $ 5,039.0 19,162.7 $ 12,590.6 3,857.2 16,447.8 Long-lived assets' United States Other countries Total 6,027.2 S 3,541.8 9,569.0 S 5,805.4$ 2,639.9 8,445.3 $ 5,450.9 1,449.7 6,900.6 Long-lived assets as of September 27, 2015 and Scptember 28, 2014 have been adjusted for the adoption of new accounting guidance related to the reclassification of deferred income taxes as discussed in Note 1, Summary of Significant Accounting Policies. No customer accounts for 0% or more of our revenues even es are shown based on he geographic ocation of our customers. Revenues rom countres o the U.K., which together account for approximately 77% of net revenues from other countries for fiscal 2016. er han he US. consist primarily of revenues rom apan, Canada, China and Management evaluates the performance of its operating segments based on net revenues and operating income. The accounting policies of the operating segments are the same as those described in Note 1, Summary of Significant Accounting Policies. Operating income represents earnings before other income and expenses and income taxes. Management does not evaluate the performance of its operating segments using asset measures. The identifiable assets by scgment disclosed in this note are those assets specifically identifiable within cach segment and include cash and cash equivalents, net property, plant and equipment, equity and cost investments, goodwill, and other intangible assets. Assets not attributed to reportable operating segments below are corporate assets and are primarily comprised of cash and cash equivalents available for general corporate purposes, investments, assets of the corporate headquarters and roasting facilities, and inventory
