**THIS IS THE ENTIRE QUESTION**

The individual financial statements for Gibson Company and Keller Company for the year ending December 31, 2018, follow. Gibson acquired a 60 percent interest in Keller on January 1,2017, in exchange for various considerations totaling $630,000. At the acquisition date, the fair value of the noncontrolling interest was $420,000 and Keller's book value was $840,000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition-date fair value of $210,000. This intangible asset is being amortized over 20 years. Gibson sold Keller land with a book value of $55,000 on January 2,2017, for $120,000. Keller still holds this land at the end of the current year. Keller regularly transfers inventory to Gibson. In 2017, it shipped inventory costing $169,000 to Gibson at a price of $260,000. During 2018, intra-entity shipments totaled $310,000, although the original cost to Keller was only $186,000. 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 $60,000 at the end of 2018. Keller Company (610,000) 410,000 80,000 Gibson Company $(910,000) 610,000 100,000 (72, 000) $(272,000) (1,226,000) (272, 000) 125,000 $(1,373, 000) 180,000 378,000 500,000 855,000 220,000 507,000 $2,640,000 (567,000) (700,000) 0 Sales Cost of goods sold Operating expenses Equity in earnings of Keller (120,000) (675,000) (120,000) 80,000 (715,000) 70,000 520,000 430,000 0 500,000 410,000 1,930,000 Net income Retained earnings, 1/1/18 Net income (above) Dividends declared Retained earnings, 12/31/18 Cash Accounts receivable Inventory Investment in Keller Land Buildings and equipment (net) Total assets (715,000) (430,000) (70,000) (715,000) $(1,930, 000) Liabilities Common stock Additional paid- in capital Retained earnings, 12/31/18 (1,373,000) $ (2,640,000) Total liabilities and equities (Note: Parentheses indicate a credit balance.) a. Prepare a worksheet to consolidate the separate 2018 financial statements for Gibson and Keller. GIBSON AND KELLER Consolidation Worksheet For the Year Ending December 31, 2018 Consolidation Entries NoncontrollingConsolidated Totals Accounts Gibson Keller Debit Credit Interest $ (910,000) (810,000) 610,000 Sales Cost of goods sold Operating expenses Equity in earnings of Keller Separate company net income Consolidated net income To noncontrolling interest To Gibson Company Retained earnings, 1/1-Gibson Retained earnings, 1/1-Keller Net income Dividends declared 410,000 80,000 100,000 (72,000) $ (272,000 (120,000) 0 $ (1,228,000) (875,000) (120,000) (272,000) 125,000 80,000 $(1,373,000) (715,000) 180,000 $ 378,000 S Retained earnings, 12/31 Cash Accounts receivable Inventory Investment in Keler Land Buildings and equipment (net) Customer list $ 70,000 520,000 430,000 500,000 855,000 500,000 220,000 507,000 410,000 2,640,000 $ 1,930,000 $ (567,000) $(715,000) (430,000) (70,000) (715,000) Total assets $ Liabilities Common stock Additional paid-in capital Retained earnings, 12/31 NCI in Keller, 1/1 NCI in Keller, 12/31 Total liabilities and equity (700,000) (1,373,000) $(2,640,000) $(1,930,000)| $ $