Question

In this assignment you will analyze the performance of actual company divisions. FASB ASC 280 (formerly...

In this assignment you will analyze the performance of actual company divisions. FASB ASC 280 (formerly SFAS 131) 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.   

Due Date: Tuesday, May 1, 2018.   Submit as an attachment in Blackboard in the Module 24 Assignment.

SECTION I

The link is to the Starbucks 10K and apparently too big to upload. I really need help, thank you.

Obtain the 2017 10K for Starbucks. It is available at: http://d18rn0p25nwr6d.cloudfront.net/CIK-0000829224/f8c7bf9b-da8f-4ebd-bd2b-55f4abaa08fe.pdf

Locate the Table of Contents in the 10K.   The Table of Contents is ALWAYS the same for all 10Ks.

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

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 #_______________.

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

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 2017 data. (Do not include “unallocated corporate” or 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 Tableor 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 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 Residual Income. For the rows “Copy” and “paste” the division names into the new table.

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.

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 as a percentage. Format the residual income as a dollar amount.

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

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

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, which division would you allocate those funds to and why?

Homework Answers

Answer #1

Item 1 in Table of Content - Business

Which Note to the Consolidated Financial Statements contains the information about the segments for Starbucks? Note 16.

What “Item #” are the Financial Statements? Item 8

What page do the Financial Statements start on? Page 46

What page does the Note you are looking for (segment reporting) begin on? Page 82

If management has to allocate more funds then by assessing busines potential and prospect I would invest/allocate the funds in following preference;

1. Channel Partner

2. Americas

3. CAP

4. EMEA

Here the important analysis needs to be done that even CP is giving highest ROI but does it requires any amount of additional investments.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Based on your review of the financial statements, would you invest in this company? Why or...
Based on your review of the financial statements, would you invest in this company? Why or why not? Detail your decision-making process.Based on your review of the financial statements, would you invest in this company? Why or why not? Detail your decision-making process. From the Table of Contents, select Financial Statements and Supplementary Data. Use the (Consolidated) Income Statement to answer the following: What was the company’s total sales revenue for the most recent year? What was their cost of...
Quick Company's segments its company into four distinct divisions. The net revenues, operating profit, and total...
Quick Company's segments its company into four distinct divisions. The net revenues, operating profit, and total assets for these divisions are disclosed in the footnotes to Quick Company?'s consolidated financial statements and the following presented? information: Net Revenue Operating Profit 2017 2016 2015 2017 2016 2015 Home furnishings $10,250 $9,150 $8,750 $2,460 $2,185 $1,635 office furniture 8,750 7,850 7,550 1,575 1,395 1,335 store displays 12,750 11,550 11,050 1,785 1,645 1,585 health care furnishings 1,500 1,350 1,250 495 470 450 Total...
Using the financial statements for the fiscal year 2015 you will analyze the performance of each...
Using the financial statements for the fiscal year 2015 you will analyze the performance of each toy company individually and also compare the performance of the two companies against each other. You will perform your analyses by answering the 13 questions on page 2. Answers to the 13 questions must be provided on pages 3 and 4 and submitted by the due date. Show all calculations for your answers on an attachment to your answer sheets. No partial credit can...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your cursor over "Filings" in the menu bar across the top 3. click on "company filings search" that pops up when you hover 4. in the FAST SEARCH box on the far right type in "AEO" for the ticker and click "search" for American Eagle. For Buckle type in "BKE". 5. in the "filings" column on the far left look for the most recent "10-K"...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your cursor over "Filings" in the menu bar across the top 3. click on "company filings search" that pops up when you hover 4. in the FAST SEARCH box on the far right type in "AEO" for the ticker and click "search" for American Eagle. For Buckle type in "BKE". 5. in the "filings" column on the far left look for the most recent "10-K"...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year   Assets   Current assets:      Cash $ 930,000     $ 1,170,000          Marketable securities 0     300,000          Accounts receivable, net...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year   Assets   Current assets:      Cash $ 820,000     $ 1,250,000          Marketable securities 0     300,000          Accounts receivable, net...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your...
1. go to www.sec.gov (Links to an external site.)Links to an external site. 2. Hover your cursor over "Filings" in the menu bar across the top 3. click on "company filings search" that pops up when you hover 4. in the FAST SEARCH box on the far right type in "AEO" for the ticker and click "search" for American Eagle. For Buckle type in "BKE". 5. in the "filings" column on the far left look for the most recent "10-K"...
Kersten Brown, the CEO of Pleasanton Studios, is having a tough week – all three of...
Kersten Brown, the CEO of Pleasanton Studios, is having a tough week – all three of her top management level employees have dropped in with problems. One executive is making questionable decisions, another is threatening to quit, and the third is reporting losses (again). Kersten is hoping to find simple answers to all her difficulties. She is asking you (her accountant) for some advice on how to proceed. Pleasanton Studios owns and operates three decentralized divisions: Entertainment, Streaming, and Parks....
Kersten Brown, the CEO of Pleasanton Studios, is having a tough week – all three of...
Kersten Brown, the CEO of Pleasanton Studios, is having a tough week – all three of her top management level employees have dropped in with problems. One executive is making questionable decisions, another is threatening to quit, and the third is reporting losses (again). Kersten is hoping to find simple answers to all her difficulties. She is asking you (her accountant) for some advice on how to proceed. Pleasanton Studios owns and operates three decentralized divisions: Entertainment, Streaming, and Parks....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT