advanced financial accounting problem

You received (one member of each group) together with this cover sheet the two problem outside assignment for your group. Please distribute to fellow group members. Here are some VERY significant notes for you to achieve full credit of 15 points.

1. Your assignment must be turned in two formats. First submit a printed hard copy of the completed work to me. Second, submit via email the excel spreadsheet and any word documents of your completed work. Also, please submit a copy of the question sheet with your hard copy. It helps me keep track of things.

2. Part of the assignment goal is for you to complete both problems using excel spreadsheet techniques. So substantial points with be lost by merely entering numbers into the spreadsheet. I am looking for formulas on the spreadsheet and readability. Pretend I am your boss. If your presentation is not readable, you lose points.

3. Part of the assignment asks you to complete an income statement and balance sheet in PROPER FORM. Check your form vs. any public company annual report or examples in the book.

4. Problem 2 will require you to create a consolidation worksheet that is expanded from the 5 column one used in the book. I count on your intelligence to figure this out.

5. While each group has similar problems, each problem is different with subtle changes that will make it obvious to me when one group has copied another’s template. So don’t! You will lose lots of points.

6. Of the 15 point assignment, I will allocate 10 points toward the first problem and 5 points toward the second problem