+1(323)689-1506 support@essayhubmarket.com

Looking for help with an assignment? Connect with an assignment Expert Now!

Segment Performance Evaluation using a 10K.

Quantitative Application and Global Perspective:  Segment Performance Evaluation using a 10K.

Names and ID #s:   __________________________________ and ____________________________________

In this assignment you will analyze the performance of actual company divisions. Accounting standards requires publicly traded companies to disclose segment information in the notes to the financial statements. You will use Excel to create visually appealing data tables and bar charts to analyze division performance, and then comment on the results.

ALSO, put BOTH of your names on the FILE NAME of your Excel spreadsheet.  In addition, you will need to submit this completed packet.

Followed please see the 10K weblink of Starbucks, which you can use to search segment reporting.

Starkbucks 2016 10K

https://www.sec.gov/Archives/edgar/data/829224/000082922416000083/sbux-1022016x10xk.htm

 

SECTION I

See the 10K (or annual report and 10K) for Fiscal year 2016  for Starbucks.

Locate the Table of Contents in the 10K.   The Table of Contents for all 10Ks follow a standard format.

What is “Item 1” in the 10K Table of Contents? _________________________________

Go to “Item 1”

For Starbucks: read through the subsections of “Item I” that describes “General “and “Segment Information”.  What are the 4 reportable segments (use their abbreviations)? _________________, __________________, ___________________, ____________________________________, 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 II

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.

Add a textbox (“Insert” on menu bar; “Textbox”) and answer the following questions:

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

Comment on the graph:   What stands out to you?

SECTION III

Add a new table somewhere below the first section.  The second data table should have the following column headings:  Division, ROI and Sales Margin.  “Copy” and “paste” the division names into the new table.

For the first company division listed, insert formula commands to calculate ROI and Sales MarginTo 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.

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

Use the “%” on the “Number” section of the menu bar to format the ROI and Sales Margin as percentages.

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.)

Add one textbox for EACH of the following:

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.

Sales Margin:

What does Sales 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 sales margin? Give me an example of a specific action that could be taken to improve sales margin.

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Reviews from Clients who Ordered From Us:

Kate Hogan

They are my go to assignment helper and have been a great help. Thank you!

Sheena easton

I`ve been working with this website for over a year! Here`s what I liked the most about them. First, quality of writing (creative and with catchy titles).

Our Benefits

Get your essay writing needs completed by us and enjoy these and more benefits:

Fast

Whether you have a last minute discussion post due in a couple of hours or the last day in class and you totally forgot to work on that research paper, we always put everything aside to save your grade

Custom Essay

Our qualified team of experts have access to varied online library databases to help with recent and well researched tools that help in writing your paper to deliver a profound research that earns you a stellar grade

80+ Subjects

We do not turn down any type of work. We have qualified writers holding bachelors, graduate and Doctoral certificates matched with skill and expertise. Get help with homework acroos varied subject

Real Time Tracking

We have a user friendly interface to help you track the progress on your order from your client portal. Additionally, with each and every step, you will get notified on the status of your paper to give you an easy time to do other kinds of stuff

Order Our Custom Essay Writing Service

1. Making an Order Tip and Tricks

  • Choose the type of assignment, topic, subject, length, and deadline for your paper.
  • Indicate the following order parameters: service, chosen writer level, number of cited sources, and citation style.
  • Add your document or provide instructions for paper in a specific form.
Image showing step 1 of making an order
Image showing how to make payment for your order

2. Tips and Tricks for Choosing the Right Writer

  • Log in using your email address or your Facebook account.
  • A list of suitable writers will be offered to you. Before making a selection, you can read testimonials or engage in a Live Chat with authors.
  • Check your balance and, if necessary, add funds to your account. Here you will also find exclusive bargains.
  • Put money into the account of the chosen writer.

3. Tips and Tricks for Supervising the Writing Process

  • Get the chance to keep track of the process and connect with your writer.
  • If required, include updated instructions.
  • Have a conversation with your author.
Image showing how to supervise writing process
Image showing how to download your completed results

4. Tips and Tricks to Enjoy the Results

  • You will receive the paper. You have the option of requesting modifications if they are required. Before giving it back to the writer, make a list of the adjustments that need to be made.
  • Accept the paper and send the money to the author.
  • Rate your writer, submit your request, then sit back and enjoy the results.

How can we even make your school life easier with our services?

We always strive to provide the best techniques and skills that help your essay a stellar paper. We have achieved this through the years by offering features such as:

Progressive Delivery

Your order is assigned to a writer who delivere’s your bulk research projects in small chunks and making edits upon feedback from the professor

Native Writers

Our writers are varied across different coutnries such s Canada, Australia, U.K and the United States. Request a native speaker writer to help you ace that paper

Powerpoint slides & other visuals

Order a visual such as Powerpoint to better expound your research paper at $10 per slide including speaker notes

Top rated writers

Order from among the top 10 rated writers at no extra cost