Excel template below.

a) Using Excel, compute consolidated balances for Innovus and ChipTech. I NEED TO SEE THE FORMULAS IN EXCEL SO I CAN PUT INTO MY SPREADSHEET PLEASE.

On January 1,2020 , Innovus, Inc., acquired 100 percent of the common stock of ChipTech Company for $670,000 in cash and other fair-value consideration. ChipTech's fair value was allocated among its net assets as follows: Fair value of consideration transferred for ChipTech Book value of ChipTech: 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 $670,000 $130,000 370,000 $40,000 80,000 170,000500,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): On January 1,2020 , Innovus, Inc., acquired 100 percent of the common stock of ChipTech Company for $670,000 in cash and other fair-value consideration. ChipTech's fair value was allocated among its net assets as follows: Fair value of consideration transferred for ChipTech Book value of ChipTech: 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 $670,000 $130,000 370,000 $40,000 80,000 170,000500,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)