3. Using references to other cells only (either from the consolidated information worksheet or from the separate method sheets), prepare for each of the three consolidation worksheets:

Adjustments and eliminations.

Consolidated balances.

I just need those two adjusted and elimations and consolidated balance, ty.

PECOS COMPANY AND SUARO COPANY Consolidated Worksheet For the Year Ended December 31, 2015 EQUITY METHOD Consolidation Entries Pecos (1,052,000) 821,000 Suaro (427,000) 262,000 Consolidated Totals (1,479,000) 1,083,000 50,000 Debit Credit Revenues Operating expenses Amortiz ation of intangibles Goodwill impairment loss Income of Suaro Net income 50,000 (115,000 346,000 115,000 165,000 346,00 Retai ned earnings-Pecos, 111 Retai ned earnings-Suaro, 11 Net income (above) Dividends declared Retai ned earnings, 12131 (655,000) (655,000) (201,000) (S) 201,000 (346,000) 200,000 (801,000) (165,000) 35,000 (331,000) (346,000) 35,000 200,000 (801,000 195,000 247,000 415,000 1,255,000 Receivables Inventory Investment in Suaro 95000 143,000 197,000 290,000 390,000 35,000 (E) 551,000 624,000 115,000 341,000 240,100 Land Equipment (net) Software Other intangibles Brand name Goodwill Total assets 85,000 100,000 (A) 10,000 416,000 340,100 50,000 (E 50,000 31 2,000 145,000 60,000 524,000 3,089,100 145,000 60,000 (A) 524,000 2,838,100 932,000 (1,537,100) (500, 000) (801,00 (2,838 100) (1,788,100) (500,000) (S) 350,000 Commn stock Retai ned earnings (above) Total liabilities and equity (350,000) (801,00 (932,00 1,385,000 1,385,000 (3,089,100) - Shaded items were provided on the Consolidated Information Worksheet