I am trying to complete a managerial accounting project. I am looking at Starbucks and Dunkin Brands 10ks. I complete these questions:

DUNKIN BRANDS: Go back to the Table of Contents for the entire 10k.

What are the reportable segments?

What Item # are ALWAYS the Financial Statements in a 10k? ___

What page do they begin on ?__________

Despite what it says, the financial statements begin on page _______.

The Notes to the consolidated financial statements always follow IMMEDIATELY after the financial statements.

What page does your Note about Divisions begin on?__________

Skim through the Note until you find the tables that contain the financial data on the ___ divisions you listed earlier.

1. In an Excel spreadsheet, set up column headings for any two-year data: Division; Operating Income; Revenue. Input the targeted yearly (e.g. 2018 and 2017) data (use division name abbreviations). 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. 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.
5. 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.

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

7. Use the Copy and Paste commands to copy the same formulas into the appropriate cell for each division.
8. Use the % on the Number section of the menu bar to format the Profit Margin as percentages.
9. Add a column graph that compares the Profit Margin of each division. Add a title and size the graph as needed. (Only the graph of the Profit Margin is required. You do NOT need to make graphs of the other ratios.) Profit margin is defined as operating income divided by total revenue.

Required:

1. Spell out the name of your researched company, the rationale why you choose this company and present the weblink of your researched companys 10K in the word file.
2. Import the 2-year data and copy the graph from the spreadsheet and paste on the word document to earn your project credit.

3. Produce several paragraphs in the word file and respond the following questions:
   1. Briefly describe the segments. Give some examples of the products or describe geographical territory.
   2. Comment on the graph: What stands out to you?
   3. Profit Margin:

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

4. Comparing Starbuck financial statements with your researched company ones, do you agree if Starbuck made better financial disclosure on its segment report? Please provide your comparative analysis on the disclosure quality of individual company.

I have completed starbucks, i just need help putting together dunkin. Please let me know how you got that so I can do it again in the future!