Hi please help with the following. All of the information is below and the balance sheet needs to be filled out.

1 Problem 2-30 (Algo) (LO 2-4,2-5, 2-7, 2-8) Pratt Company acquired all of the outstanding shares of Spider, Inc., on December 31, 2021, for $490,350 cash, Pratt will operate Spider as a wholly owned subsidiary with a separate legal and accounting identity. Although many of Spider's book values approximate fair values, several of its accounts have fair values that differ from book values. In addition, Spider has internally developed assets that remain unrecorded on its books. In deriving the acquisition price, Pratt assessed Spider's fair and book value differences as follows: 15 points eBook Print Computer software Equipment Client contracts In-process research and development Notes payable Book Values Fair Values $ 45,500 $ 86,700 74,500 60,000 121,000 @ 30,750 (95,400) (194,000) References 1 At December 31, 2021, the following financial information is available for consolidation (credit balances in parentheses): Spider $ 14,400 64,500 73,800 15 points Pratt 14,050 108,500 176,000 490,350 244,000 617,500 379,000 45,500 153,000 74,500 eBook Print Cash Receivables Inventory Investment in Spider Computer software Buildings (net) Equipment (net) client contracts Goodwill Total assets Accounts payable Notes payable Common stock Additional paid-in capital Retained earnings Total liabilities and equities References 0 $ 2,029,400 $ 425,700 (95,900) $ (54,800) (530,500) (95,400) (380,000) (100,000) (170,000) (25,000) (853, 000) (150,500) $12,029, 480) $ (425,700) Prepare a consolidated balance sheet for Pratt and Spider as of December 31, 2021, 1 Credit Consolidated 15 points PRATT COMPANY AND SUBSIDIARY Workshoot for a Consolidated Balance Shoot December 31, 2021 Pratt Spider Debit $ 14,050 $ 14.400 108,500 64,500 176,000 73,800 490,350 244,000 45,500 617,500 153,000 379,000 74,500 Book Print References Cash Receivables Inventory Investment in Spider Computer software Buildings (net) Equipment (net) Client contracts Research and development asset Goodwill Total assets Accounts payable Notes payable Common stock Additional paid.in capital Retained earnings Total liabilities and equities $ 0 $ 2.029.400 S 425.700 $ (95.900) $ (54,800) (530,500) (95.400) (380,000) (100,000) (170,000) (25,000) (853,000) (150.500) $ (2,029,400) S (425,700) $ 0 $ 0 $ 0