I need help with E and F

f. Prepare the consolidation spreadsheet for the year ended December 31, 2013. Use negative signs with answers in the Consolidated column for Cost of goods sold, Operating expenses and Dividends. Elimination Entries Income statement: Parent Sub Dr Cr Conso Sales $10,000,000 $1,002,000 $ Cost of goods sold (7,200,000) (600,000) Gross profit 2,800,000 402,000 $ Income (loss) from subsidiaryincome 127,417 [C] OX Operating expenses (1,500,000) (260,000) [D] 0 x 0 x [ldepr) Net income $1,427,417 $142,000 $ Statement of retained earnings: BOY retained earnings $5,814,300 $225,000 [E] OX $ Net income 1,427,417 142.000 Dividends (285,200) (20,000) OXC EOY retained earnings $6,956,517 $347,000 $ Balance sheet: Assets Cash $1,058,100 $324,000 Accounts receivable 1,750,000 430,000 Inventory 2,600,000 550,000 PPE, net 10,060,000 1,030,000 tlgain] OX 0 x [gain] [Idepr) OX Customer List [A] 0 x 0 x [D] Goodwill [A] Equity investment 805,334 Ilgain] 0 XC) 0X (E) 0 x [A $16,273,434 $2,334,000 Liabilities and stockholders' equity Accounts payable $1,010,000 $178,000 $ Other currentliabilities 1,190,000 230,000 Long-term liabilities 2,500,000 1,300,000 Common stock 553,000 124,000 [E] OX APIC 4,063,917 155,000 [E] Retained earnings 6,956,517 347,000 $16,273,434 $2,334,000 $ 0X $ 0 x $ $ OX > > 0 . 0 > > > 0 e. Prepare the consolidation entries for the year ended December 31, 2013. Consolidation Worksheet Description Debit Credit [C] Income (loss) from subsidiary 0 x 0 Dividends 0 0x Equity investment [E] Common stock 0 X 0 APIC 0 X 0 Retained earnings 0 X Equity investment 0 X [A] Customer list 0X 0 Property, pant & equipment 0 X Goodwill 0X [D] Operating expenses OX Property, pant & equipment 0 0X [lgain) Equity Investment OX 0 Property, pant & equipment 0 x 0 Gain on sale of equipment 0 OX [ldepr] Accumulated depreciation OX 0 Depreciation expense 0 0X 0 X 0 0 . > Prepare consolidation spreadsheet for intercompany sale of equipment - Equity method Assume a parent company acquired its subsidiary on January 1, 2009, at a purchase price that was $310,000 in excess of the book value of the subsidiary's Stockholders' Equity on the acquisition date. Of that excess, $210,000 was assigned to a Customer List that is being amortized over a 10-year period. The remaining $100,000 was assigned to Goodwill. In January of 2012, the wholly owned subsidiary sold Equipment to the parent for a cash price of $122,500. The subsidiary had acquired the equipment at a cost of $140,000 and depreciated the equipment over its 10-year useful life using the straight-line method (no salvage value). The subsidiary had depreciated the equipment for 4 years at the time of sale. The parent retained the depreciation policy of the subsidiary and depreciated the equipment over its remaining 6-year useful life. Financial statements of the parent and its subsidiary for the year ended December 31, 2013 follow in part f. below. The parent uses the equity method to account for its Equity Investment. The Customer List was amortized as part of the parent's equity method accounting