Can you work up a consolidation worksheet for 2021?

House Corporation has been operating profitably since its creation in 1960. At the beginning of 2019, House acquired a 70 percent ownership in Wilson Company. At the acquisition date, House prepared the following fair-value allocation schedule:

House regularly buys inventory from Wilson at a markup of 25 percent more than cost. House's purchases during 2019 and 2020 and related ending inventory balances follow:

On January 1, 2021, House and Wilson acted together as co-acquirers of 80 percent of Cuddy Company's outstanding common stock. The total price of these shares was $292,800, indicating neither goodwill nor other specific fair-value allocations. Each company put up one-half of the consideration transferred. During 2021, House acquired additional inventory from Wilson at a price of $234,000. Of this merchandise, 45 percent is still held at year-end. Following are the financial records for the three companies for 2021.

Note: Parentheses indicate a credit balance.

Prepare a consolidation worksheet for 2021. The partial equity method based onseparate company incomes has been applied to each investment.(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.)

Beginning Intra-entity Gross Profit (Wilson)	$ 53,750		$ 53,750
January 1, 2021 inventory balance	0.25		$ 43,000
	1.00		$ 10,750
	$ 43,000
Ending Intra-entity Gross Profit (Wilson)	$ 105,300		$ 105,300
December 31, 2021 inventory balance	0.25		$ 84,240
	1.00		$ 21,060
	$ 84,240
Entry *G (Wilson)	$ 10,750
	70%
	$ 7,525
Entry *C (house)	$ 7,525	Subtract the residual value of the asset from its original value. Divide that number by the asset's lifespan.
	$ ?
	$ 11,305
		Debit	Credit
Retained earnings (1/1/21) (Wilson)		$ 10,750
Cost of goods sold			$ 10,750
Retained earnings, 1/1/21 (House)		$ 11,305
Investment in Wilson			$ 11,305
Common stock (cuddy)		$ 150,000
Retained earnings (1/1/21) (Cuddy)		$ 216,000
Investment in Cuddy (80%)			$ 292,800
Noncontrolling Interest in Cuddy Common Stock (20%)			$ 73,200
Common stock (Wilson)		$ 310,000
Retained earnings (1/1/21) (Wilson)		$ 659,250
Investment in Wilson (70%)			$ 678,475
Noncontrolling Interest in Wilson (30%)			$ 290,775
Buildings		$ ?
Franchise contract		$ 44,800
Goodwill		$ 151,800
Equipment			$ 11,900
Investment in Wilson			$?
Noncontrolling interest in Wilson			$?
Income of Cuddy		$ 61,520
Investment in Cuddy			$ 61,520
Income of Wilson		$ 124,768
Investment in Wilson			$ 124,768
Investment in Cuddy		$ 48,000
Dividends declared (80%) (Cuddy)			$ 48,000
Investment in Wilson		$ 67,200
Dividends declared (70%) (Wilson)			$ 67,200
Operating expenses		$ 2,700
Equipment		$ 5,950			To record 2021 amortization on excess payment made in connection with acquisition of Wilson Copany
Franchise contracts			$ 5,600
Buildings			$ 3,050
Sales and other revenues		$ 234,000
Cost of goods sold			$ 234,000
Cost of goods sold		$ 21,060
Inventory			$ 21,060
Reported net income			$ 76,900
Outside ownership			20%
Noncontrolling interest in Cuddy net income			$ 15,380
Reported operating income			$ 178,240
Equity income of Cuddy (76,900*40)			$ 30,760
Excess amortization			$ (2,700)
Recognition of 2020 gross profit (Entry *G)			$ 10,750
Deferral of 2021 intra-entity gross profit (Entry G)			$ (21,060)
Accrual-based net income			$ 195,990
Outside ownership			30%
Noncontrolling interest in net income of Wilson			$ 58,797