The December 31,2023 , trial balances of Albert Corporation and its 70%-owned subsidiary Magnus Corporation are as follows: Albert's investment in Magnus was purchased for $1,260,000 on 1/1/22. The cost method was used. On 1/1/22, Magnus had the following equity balances: Albert's excess of cost over book value on Magnus's investment has been identified as goodwill. Magnus borrowed $100,000 from Albert on June 30,2023 , with the note maturing on June 30,2024 , at 10% interest. Correct accruals have been recorded by both companies. During 2023, Albert sold merchandise to Magnus at an aggregate invoice price of $300,000, which included a profit of $75,000. As of December 31, 2023, Magnus had not paid Albert for $90,000 of these purchases, and 10% of the total merchandise purchased from Albert still remained in Magnus's inventory. Magnus declared a $1,000 cash dividend in December 2023 payable in January 2024. Prepare the worksheet required to produce the consolidated statements of Albert Corporation and its subsidiary, Magnus Corporation, for the year ended December 31, 2023. Directions: 1) Prepare the consolidated worksheet for Albert and Magnus as of December 31, 2023. 2) Prepare all elimination entries