Colorado State University Consolidated Financial Statements Analysis OPTION #1: ASSESSING AND PREPARING CONSOLIDATED FINANCIAL STATEMENTS The first part

Colorado State University Consolidated Financial Statements Analysis OPTION #1: ASSESSING AND PREPARING CONSOLIDATED FINANCIAL STATEMENTS

The first part is a scenario covering the topic of consolidated financial statements. The second part is the preparation of a consolidated financial statement. You will submit both parts separately.

Part 1: Scenario – Written

A new employee has been given responsibility for preparing the consolidated financial statements of Sample Company. After attempting to work alone for some time, the employee seeks assistance in gaining a better overall understanding of the way in which the consolidation process works. You have been asked to assist in explaining the consolidation process. The employee is asking you to respond to the following questions. Please provide full explanations and use examples to support your work.

Why must the eliminating entries be entered in the consolidation worksheet each time consolidated statements are prepared?
How is the beginning-of-period non-controlling interest balance determined?
How is the end-of-period non-controlling interest balance determined? Provide an example.
Which of the subsidiary’s account balances must always be eliminated? Why?
Which of the parent company’s account balances must always be eliminated? Why?

Submission Requirements:

Your responses should be complete, with appropriately cited examples, well written, and in conformity CSU-Global Guide to Writing and APA Requirements (Links to an external site.).
The response should be a minimum of 2 full pages, but should not exceed 3 pages.
Please ensure that you do not use a question-answer format. Please respond to the question, including the question. For example, for question 1, you would begin the writing:
Eliminating entries must be entered in the consolidation worksheet each time the consolidated statements are prepared in order to…
As this assignment has the highest point value of any assignment – complete, detailed entries are necessary to ensure you receive maximum credit.
Each response for above items 1-5 should be no less than one-half page in length.
A FASB reference must be included for at least 3 of the responses.

Part 2: Problem Solving – Consolidated Financials

Assume that on 1/1/X0, a parent company acquires a 70% interest in its subsidiary for a price at $480,000 over book value. The excess is assigned as follows:

Asset Fair Value Useful Life
Patent $320,000 8 years
Goodwill 160,000 Indefinite

70% of the goodwill is allocated to the parent.

Included in the attached Excel spreadsheet are the pre-consolidation financial statements for both the parent and the subsidiary.

Submission Requirements:

Using the ACT470_Mod08-Portfolio_Option01.xlsx Excel spreadsheet in the Module 8 folder:

Prepare the consolidated financial statements at 12/31/X6 by placing the appropriate entries in their respective debit/credit column cells.
Indicate, in the blank column cell to the left of the debit and credit column cells if the entry is a [C], [E], [A], [D] or [I]entry.
Use Excel formulas to derive the Consolidated column amounts and totals.
Using the “Home” key in Excel, go to the “Styles” area and highlight the [C], [E], [A], [D] or [I]entry cells in different shades.
OPTION #2: PARTNERSHIP TRANSACTIONS

Partners in the ABCD Partnership decided to dissolve their partnership. On that date, the partners had the following pre-liquidation capital balances:

Partner A $28,000
Partner B 41,000
Partner C 18,000
Partner D 12,000

A, B, C, and D share residual profits and losses in a 4:3:2:1 ratio.

Liabilities at the date of dissolution total $100,000, and noncash assets equal $105,000. During the first month of liquidation, assets having a book value of $55,000 were sold for $31,000. During the second month, assets having a book value of $32,000, were sold for $28,000. During the third month, the remaining unsold assets were determined to be worthless. The partners receive the maximum allowable payment at the end of each month.

Submission Requirements:

Part 1: Using the ACT470_Mod08-Portfolio_Option02.xls Excel spreadsheet in the Module 8 folder, prepare an installment liquidation schedule along with supporting safe payment schedules.

Part 2: Prepare a PowerPoint presentation to the partners revealing the results of your accounting work. The presentation should include at least 10 slides. Incorporate a visual of the partnership financials into the presentation.

Your responses should be complete, well written, and in conformity with CSU-Global Guide to Writing and APA Requirements (Links to an external site.).

ASSIGNMENT FOR NEXT WEEK:

You have a choice between two Portfolio Projects in this course. Go to the Week 8 Assignment page to read both Portfolio Project descriptions. Select only one project–do not do both projects.

This week, identify your Portfolio Project choice in the title of a Word document and then briefly explain why you selected that project. Review the Portfolio Project Grading Rubric to understand how you will be graded on the project.