i need a consokidated worksheet for this question as soon as possible.

US PowerPont- 12-08 X M Advanced Accounting (2019- kaur43/Downloads/Kaur)_SP7_send.pdf X Kaur SP7 send.pdf The individual financial statements for Gibson Company and Keller Company for the year ending December 31, 2018, follow Gosoncured a 50 percent interest in Keller on January 1, 2017 in exchange for anous considerations totaling 5690.000. At the acquisition date the fair value of the noncontrolling interest was $450.000 and Keller's book value was $920.000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition date of $230 000. This intangible asset is being amortized over 20 years Gibson sold Keller land with a book value of $65.000 on January 2 2017 for $140,000. Keller still holds this land at the end of the current year Keller regularly transfers inventory to Gibson. In 2017, t shipped inventory costing 5196000 to Gibson at a price of 200000. During 2018 i n ity shipments totaled $330.000, although the orginal cost to Keller was only 5214 500, in each of these years, 20 percent of the merchandise was not resold to outside parties until the period following the transfer Gibson owes Keller $70.000 at the end of 2018 Keller Company $ 630 000) 430 000 90.000 Sales Cost of goods sold Operating expenses Equity in earnings of Keller Net income Retained earnings. 1/B Net income (above) Dividends declared Retained earnings 12/31/18 $ S Gibson Company 5 930.000) 630.000 120.000 (66.000) S (246,000) $1.246.000) (246.000) 135 000 5 (1.357.000) 182.000 382.000 520.000 918.000 240.000 509.000 5 2.751.000 $ (674,000) (720,000) (110 000) 0665.000) (110,000) 35,000 (760.000) 90.000 540,000 450.000 Cash S Accounts receivable Inventory Investment in Keller Land Buildings and equipment ne Total assets Liabilities Common stock Additional paid in capital Retained earnings, 12/31/18 Total liabilities and equities 520,000 430,000 5 2.030,000 (730,000) (450,000) (90,000) (760.000) 5 02.030000) (1.357 000) 5 (2.751.000) (Note: Parentheses indicate a credit balance) a. Prepare a worksheet to consolidate the separate 2018 financial statements for Gibson and Keller US PowerPont- 12-08 X M Advanced Accounting (2019- kaur43/Downloads/Kaur)_SP7_send.pdf X Kaur SP7 send.pdf The individual financial statements for Gibson Company and Keller Company for the year ending December 31, 2018, follow Gosoncured a 50 percent interest in Keller on January 1, 2017 in exchange for anous considerations totaling 5690.000. At the acquisition date the fair value of the noncontrolling interest was $450.000 and Keller's book value was $920.000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition date of $230 000. This intangible asset is being amortized over 20 years Gibson sold Keller land with a book value of $65.000 on January 2 2017 for $140,000. Keller still holds this land at the end of the current year Keller regularly transfers inventory to Gibson. In 2017, t shipped inventory costing 5196000 to Gibson at a price of 200000. During 2018 i n ity shipments totaled $330.000, although the orginal cost to Keller was only 5214 500, in each of these years, 20 percent of the merchandise was not resold to outside parties until the period following the transfer Gibson owes Keller $70.000 at the end of 2018 Keller Company $ 630 000) 430 000 90.000 Sales Cost of goods sold Operating expenses Equity in earnings of Keller Net income Retained earnings. 1/B Net income (above) Dividends declared Retained earnings 12/31/18 $ S Gibson Company 5 930.000) 630.000 120.000 (66.000) S (246,000) $1.246.000) (246.000) 135 000 5 (1.357.000) 182.000 382.000 520.000 918.000 240.000 509.000 5 2.751.000 $ (674,000) (720,000) (110 000) 0665.000) (110,000) 35,000 (760.000) 90.000 540,000 450.000 Cash S Accounts receivable Inventory Investment in Keller Land Buildings and equipment ne Total assets Liabilities Common stock Additional paid in capital Retained earnings, 12/31/18 Total liabilities and equities 520,000 430,000 5 2.030,000 (730,000) (450,000) (90,000) (760.000) 5 02.030000) (1.357 000) 5 (2.751.000) (Note: Parentheses indicate a credit balance) a. Prepare a worksheet to consolidate the separate 2018 financial statements for Gibson and Keller