All the info are in the photo thank you!

Prepare consolidation spreadsheet for intercompany sale of equipment - Equity method Assume that a parent company acquired its subsidiary on January 1, 2009, at a purchase price that was $315,000 in excess of the book value of the subsidiary's Stockholders' Equity on the acquisition date. Of that excess, $215,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 $118,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. a. Prepare the journal entry that the subsidiary made to record the sale of the equipment to the parent, the journal entry that the parent made to record the purchase, and the [l] entries for the year of sale. Journal Entries Description Debit Credit Subsidiary: Cash 0 0 0 0 0 Property, plant & equipment 0 0 0 Parent: 0 0 0 [lgain] 0 0 0 Property, plant & equipment 0 0 0 [ldepr] 0 0 0 0 b. Compute the remaining portion of the deferred gain on January 1, 2013. $ 0 b. Compute the remaining portion of the deferred gain on January 1, 2013. $ 0 c. Show the computation to yield the $127,250 of Income (loss) from subsidiary reported by the parent for the year ended December 31, 2013. Note: Use a negative sign with an answer to indicate a reduction in the computation. Net income of subsidiary AAP Depreciation 0 0 0 Income (loss) from subsidiary 0 d. Compute the Equity Investment balance of $811,500 on December 31, 2013. Note: Use a negative sign with an answer to indicate a reduction in the computation. 0 Common stock APIC 0 0 EOY Retained earnings EOY Unamortized AAP Gain on intercompany sale Equity investment 0 0 e. Prepare the consolidation entries for the year ended December 31, 2013. Consolidation Worksheet Description Debit Credit [C] 0 Dividends 0 0 0 0 0 0 0 APIC Retained earnings 0 0 0 . 0 0 [A] Customer list 0 0 0 0 0 0 [D] Operating expenses 0 0 0 0 [lgain] Equity Investment 0 0 0 0 + 0 0 [ldepr] 0 0 0 0 O ED 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 Consolidated Sales $10,000,000 $1,003,000 $ 0 Cost of goods sold (7,200,000) (600,000) 0 Gross profit 2,800,000 403,000 $ 0 Income (loss) from subsidiary 127,250 [C] 0 0 Operating expenses (1,500,000) (260,000) [D] 0 [depr] 0 Net income $1,427,250 $143,000 $ 0 Statement of retained earnings: BOY retained earnings $5,814,300 $225,000 0 $ 0 Net income 1,427,250 143,000 0 Dividends (285,200) (20,000) OC 0 EOY retained earnings $6,956,350 $348,000 $ 0 Balance sheet: Assets Cash $1,058,100 $325,000 $ 0 Accounts receivable 1,750,000 430,000 0 Inventory 2,600,000 550,000 0 PPE, net 10,060,000 1,030,000 [gain] 0 0 [lgain] 0 [Idepr] Customer List [A] 0 O [D] 0 Goodwill [A] 0 0 Equity investment 811,500 [lgain] OC 0 0 [E] O [A] $16,279,600 $2,335,000 $ 0 Liabilities and stockholders' equity Accounts payable $1,010,000 $178,000 $ 0 Other currentliabilities 1,190,000 230,000 0 Long-term liabilities 2,500,000 1,300,000 0 Common stock 553,000 124,000 [E] 0 0 APIC 4,070,250 155,000 [E] 0 0 Retained earnings 6,956,350 348,000 0 $16,279,600 $2,335,000 $ 0 $ $ 0 0 $ $ 0 0 0