Prepare the consolidation spreadsheet. Questions a and b are already answered. Below is the infomation needed for the spreadsheet.

opic: Consolidation Subsequent to Date of Acquisition; Downstream Intercompany Inventory Sale - Equity Method Assume that, on January 1, 2019, a parent company acquired a 70% interest in its subsidiary for a purchase price that was $400,000 over the book value of the subsidiary's Stockholders' Equity on the acquisition date. The parent uses the equity method to account for its investment in the subsidiary. The parent assigned the acquisition-date AAP as follows: Assume that the parent sells inventory to the subsidiary (downstream) which includes that inventory in products that it, ultimately, sells to customers outside of the controlled group. You have compiled the following data as of 2021 and 2022 : The inventory not remaining at the end of the year has been sold outside of the controlled group. The parent and the subsidiary report the following financial statements at December 31,2022 : Required: a. Compute the EOY Equity Investment balance of $892,350/4 years subsequent to the acquisition). b. Compute the EOY noncontroling interest equity balance. c. Prepare the consolidation spreadsheet