On January 1, 2020, Innovus, Inc., acquired 100 percent of the common stock of Chip Tech Company for $670,000 in cash and other fair- value consideration. Chip Tech's fair value was allocated among its net assets as follows: $670,000 $130,000 370,000 Fair value of consideration transferred for Chip Tech Book value of Chip Tech: Common stock and Additional Paid-In Capital (APIC) Retained earnings Excess fair value over book value to Trademark (10-year remaining life) Existing technology (5-year remaining life) Goodwill 500,000 170,000 $ 40,000 80,000 120,000 $ 50,000 The December 31, 2021, trial balances for the parent and subsidiary follow (there were no intra-entity payables on that date): Innovus Revenues Cost of goods sold Depreciation expense Amortization expense Dividend income Net income $ (990,000) 500,000 100,000 55,000 (40,000) $ (375,000) Chip Tech $(210,000) 90,000 5,000 18,000 -0- $ (97,000) Retained earnings 1/1/21 Net income Dividends declared Retained earnings 12/31/21 $(1,555,000) (375,000 250,000 $(1,680,000) $(450,000) (97,000) 40,000 $(507,000) $ 355,000 Current assets Investment in Chip Tech Equipment (net) Trademark Existing technology Goodwill Total assets $ 960,000 670,000 765,000 235.000 -0- 450,000 $ 3,080,000 225,000 100,000 45,000 -0- $ 725,000 (88,000) Liabilities $ (780,000) Liabilities Common stock Additional paid-in capital Retained earnings 12/31/21 Total liabilities and equity $ (780,000) (500,000) (120,000) (1,680,000) $(3,080,000) (88,000) (100,000) (30,000) (507,000) $(725,000) Required a. Using Excel, compute consolidated balances for Innovus and Chip Tech. Either use a worksheet approach or compute the balances directly. b. Prepare a second spreadsheet that shows a 2021 impairment loss for the entire amount of goodwill from the Chip Tech acquisition