The Holtz Corporation acquired 80 percent of the 100,000 outstanding voting shares of Devine, Inc., for $7.30 per share on January 1, 2020. The remaining 20 percent of Devines shares also traded actively at $7.30 per share before and after Holtzs acquisition. An appraisal made on that date determined that all book values appropriately reflected the fair values of Devines underlying accounts except that a building with a 5-year future life was undervalued by $64,500 and a fully amortized trademark with an estimated 10-year remaining life had a $84,000 fair value. At the acquisition date, Devine reported common stock of $100,000 and a retained earnings balance of $333,500.

Following are the separate financial statements for the year ending December 31, 2021:

At year-end, there were no intra-entity receivables or payables.

Prepare a worksheet to consolidate these two companies as of December 31, 2021.

HOLTZ CORPORATION AND DEVINE, INC. Consolidation Worksheet For Year Ending December 31, 2021