Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with the project,its a managerial accounting case and uses basic excel. Hands-on Learning Project: Segment Performance Evaluation using a 10K. Names and
i need help with the project,its a managerial accounting case and uses basic excel.
Hands-on Learning Project: Segment Performance Evaluation using a 10K. Names and ID #s: __________________________________ and ____________________________________ In this assignment you will analyze the performance of actual company divisions after reading Chapter 11 of our book. 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. You will work in teams of two. If you or your partner feels you did not share equally in the work, email me for a possible grade adjustment. Otherwise, you will both receive the same grade. The report is due by midnight on april 10th. Email your report to me and put BOTH of your names on the FILE NAME of your Excel spreadsheet. In addition, you will need to submit this completed packet SECTION I 1. 2. 3. 4. Google the 2015 10K for either 1) Starbuck, or 2) PepsiCo . CIRCLE the one you are going to analyze. Locate the Table of Contents in the 10K. The Table of Contents is ALWAYS the same for all 10Ks. What is \"Item I\" in the 10K Table of Contents? _________________________________ Go to \"Item 1\" and read through the subsection of \"Item I\" that describes \"Segment Information\" (for Starbucks) or \"Our Operations\" (for Pepsi). Which Note to the Consolidated Financial Statements contains the information about the divisions for Pepsi? Note #_______________ 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\Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started