Page 150 EXCEL CASE 1 CPA On January 1, 2017, 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 Fair value of consideration transferred for Chip Tech Book value of Chip Tech: Common stock and Additional Paid-In Capital (APIC) $130,000 Retained earnings 370,000 Excess fair value over book value to Trademark (10-year remaining life) $ 40,000 Existing technology (5-year remaining life) 80,000 Goodwill 500.000 170,000 120.000 $ 50,000 The December 31, 2018, trial balances for the parent and subsidiary follow there were no intra-entity payables on that date): $ Revenues Cost of goods sold Depreciation expense Amortization expense Dividend income Nel income Innovus Chip Tech (990,000) $ (210,000) 500,000 90.000 100,000 5.000 55,000 18.000 (40,000) 0 (375.000) $ (97.000) Net income Retained earnings 1/1/18 Net income Dividends declared Retained earnings 12/31/18 Current assets Investment in Chip Tech Equipment (net) Trademark Existing technology Goodwill Total assets Liabilities Common stock Additional paid-in capital Retained earnings 12/31/18 Total liabilities and equity $ (375,000) $ (1,555,000) (375,000) 250,000 $ (1,680,000) 960,000 670,000 765,000 235,000 $ (97,000) $ (450.000) (97,000) 40,000 $ (507,000) $ 355,000 225,000 100,000 45,000 450,000 $ 3.080,000 (780,000) (500,000) (120,000) (1.680.000) S (3.080,000) $ 725.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 2018 impairment loss for the entire amount of goodwill from the Chip Tech acquisition