I have a template need to fill out:

Part 1: Preliminary work:

Acquisition price:

Book Value: CS:

APIC:

RE:

Excess:

Acquisition Entry:

Equity Investment

CS

APIC

Part 2: Sub income:

Add Realized Profit:

Less Deferred Profit:

Less Patent Amort:

Equity Income:

Please provide a T account for Equity Income

Part 3: Common Stock:

Investment at BOY:

Investment at BOY: (explain this one)

Part 4: [C], [E], [A], [D], [I]

Part 5: Please provide a Consolidation spreadsheet

I need to fill out the template above, please help me, I would love to give you a big LIKE LIKE LIKE if the answer are correct and able to completed my 5 parts template. Thank you.

1. Prepare consolidation spreadsheet for continuous sale of inventory-Equity method Assume a parent company acquired 100% of a subsidiary on January 1, 2018. The purchase price was $360,000 in excess of the subsidiary's book value of Stockholders' Equity on the acquisition date, and $270,000 of that excess was assigned to an unrecorded Patent owned by the subsidiary. On January 1, 2018 , the Patent has a 10 -year estimated remaining useful life. The remaining $90,000 was assigned to Goodwill. Assume the wholly owned subsidiary sells inventory to the parent. The parent, ultimately, sells the inventory to customers outside of the consolidated group. You have compiled the following data for the years ending 2021 and 2022: The inventory not remaining at the end of the year has been sold to unaffiliated entities outside of the consolidated group. The parent uses the equity method to account for its Equity Investment. The financial statements of the parent and its subsidiary for the year ended December 31, 2022, follow: a. Show the computation to yield the pre-consolidation $51,300 Income (loss) from subsidiary reported by the parent for the year ended December 31, 2022. b. Show the computation to yield the $714,600 pre-consolidation Equity Investment account balance reported by the parent at December 31, 2022. c. Prepare the consolidation entries for the year ended December 31, 2022. d. Prepare the consolidation spreadsheet for the year ended December 31, 2022