To be done on Excel. Please post screenshot resulting worksheet

Utes purchased 100% of Wildcats Inc for $500K on January 1st 2XX1. The information on the spreadsheet is from the December 31, 2XX1 accounts. At the time of purchase all FMV of all assets and liabilities equal book value, except for the following Description Book Value Fair Value Building $100,000 $190,000 10 Year Life Inventory 10,000 30,000 2 month life Land 5,000 70,000 Patents Zero 100,000 4 year life Any excess from the purchase price will be allocated to goodwill. Requirement: Reconcile the Investment and Income from Sub accounts, prepare the appropriate eliminations entries and complete the worksheet Eliminations Debit Credit Ute Wildcat Consolidated 200,000 (90,000) (30,000) 246,000 326,000 387,000 (67,000) (20,000) 300,000 175,000 326,000 (32,000) 469,000 75,000 300,000 (10,000) 365,000 Income Statement Sales Other Expenses Depreciation Income from Wildcats Net Income NCI Net Income CI Net Income Statement of Retained Earnings Beginning RE Net Income Less Dividends Declared Ending Retained Earnings Balance Sheet Current Assets Depreicable Assets Accumulated Depreciation Investment in Wildcats Land Patents Goodwill Total Assets Current Liabilities Long Term Liabilities Common Stock Retained Earnings 192,000 300,000 (120,000) 736,000 405,000 170,000 (85,000) 5,000 1,108,000 50,000 489,000 100,000 469,000 495,000 30,000 50,000 50,000 365,000 Total Liabilities and Equity 1,108,000 495,000 Utes purchased 100% of Wildcats Inc for $500K on January 1st 2XX1. The information on the spreadsheet is from the December 31, 2XX1 accounts. At the time of purchase all FMV of all assets and liabilities equal book value, except for the following Description Book Value Fair Value Building $100,000 $190,000 10 Year Life Inventory 10,000 30,000 2 month life Land 5,000 70,000 Patents Zero 100,000 4 year life Any excess from the purchase price will be allocated to goodwill. Requirement: Reconcile the Investment and Income from Sub accounts, prepare the appropriate eliminations entries and complete the worksheet Eliminations Debit Credit Ute Wildcat Consolidated 200,000 (90,000) (30,000) 246,000 326,000 387,000 (67,000) (20,000) 300,000 175,000 326,000 (32,000) 469,000 75,000 300,000 (10,000) 365,000 Income Statement Sales Other Expenses Depreciation Income from Wildcats Net Income NCI Net Income CI Net Income Statement of Retained Earnings Beginning RE Net Income Less Dividends Declared Ending Retained Earnings Balance Sheet Current Assets Depreicable Assets Accumulated Depreciation Investment in Wildcats Land Patents Goodwill Total Assets Current Liabilities Long Term Liabilities Common Stock Retained Earnings 192,000 300,000 (120,000) 736,000 405,000 170,000 (85,000) 5,000 1,108,000 50,000 489,000 100,000 469,000 495,000 30,000 50,000 50,000 365,000 Total Liabilities and Equity 1,108,000 495,000