With the information provided above in the first picture collage , I need to fill out the excel portion in the bottom picture collage.

Worksheet 3-4 Cost Method, Second Year Company Pand Subsidiary Company S Worksheet for Consolidated Financial Statements For Year Ended December 31, 2016 Company P Company S Investment in Company S 1 135,000 2 Patent Other Assets (net of liabilities) 4 118,000 261,500 Common Stock ($10 par)-Company P 5 (200,000) Retained Earnings, January 1, 2016 Company P (172,000) 6 (50,000) (85,000) Common Stock ($10 par)-Company S Retained Earnings, January 1,2016, Company S 8 (100,000) (50,000) Revenue 10 62,000 Expenses 80,000 11 Patent Amortization 12 Subsidiary (Dividend) Income (4,500) 13 5,000 Dividends Declared 14 0 15 Consolidated Net Income 16 To NCI (see distribution schedule) 17 Balance to Controlling Interest (see distribution schedule) 18 Total NCI 19 Retained Earnings, Controlling Interest, December 31. 2016 20 21 Eliminations and Adjustments: Eliminations and Adjustments: Convert to simple equity method as of January 1, 2016 Eliminate the current-year intercompany dividends. Eliminate 90% of the Company S equity balances at the beginning of the year against the investment account. Distribute the $30,000 excess cost as indicated by the D&D schedule that was prepared on the date of acquisition. This includes the $27,000 excess and the $3,000 NCI adjustment Amortize the patent for the current year and one previous year. (CV) (CY2) EL) (DI/INCI) PIC COLLAGE (A) Exercise 3-4 Common Information Ownership Interest Income Distribution 8 Schedules 9 Subsidiary Internally Generated Net 0 Income 1 Amortizations 2 Total 3 NCI Share 4 Controlling Share Market Pice gen Share Number of Shaes Cash Total Credit Debit Price Peid Acquired Company's Balance Sheet Before Pchase Book Market Book Value Market Value Ld Value Value Lfe Assets Liabities 5 6 Parent Internally Generated Net 7 Income Controlling Share of Subsidiary Euty Geodwill 8 9 Total Total Liabilities and 6 Tetal Assets Equity Detemmaton and Distribution of Excess 9 Schedele Cempan Parent Pce NCE value i1 Far Value of Subsidiary ess Book Vahue of interest 2 Acqured 3 Common Stock 4 Pad in Excess S Retained Eamings 6 Total Equity 7 Interest Acquired 8 oo Value Excess of Cost over Book Worksheel Distrbution oAccounts Adjusted Eliminations 5) 16 17 Prepare statements beiow 18 19 20 121 Tota 51 Amortcalion 9thedue Annual Curent Tear Prior Years 52 Accbunt usted Accounts Subectt Amontanon Lie Amounts Total Key 122 Total atens0s Consoldated Worksheet Exercse 3-4 Elminations DrI Consol NCI Control Consol RE Bal Sh Trial Balance Parker Sargent 102 000 115,000 320,000 Net hc Cr Current Assets Ievestment in Subsidiary 400,000 200,000 Depreciable Faxed Assets Accumulated Deprecation (130,000) (40,000) Goodwi Current labities (80,000) (100,000) (170,000) Common Stock-Sargent Retaned Earnings-Sargent Common stock-Parker Retained earnings-Parker (300,000 (200,000) (100 000 (100.0DD) Sales (200.000) Expenses 160.000 85,000 Gain on acquntion Subsidary (dividend) income (12.000) 1 Dividends deciared -Sargents 12 10.000 0 Totsls 3 Consoldated net income 4 NChare 5 Controlling share 06 NCI Controling retained earnings Totsls 8 PIC COLLAGE Worksheet 3-4 Cost Method, Second Year Company Pand Subsidiary Company S Worksheet for Consolidated Financial Statements For Year Ended December 31, 2016 Company P Company S Investment in Company S 1 135,000 2 Patent Other Assets (net of liabilities) 4 118,000 261,500 Common Stock ($10 par)-Company P 5 (200,000) Retained Earnings, January 1, 2016 Company P (172,000) 6 (50,000) (85,000) Common Stock ($10 par)-Company S Retained Earnings, January 1,2016, Company S 8 (100,000) (50,000) Revenue 10 62,000 Expenses 80,000 11 Patent Amortization 12 Subsidiary (Dividend) Income (4,500) 13 5,000 Dividends Declared 14 0 15 Consolidated Net Income 16 To NCI (see distribution schedule) 17 Balance to Controlling Interest (see distribution schedule) 18 Total NCI 19 Retained Earnings, Controlling Interest, December 31. 2016 20 21 Eliminations and Adjustments: Eliminations and Adjustments: Convert to simple equity method as of January 1, 2016 Eliminate the current-year intercompany dividends. Eliminate 90% of the Company S equity balances at the beginning of the year against the investment account. Distribute the $30,000 excess cost as indicated by the D&D schedule that was prepared on the date of acquisition. This includes the $27,000 excess and the $3,000 NCI adjustment Amortize the patent for the current year and one previous year. (CV) (CY2) EL) (DI/INCI) PIC COLLAGE (A) Exercise 3-4 Common Information Ownership Interest Income Distribution 8 Schedules 9 Subsidiary Internally Generated Net 0 Income 1 Amortizations 2 Total 3 NCI Share 4 Controlling Share Market Pice gen Share Number of Shaes Cash Total Credit Debit Price Peid Acquired Company's Balance Sheet Before Pchase Book Market Book Value Market Value Ld Value Value Lfe Assets Liabities 5 6 Parent Internally Generated Net 7 Income Controlling Share of Subsidiary Euty Geodwill 8 9 Total Total Liabilities and 6 Tetal Assets Equity Detemmaton and Distribution of Excess 9 Schedele Cempan Parent Pce NCE value i1 Far Value of Subsidiary ess Book Vahue of interest 2 Acqured 3 Common Stock 4 Pad in Excess S Retained Eamings 6 Total Equity 7 Interest Acquired 8 oo Value Excess of Cost over Book Worksheel Distrbution oAccounts Adjusted Eliminations 5) 16 17 Prepare statements beiow 18 19 20 121 Tota 51 Amortcalion 9thedue Annual Curent Tear Prior Years 52 Accbunt usted Accounts Subectt Amontanon Lie Amounts Total Key 122 Total atens0s Consoldated Worksheet Exercse 3-4 Elminations DrI Consol NCI Control Consol RE Bal Sh Trial Balance Parker Sargent 102 000 115,000 320,000 Net hc Cr Current Assets Ievestment in Subsidiary 400,000 200,000 Depreciable Faxed Assets Accumulated Deprecation (130,000) (40,000) Goodwi Current labities (80,000) (100,000) (170,000) Common Stock-Sargent Retaned Earnings-Sargent Common stock-Parker Retained earnings-Parker (300,000 (200,000) (100 000 (100.0DD) Sales (200.000) Expenses 160.000 85,000 Gain on acquntion Subsidary (dividend) income (12.000) 1 Dividends deciared -Sargents 12 10.000 0 Totsls 3 Consoldated net income 4 NChare 5 Controlling share 06 NCI Controling retained earnings Totsls 8 PIC COLLAGE