Reference no: EM131144019

Write the solution of the problem and send the file in excel format with all detailed calculations and explanation.

The individual financial statements for Gibson Company and Keller Company for the year ending December 31. 2015. follow Gibson acquired a 60 percent interest in Keller on January 1. 2014. in exchange for various considerations totaling $750,000. At the acquisition date, the fair value of the noncontrolling interest was $500,000 and Keller's book value was $1,000,000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition-date fair value of $250.000. This intangible asset is being amortized over 20 years.
Gibson sold Keller land with a book value of $75.000 on January 2. 2014. for $160,000. Keller still holds this land at the end of the current year.
Keller regularly transfers inventory to Gibson. In 2014. it shipped inventory costing $180,000 to Gibson at a price of $300,000. During 2015. intra-entity shipments totaled $350,000. although the original cost to Keller was only $245,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 $35,000 at the end of 2015.

	Gibson Company	Keller Company
Sales	S       (950.000)	S     (650.000)
Cost of goods sold	650.000	450.000
Operating expenses	140.000	30.000
Equity in earnings of Keller Company	(102.000)	0
Net income	$       (262.000)	(170.000)
Retained earnings. 1/1/15
	$(1.266.000)	$ (695,000)
Net income (above)	(262.000)	(170.000)
Dividends declared	145,000	45,000
Retained earnings. 12/31/15	$(1.383.000)	(820.000)
Cash
	S        184.000	S        60.000
Accounts receivable	386.000	560,000
Inventory	540.000	470,000
Investment in Keller Company	966.000	0
Land	120.000	540,000
Buildings and equipment (net)	511.000	450.000
Total assets	$ 2,707,000	$ 2.080.000
Liabilities
	$       (584.000)	(720.000)
Common stock	(740.000)	(470.000)
Additional paid4n capital	0	(70,000)
Retained earnings. 12/31/15	(1.383.000)	(820.000)
Total liabilities and equities	5(2,707.000)	$(2,080,000)

(Note: Parantheses indicate a credit balance)

a. Prepare a worksheet to consolidate the separate 2015 financial statements for Gibson and Keller (For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet.)

b. How would the consolidation entries in requirement (a) have differed if Gibson had sold a building with a $135,000 book value (cost of $290,000) to Keller for $250,000 instead of land as the problem reports? Assume that the building had a 10-year remaining life at the date of transfer (If no entry is required for a transactiont/event. select No journal entry required" in the first account field.)

Attachment:- Project.rar

Attachment:- Gibson---Keller--Sample-Worksheet.rar