Part 2: 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.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.