Prepare consolidation spreadsheet for continuous sale of inventory-Cost method A parent company acquired 100 percent of the stock of a subsidiary company on January 1,2019, for $1,000,000. On this date, the balances of the subsidiary's stockholders' equity accounts were Common Stock, $62,500, Additional Paid-in Capital, $68,750, and Retained Earnings, $243,750. On the acquisition date, the excess was assigned to the following AAP assets: The Goodwill asset has been tested annually for impairment, and has not been found to be impaired. Assume the parent company sells inventory to its wholly owned subsidiary. The subsidiary, 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 a given year is sold to unaffiliated entities outside of the consolidated group during the next year. The parent uses the cost method of pre-consolidation Equity Investment bookkeeping. The financial statements of the parent and its subsidiary for the year ended December 31, 2022, follow: b. Compute the amount of the beginning of year [ADJ] adjustment necessary for the consolidation of the financial statements for the year ended December 31, 2022. Do not use negative signs with your answers below