i need to do this on an excel spreadsheet. please help

Questions: On January 1, 2015, Polly Co. purchased all of the outstanding stock of Suzie Co. for $837,500 in consideration. The common stock, additional paidin capital, and retained earnings of Suzie Co. were $125,000, $37,500, and $482,500, respectively, on the date of the acquisition. A trademark (with a 10year remaining life) was undervalued by $15,000, and existing technology with a 5 year life was worth $45,000 at the date of acquisition. Any remaining excess fair value was allocated to goodwill. Required: Prepare an excel worksheet with 3 tabs. 1) A fair value allocation that shows the calculation of goodwill relative to the acquisition, and calculates the annual amount of amortization. (Hint: not all of the goodwill on Polly Co.'s balance sheet relates to its Suzie acquisition.) 2) A consolidating worksheet that shows the computation of the consolidated balances for Polly Co. and Suzie Co. as of December 31, 2016. Each consolidating journal entry should be labeled with its identifying letter. 3) A consolidating worksheet that simulates a goodwill impairment loss for 2016 (hint: only the amount of goodwill relating to the Suzie Co. acquisition is considered impaired.) \fAdditional Information (Given) Pecos Company aquired 100 percent of Suaro's potstanding stock for $1,450,000 cash on January 1, 2014 Although at acquisition date Pecos expected future benefits from Suaro's in-process research and development (R&D), by the end of 2014, it became clear that the research project was a failure with no future economic benefits. During 2014, Suaro earns $75,000 and pays no dividends. Peco's January 1, 2015 Retained Earnings balance - before any effect from Suaro's 2014 income is Pecos has 500,000 shares outstanding for EPS calculations and reported December 31, 2015, Trial balances Pecos Revenues ($1,052,000) Operating expenses 821,000 Goodwill impairment loss ? Income of Suaro (115,000) Net income ($346,000) Suaro ($427,000) 262,000 ($165,000) Retained earnings - Pecos 1/1/15 Retained earnings - Suaro 1/1/15 Net income Dividends paid Retained earnings 12/31/15 (655,000) (346,000) 200,000 ($801,000) (201,000) (165,000) 35,000 ($331,000) Cash Receivables Inventory Investment in Suaro 195,000 247,000 415,000 1,255,000 95,000 143,000 197,000 0 341,000 240,100 85,000 100,000 312,000 Land Equipment (net) Software Other intangibles Goodwill Total assets $2,838,100 $932,000 Libilities Common stock Retained earnings Total liabilities and equity (1,537,100) (500,000) (801,000) ($2,838,100) (251,000) (350,000) (331,000) ($932,000) Price paid Book value Excess initial value to land to brand name 145,000 Fair-value allocation schedule 1,450,000 476,000 974,000 Amortizations (10,000) 2014 2015 60,000 0 0 to software to IPR&D to goodwill 100,000 300,000 524,000 50,000 300,000 350,000 Suaro's RE changes 2014 2015 Income 75,000 165,000 Dividends 0 35,000 50,000 0 50,000 tional Information (Given) cash on January 1, 2014. ess research and development th no future economic benefits. 014 income is ns and reported $ (930,000) (credit) $2,943,100 for consolidated assets at the beginning of the period. Revenues Operating expenses Goodwill impairment loss Income of Suaro Net income Pecos Co. and Suaro Co. Consolidated Worksheet For Year Ending December 31, 2015 EQUITY METHOD Consolidated Entries Pecos Suaro Debit ($1,052,000) ($427,000) 821,000 262,000 (E) 50,000 (115,000) ($346,000) ($165,000) Retained earnings - Pecos 1/1/15 Retained earnings - Suaro 1/1/15 Net income Dividends paid Retained earnings 12/31/15 (655,000) 0 (346,000) 200,000 ($801,000) (201,000) (165,000) 35,000 ($331,000) Cash Receivables Inventory Investment in Suaro 195,000 247,000 415,000 1,255,000 95,000 143,000 197,000 341,000 240,100 85,000 100,000 312,000 (I) 115,000 (S) 201,000 (D) (D) Land Equipment (net) Software Other intangibles Brand Name Goodwill Total assets $2,838,100 $932,000 Libilities Common stock Retained earnings Total liabilities and equity (1,537,100) (500,000) (801,000) ($2,838,100) (251,000) (350,000) (331,000) ($932,000) 35,000 (S) (A) (I) (A) (A) 50,000 (A) (A) 60,000 524,000 (S) 350,000 145,000 1,385,000 (E) r 31, 2015 onsolidated Entries Credit Consolidated Totals ($1,479,000) 1,133,000 0 ($346,000) 35,000 (655,000) 0 (346,000) 200,000 (801,000) 290,000 390,000 612,000 551,000 624,000 115,000 10,000 50,000 1,385,000 0 416,000 340,100 312,000 145,000 60,000 524,000 3,089,100 (1,788,100) (500,000) (801,000) (3,089,100) Revenues Operating expenses Goodwill impairment loss Income of Suaro Net income Pecos Co. and Suaro Co. Consolidated Worksheet For Year Ending December 31, 2015 INITIAL VALUE METHOD Consolidated Entries Pecos Suaro Debit ($1,052,000) ($427,000) 821,000 262,000 (E) 50,000 (35,000) ($266,000) (I) 35,000 (*C) (S) 275,000 201,000 ($165,000) Retained earnings - Pecos 1/1/15 Retained earnings - Suaro 1/1/15 Net income Dividends paid Retained earnings 12/31/15 930,000 266,000 200,000 $996,000 Cash Receivables Inventory Investment in Suaro 195,000 247,000 415,000 1,450,000 95,000 143,000 197,000 341,000 240,100 85,000 100,000 312,000 201,000 165,000 35,000 $331,000 (I) (S) (A) (*C) Land Equipment (net) Software Other intangibles Brand Name Goodwill Total assets $3,033,100 $932,000 Libilities Common stock Retained earnings Total liabilities and equity (1,537,100) (500,000) (996,000) ($3,033,100) (251,000) (350,000) (331,000) ($932,000) (A) (A) 50,000 (A) (A) 60,000 524,000 (S) 350,000 145,000 1,545,000 (E) r 31, 2015 onsolidated Entries Credit Consolidated Totals ($1,479,000) 1,133,000 ($346,000) 35,000 655,000 402,000 346,000 200,000 801,000 290,000 390,000 612,000 551,000 624,000 275,000 10,000 50,000 1,545,000 416,000 340,100 312,000 145,000 60,000 524,000 3,089,100 (1,788,100) (500,000) (801,000) (3,089,100) Revenues Operating expenses Goodwill impairment loss Income of Suaro Net income Retained earnings - Pecos 1/1/15 Retained earnings - Suaro 1/1/15 Net income Dividends paid Retained earnings 12/31/15 Cash Receivables Inventory Investment in Suaro Pecos Co. and Suaro Co. Consolidated Worksheet For Year Ending December 31, 2015 PARTIAL EQUITY METHOD Consolidated Entries Pecos Suaro Debit ($1,052,000) ($427,000) 821,000 262,000 (E) 50,000 (165,000) ($396,000) 165,000 (*C) (S) 350,000 201,000 ($165,000) (1,005,000) (396,000) 200,000 ($1,201,000) (I) (201,000) (165,000) 35,000 ($331,000) 195,000 247,000 415,000 1,655,000 95,000 143,000 197,000 341,000 240,100 85,000 100,000 312,000 Land Equipment (net) Software Other intangibles Brand Name Goodwill Total assets $3,238,100 $932,000 Libilities Common stock Retained earnings Total liabilities and equity (1,537,100) (500,000) (1,201,000) ($3,238,100) (251,000) (350,000) (331,000) ($932,000) (D) (D) 35,000 (S) (A) (I) (*C) (A) (A) 50,000 (E) (A) (A) 60,000 524,000 (S) 350,000 145,000 1,785,000 r 31, 2015 onsolidated Entries Credit Consolidated Totals (1,479,000) 1,133,000 0 0 (346,000) (655,000) 35,000 (346,000) 200,000 (801,000) 290,000 390,000 612,000 551,000 624,000 165,000 350,000 10,000 50,000 1,785,000 0 416,000 340,100 312,000 145,000 60,000 524,000 3,089,100 (1,788,100) (500,000) (801,000) (3,089,100) Pecos Co. and Suaro Co. Without Impairment Common shares outstanding Consolidated net income/(loss) Consolidated assets, 1/1/15 Consolidated assets, 12/31/15 Consolidated equity, 1/1/15 Consolidated equity, 12/31/15 Consolidated liabilities 500,000 $346,000 2,943,100 3,089,100 1,155,000 1,301,000 1,788,100 With Impairment 500,000 ($178,000) 2,943,100 2,565,100 1,155,000 777,000 1,788,100 2015 Goodwill Impairment Loss Effects on ratios: Earnings per share (EPS) Return on assets Return on equity Debt to equity Without Impairment With Impairment $ 0.69 $ (0.36) 11.47% -6.46% 28.18% -18.43% 1.3744 2.3013 Additional Information (Given) Polly Co. purchased all of the outstanding stock of Suzie Co. for $ 837,500 Suzie Co. : Common Stock $ 125,000 Additional paid-in capital $ 37,500 Retained earnings $ 482,500 Trademark (undervalued) $ 15,000 Existing Technology $ 45,000 The December 31, 2016 balances for Suzie Co. and Polly Co. were as follows: Revenues Cost of Goods Sold Depreciation Expenses Amortization Expenses Dividend Income Net Income Polly Co. $ (1,237,500) $ 625,000 $ 125,000 $ 68,750 $ (50,000) $ (468,750) Retained Earnings, 1/1/16 Net Income Dividends declared Retained Earnings, 12/31/16 $ $ $ $ (1,943,750) (468,750) 312,500 (2,100,000) Current assets Investment in Polly Co. Equipment (net) Trademark Existing technology Goodwill Total assets $ $ $ $ $ $ $ 1,200,000 837,500 956,250 293,750 562,500 3,850,000 Liabilities Common Stock Additional paid-in capital Retained Earnings, 12/31/16 Total Liabilities and Equity $ $ $ $ $ (975,000) (625,000) (150,000) (2,100,000) (3,850,000) ven) in consideration. 10 5 lows: $ $ $ $ $ $ Suzie Co. (262,500) 112,500 6,250 22,500 (121,250) $ $ $ $ (562,500) (121,250) 50,000 (633,750) $ $ $ $ $ $ $ 443,750 281,250 125,000 562,500 1,412,500 $ (616,250) $ (125,000) $ (37,500) $ (633,750) $ (1,412,500) $ 1,500 $ 9,000 Fair-value allocation schedule Purchase consideration Less: Book Value net assets Common Stock Additional paid-in capital Retained earnings Excess amount of purchase consideration attributed to GW Trademark (undervalued) Existing Technology To goodwill (indefinite life) $ $ $ 125,000 37,500 482,500 $ $ 15,000 45,000 dule $ 837,500 $ $ (645,000) 192,500 $ $ $ (60,000) $ 132,500 $ Amortizations 2015 2016 - $ 9,000 $ 9,000 $ 9,000 9,000 Polly Co. & Suzie Co. Consolidated Worksheet For Year Ending December 31, 2016 EQUITY METHOD Consolidated Ent Polly Co. Suzie Co. Debit (1,237,500) $ (262,500) 625,000 $ 112,500 125,000 $ 6,250 68,750 $ 22,500 (50,000) $ - Revenues Cost of Goods Sold Depreciation Expenses Amortization Expenses Dividend Income Goodwill impairment loss Net Income $ $ $ $ $ Retained Earnings, 1/1/16 - Polly Co. Retained Earnings, 1/1/16 - Suzie Co. Net Income Dividends declared Retained Earnings, 12/31/16 $ $ $ $ $ Current assets Investment in Polly Co. $ $ 1,200,000 $ 837,500 $ Equipment (net) Trademark Existing technology Goodwill Total assets $ $ $ $ $ 956,250 293,750 562,500 3,850,000 $ $ $ $ $ 281,250 125,000 (A) 562,500 1,412,500 Liabilities Common Stock Additional paid-in capital Retained Earnings, 12/31/16 Total Liabilities and Equity $ $ $ $ $ (975,000) (625,000) (150,000) (2,100,000) (3,850,000) $ $ $ $ $ (616,250) (125,000) (S) (37,500) (633,750) (1,412,500) $ (468,750) $ (1,943,750) (468,750) 312,500 (2,100,000) $ $ $ $ $ (121,250) (562,500) (S) (121,250) 50,000 (633,750) $ 562,500 $ 15,000 $ 125,000 443,750 - er 31, 2016 Consolidated Entries Credit (S) $ $ $ $ $ $ Consolidated Totals (1,500,000) 737,500 131,250 91,250 (50,000) $ (590,000) $ $ (1,943,750) - $ 433,750 687,500 Polly Co. & Suzie Co. Consolidated Worksheet For Year Ending December 31, 2015 EQUITY METHOD-Goodwill Impairment Loss Revenues Cost of Goods Sold Depreciation Expenses Amortization Expenses Dividend Income Goodwill impairment loss Net Income $ $ $ $ $ Retained Earnings, 1/1/16 - Polly Co. Retained Earnings, 1/1/16 - Suzie Co. Net Income Dividends declared Retained Earnings, 12/31/16 $ $ $ $ $ Current assets Investment in Polly Co. $ Polly Co. (1,237,500) 625,000 125,000 68,750 (50,000) $ $ $ $ $ Suzie Co. (262,500) 112,500 6,250 22,500 - (468,750) $ (121,250) (1,943,750) (468,750) 312,500 (2,100,000) $ $ $ $ $ (562,500) (121,250) 50,000 (633,750) $ $ 1,200,000 $ 837,500 $ 443,750 - Equipment (net) Trademark Existing technology Goodwill Total assets $ $ $ $ $ 956,250 293,750 562,500 3,850,000 $ $ $ $ $ 281,250 125,000 562,500 1,412,500 Liabilities Common Stock Additional paid-in capital Retained Earnings, 12/31/16 Total Liabilities and Equity $ $ $ $ $ (975,000) (625,000) (150,000) (2,100,000) (3,850,000) $ $ $ $ $ (616,250) (125,000) (37,500) (633,750) (1,412,500) & Suzie Co. Year Ending December 31, 2015 odwill Impairment Loss Consolidated Entries Debit Credit Consolidated Totals