Reference no: EM131518336

Question: SIMULATION #3
CONSOLIDATIONS

Cain Corp. acquired all of the outstanding $10 par value voting common stock of Frey, Inc. on January 1, 2013 in exchange for 25,000 shares of its $10 par value voting common stock. On December 31, 2012, Cain's common stock had a closing market price of $30 per share on a national stock exchange. Both companies continued to operate as separate business entities maintaining separate accounting records with years ending December 31.

On December 31, 2013, the companies had condensed financial statements as follows:

	Cain Corp.          Dr. (Cr.)	Frey, Inc.             Dr. (Cr.)
Income Statement:
Net sales	$(3,800,000)	$(1,500,000)
Equity in net income	(178,000)
Gain on sale of warehouse	(30,000)
Cost of goods sold	2,360,000	870,000
Operating expenses	1,100,000	440,000
Net income	$(548,000)	$(190,000)
Retained Earnings Statement:
Balance, 1/1/06	$(440,000)	$(156,000)
Net income	(548,000)	(190,000)
Dividends		40,000
Balance, 12/31/06	$(988,000)	$(306,000)
Balance Sheet:
Assets:
Cash	$570,000	$150,000
Accounts receivable (net)	860,000	350,000
Inventories	1,060,000	410,000
Land, plant and equipment	1,320,000	680,000
Accumulated depreciation	(370,000)	(210,000)
Investment in Frey	888,000
Total Assets	$4,328,000	$1,380,000
Liabilities and Stockholders' Equity
Accounts payable and accrued expenses	$(1,340,000)	$(594,000)
Common stock ($10 par)	(1,700,000)	(400,000)
Additional paid-in capital	(300,000)	(80,000)
Retained earnings	(988,000)	(306,000)
Total Liabilities and Stockholders' Equity	$(4,328,000)	$(1,380,000)

Additional Information: • There were no changes in the common stock and additional paid-in capital accounts during 2013 except the one necessitated by Cain's acquisition of Frey.

• At the acquisition date, the fair value of Frey's machinery exceeded its book value by $54,000. The excess cost will be amortized over the estimated average remaining life of six years. The fair values of Frey's other assets and liabilities were equal to their book values. Any "other intangible asset" resulting from the acquisition will be amortized over a 20-year period.

• On July 1, 2013, Cain sold a warehouse facility to Frey for $129,000 cash. At the date of sale, Cain's book values were $33,000 for the land and $66,000 for the undepreciated cost of the building. Based on a real estate appraisal, Frey allocated $43,000 of the purchase price to land and $86,000 to building. Frey is depreciating the building over its estimated five-year remaining useful life by the straight-line method with no salvage value.

• During 2013, Cain purchased merchandise from Frey at an aggregate invoice price of $180,000, which included a 100% markup on Frey's cost. At December 31, 2013, Cain owed Frey $86,000 on these purchases, and $36,000 of this merchandise remained in Cain's inventory.

Reuired: Prepare a consolidated worksheet, complete with supporting elimination entries and calculations.