I have an excel spreadsheet that will be given to whoever takes the assignment that you will work off/
Assume that a parent company acquired 100% of a subsidiary on 1/1/X1. The purchase price was $175,000 in excess of the subsidiary’s book value of net assets on acquisition date and the excess was assigned entirely to an unrecorded patent. The life of the patent is 10 years.
Assume the subsidiary sells inventory to the parent. The parent ultimately sells the inventory to outside customers. The following relates to the years X2 and X3:
| Inventory Sales | GP of unsold inventory | Receivable (Payable) | |
| X3 | $103,300 | $29,441 | $41,320 |
| X2 | $87,900 | $19,137 | $27,986 |
The financial statements for the parent and subsidiary for the year ended 12/31/X3 are attached in the Excel spreadsheet.
Submission Requirements:
ACT470_Mod04-Option01.xlsx Excel spreadsheet in the Module 4 folder:
- Prepare the consolidated financial statements at 12/31/X3 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.
- Review the grading rubric following this assignment, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
