On January 1, 2012, Palo Company acquires 80% of the outstanding common stock of Sheila Company for $700,000. On January 1, 2014, Sheila Company sells 25,000 shares of common stock to the public at $12 per share. Palo Company does not purchase any of these shares. No entry has been made by the parent. Sheila Company has the following stockholders€™ equity at the end of 2011 and 2013:

On the January 1, 2012, acquisition date, Sheila Company€™s book values approximate fair
values, except for a building that is undervalued by $80,000. The building has an estimated
future life of 20 years. Any additional excess is attributed to goodwill.
Trial balances of the two companies as of December 31, 2014, are as follows:

During 2014, Sheila Company sells $50,000 of merchandise to Palo Company at a price that includes a 20% gross profit. This is their first intercompany sale. $10,000 of the goods remains in Palo€™s ending inventory.
Required
Prepare the worksheet necessary to produce the consolidated financial statements of Palo Company and its subsidiary as of December 31, 2014. Include the determination and distribution of excess and income distribution schedules.

Transcribed Image Text:

December 31, 2011 2013 Common stock($2 par Paid-in capital in excess of par 400,000 400,000 Retained earnings Palo Compan Sheila Compan 179,040 280,000 325,000 700,000 2,450,000 105,000 190,000 175,000 Inventory . . . ._ Investment in Sheila Compan y-.. - - 1,400,000 1,256,000 (536,000) (750,000)(210,000) (1,500,000) ommon Common Stock ($2 par) (250,000) (650,000) (375,000 (180,000) (1,600,000)750,000) Sales (23,040) 1,120,000 405,000 45,000 0 450,000 220,000 36,000 0