Pratt Company acquired all of the outstanding shares of Spider, Inc., on December 31, 2021, for...

Preparation of Consolidated Balance Sheet $ 4,88,900 $ -2,87,500 $ 2,01,400 Calculation of Goodwill: Consideration transferred at fair value Less : Book Value of Net asset acquired Excess consideration over book value Excess would be allocated to below assets and liabilities computer software equipment client contracts in process research and development notes payable $ 40,750 $ -10,100 $ 1,12,000 $ 24,500 $ -6,500 $ 1,60,650 Goodwill $ 40,750 Credit Particulars Cash Receivables Inventory Investment in Spider PATT COMPANY AND SUBSIDARY Worksheet for a consolidated Balance Sheet December 31, 2021 Pratt Spider Debit $ 18,700$ 16,000 $ 1,18,500 $ 57,500 $ 1,58,000 $ 87,000 $ 4,88,900 $ $ 2,87,500 2,01,400 Consolidated $ 34,700 $ 1,76,000 $ 2,45,000 $ 2,01,400 $ -2,01,400 $ 2,98,750 $ 7,48,750 $ 4,59,400 $ 1,12,000 $ 24,500 $ 40,750 $ 40,750 $ $ $ Computer Software Buildings (net) Equipment (net) Client Contracts Research & Development Goodwill 2,30,000 $ 28,000 6,12,750 $ 1,36,000 4,00,000 $ 69,500 $ 10,100 $ $ $ 1,12,000 24,500 40,750 Total Assets $ 20,26,850 $ 3,94,000 $ 21,39,850 $ Accounts Payable Notes Payable Common Stock Additional paid-in capital Retained earnings $ $ $ $ $ -94,600 $ -34,000 -5,32,250 $ -72,500 -3,80,000 $ -1,00,000 -1,70,000 $ -25,000 -8,50,000 $ -1,62,500 $ $ $ 1,00,000 25,000 1,62,500 $ 6,500 $ $ $ $ -1,28,600 -6,11,250 -3,80,000 -1,70,000 -8,50,000 Total Liabilities and equities $ -20,26,850 $-3,94,000 $ -21,39,850 * Kindly Comment down for any clarifications/ queries and please upvote.