Please use excel and show all calculations

On January 1, 2022 Roberts Corporation acquired 100% of the outstanding voting stock of Williams Company in exchange for $726,000 cash. At that time, although Williams book value was $560,000, Roberts assessed Williams total business fair value at $726,000. The book values of Williams individual assets and liabilities approximated their acquisition-date fair values except for the equipment account which was undervalued by $100,000. The undervalued equipment had a 5-year remaining life at the acquisition date. Any remaining excess fair value was attributed to goodwill. Post-acquisition financial information for both companies on January 1, 2022 is shown below: Cash Accounts receivable Inventory Investment in Williams Stock Land Roberts $177,000 356,000 440,000 726,000 180,000 496,000 Williams $90,000 120,000 220,000 -0- 200,000 320,000 $950,000 Buildings and equipment (net) Total assets $2.375,000 Accounts payable Notes payable Common stock Additional paid-in capital Retained earnings, 1/1/22 Total liabilities and stockholders' equity $(120,000) (360,000) (610,000) (200,000) (1,085,000) $2,375,000 $(70,000) (320,000) (150,000) (90,000) (320,000) $950,000 Using the acquisition method, determine the allocation of the purchase price to the specific asset and liability accounts as of the date of acquisition. Round all calculations to the nearest whole dollar. Assuming that Roberts accounts for its investment in Williams using the equity method, prepare the worksheet entries needed on the date of acquisition. Finally, prepare a worksheet to consolidate the balance sheets of these two companies as of January 1, 2022