Consolidated worksheet

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:

Using Excel, compute consolidated balances for Innovus and ChipTech by completing the provided worksheet.