On January 1, 2016, Palo Company acquires 80% of the outstanding common stock of Sheila Company for $700,000.

On January 1, 2018, 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 2015 and 2017:

On the January 1, 2016, 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, 2018, are as follows:

During 2018, 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, 2018. Include the determination and distribution of excess and income distribution schedules.

Transcribed Image Text:

r 31, 2015 2017 Paidin capital in excess of par . 00,000 40,00 $700,000 $780,000 Palo Sheila Company Cash Accounts Receivable (ne) Inventory Investment in Sheila Company 179,040 280,000 325,000 700,000 Company 105,000 190,000 175,000 2,450,000 400,000 (1,256,000 (536,000) 750,000(210,000) Liabilities .._.... Common Stock ($10 par) Common Stock ($2 par) Paid-In Capital in Excess of Par .. Retained Earnings, January 1, 2018.... Sales ...___ _ . .. 1,500,000 250,000) (650,000) 375,000 (180,000) (1,600,000 750,000) Cost of Goods Sold Other Expenses. Dividends Declared 23,040 1,120,000 405,000 45,000 0 450,000 220,000 36,000 0 Totals ...___. .