Prepare consolidation spreadsheet for intercompany sale of land - Equity method Assume that a parent company acquired its subsidiary on January 1, 2011, at a purchase price that was $305,000 in excess of the book value of the subsidiary's Stockholders' Equity on the acquisition date. Of that excess, $205,000 was assigned to an unrecorded Patent owned by the subsidiary that is being amortized over a 10-year period. The [A] Patent asset has been amortized as part of the parent's equity method accounting. The remaining $100,000 was assigned to Goodwill. In 2012, the wholly owned subsidiary sold Land to the parent for $105,000. The Land was reported on the subsidiary's balance sheet for $70,000 on the date of sale. The parent uses the equity method to account for its Equity Investment.

Financial statements of the parent and its subsidiary for the year ended December 31, 2013 are presented in d. below:

a. Show the computation to yield the $33,000 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.

b. Show the computation to yield the $505,175 Equity Investment account balance reported by the parent on December 31, 2013.

Note: Use a negative sign with an answer to indicate a reduction in the computation.

c. Prepare the consolidation entries for the year ended December 31, 2013.

d. 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.

Please help!

Net income of subsidiary AAP depreciation Income (loss) from subsidiary 53,500 20,500 x 33,000 Common stock APIC EOY Retained earnings EOY Unamortized AAP Gain on intercompany sale Equity investment 25,000 31,250 193,750 X 264,000 X (35,000) 505,175 Credit Debit 0X 0 0 0 x 0 0 X ( 0 X 0 0 X 0 > 0 X 0 Consolidation Worksheet Description [C] Income (loss) from subsidiary Dividends Equity investment [E] Common stock APIC BOY retained earnings Equity investment Patent Goodwill Equity investment [D] Operating expenses Patent [lgain] Equity investment PPE, net 0 OX [A] 0 X 0 0 X 0 0 0 x > 0 X 0 > . > 0 0 X 0 X 0 > 0 0 X Elimination Entries Dr Cr Parent Sub Consolidated $ 0 x OX $ 0 X $3,000,000 $376,000 (2,100,000) (225,000) 900,000 151,000 33,000 (570,000) (97,500) $363,000 $53,500 0 X 0 [C] [D] 0 x Income statement: Sales Cost of goods sold Gross profit Income (loss) from subsidiary Operating expenses Net income Statement of retained earnings: BOY retained earnings Net income Dividends EOY retained earnings OX $ OX [E] 404,550 X $ 0 X 0 x $1,477,200 $193,750 363,000 53,500 (83,875) (6,825) $1,756,325 $240,425 0X [C] 0 X $ 0 x $ 0 x OX Balance sheet: Assets Cash Accounts receivable Inventory PPE, net Patent Goodwill Equity investment $341,566 $122,211 384,000 87,000 582,000 111,750 2,799,600 206,750 0 x $ 0 x 0 x [lgain] 0 X [D] 0 x $ 0 x [A] [A] [lgain) 0 X 0 X 505,175 0 x $ 0 $ 0 x [C] 0 X [E] 0X [A] $ $ $4,612,341 $527,711 $ 0 x $ OX OX Liabilities and stockholders' equity Accounts payable Other currentliabilities Long-term liabilities Common stock APIC Retained earnings 0 x $224,700 $44,760 276,816 61,276 1,500,000 125,000 490,500 25,000 364,000 31,250 1,756,325 240,425 $4,612,341 $527,711 0 X OX [E] [E] 0 X OX OX $ 0 X $ 0 x $ 0 X