Please help me solve this problem: Prepare a worksheet to consolidate these two companies as of December $31,2024.$

Note: For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Input all amounts as positive values.

Show less $4$

HOLTZ CORPORATION AND DEVINE, INCORPORATED

Consolidation Worksheet

$\backslash$table$[[$For Year Ending December $31,2024],[$Accounts$,\backslash$table$[[$Holtz$],[$Corporation$]],\backslash$table$[[$Devine$],[$Incorporated$]],$Consolidation Entries,$\backslash$table$[[$Noncontrolling$],[$Interest$]],\backslash$table$[[$Consolidated$],[$Totals$]]],[$Debit$,$Credit$],[$Cost of goods sold,$249,000,177,000,,,,],[$Operating expenses,$287,000,128,250,,,,],[$Consolidated net income$],[$Net income attributable to noncontrolling interest$],[$Net income attributable to Holtz Corporation$],[$Retained earnings, $1/1/24,$$$,(753,000),$$$(324,000),,,,],[$Current assets,$$,147,000,$$$186,000,,,,],[$Investment in Devine, Incorporated,$544,000,0,,,,],[$Buildings and equipment $($net$),900,000,405,000,,,,],[$Trademarks$,147,000,145,000,,,,],[$Goodwill$,0,0,,,,],[$Total assets,$$1,738,000,$$$736,000,,,,],[$Liabilities$,$$$,(514,000),$$$(228,000),,,,],[$Common stock,$(320,000),(100,000),,,,],[$Retained earnings, $12/31/24($above$),(904,000),(408,000),,,,]]$ Prepare a $2024$ consolidated income statement for Holtz and Devine.

Note: Enter all amounts as positive values.

HOLTZ CORPORATION AND DEVINE, INCORPORATED

Consolidated Income Statement

For Year Ending December $31,2024$ If instead the noncontrolling interest shares of Devine had traded for $$5\mathrm{.}19$ surrounding Holtz's acquisition date, what is the

impact on goodwill?The Holtz Corporation acquired $80$ percent of the $100,000$ outstanding voting shares of Devine, Incorporated, for $$6\mathrm{.}80$ per share on

January $1,2023.$ The remaining $20$ percent of Devine's shares also traded actively at $$6\mathrm{.}80$ per share before and after Holtz's

acquisition. An appraisal made on that date determined that all book values appropriately reflected the fair values of Devine's

underlying accounts except that a building with a $5-$year future life was undervalued by $$84,000$ and a fully amortized trademark with

an estimated $10-$year remaining life had a $$81,000$ fair value. At the acquisition date, Devine reported common stock of $$100,000$ and a

retained earnings balance of $$254,000.$

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

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

Required:

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

b$.$ Prepare a $2024$ consolidated income statement for Holtz and Devine.

c$.$ If instead the noncontrolling interest shares of Devine had traded for $$5\mathrm{.}19$ surrounding Holtz's acquisition date, what is the impact

on goodwill?