I need help please with this. i need a worksheet with the formulas from the eliminating entries

ACC 4303 Name __________________________________________________ Fall, 2016 Consolidation Worksheet December 31, 2011 * all numbers in 000's * brackets indicate credit balances Eliminations Account Sales Income from Schwinn Credits Cost of Goods Sold Depreciation Expense Other Expenses Debits Consolidated Net Income Income to NCI Income, carry forward Retained Earnings, Jan 1 Income, from above Dividends Declared " Retained Earnings, Dec 31 carry forward Cash Accounts Receivable Inventory Land Buildings & Equipment Invstmt in Schwinn Stock " Goodwill Total Debits Accumulated Depreciation Accounts Payable Bonds Payable Common Stock R/E, from above Non-Controlling Interest " Pinarello Inc. (800.0) (20.3) (820.3) Schwinn Inc. Ref. (400) (400) 390.0 70.0 40.0 500.0 282 38 10 330 (320.3) (288.0) (320.3) 160.0 (70) (180) (70) 20 (448.3) (230) 188.0 196.0 286.0 322.0 1,400.0 526.3 120 100 150 120 1,200 2,918.3 (560.0) (310.0) (600.0) (1,000.0) (448.3) 1,690 (640) (120) (280) (420) (230) Debit Credit Consolidation Total Credits (2,918.3) (1,690) ACC 4303 Name: Hina Rehman Durran Consolidation Worksheet 12/31/2011 negative numbers indicate a credit balance Sales Income from Schwinn Credits Account Pinarello Inc. Schwinn Inc. -800,000 -400,000 -20,300 -820,300 -400,000 Cost of Goods Sold Deprecation Expense Other Expenses Debits 390,000 70,000 40000 500,000 282,000 38,000 10000 330,000 -320,300 -288,000 -320,300 160,000 -70,000 -180,000 -70,000 20,000 -448,300 -230,000 188,000 196,000 286,000 322,000 1,400,000 526,300 120,000 100,000 150,000 120,000 1,200,000 -560,000 -310,000 -600,000 -1,000,000 -448,300 -640,000 -120,000 -280,000 -420,000 -230,000 Consolidated Net Income Income to NCI Income, carry forward Retained Earnings, Jan 1 Income, from above Dividends Declared Retained Earnings, Dec 31 Carry forward Cash Accounts Receivable Inventory Land Buildings & Equipment Investment in Schwinn Stock Goodwill Total Debits Accumulated Depreciation Accounts Payable Bonds Payable Common Stock R/E, from above Non-Controlling Interest Total Credits ame: Hina Rehman Durrani Eliminations Debit Credit Consolidation Journal Entries Entry SA Common Stock Retained Earnings Goodwill Inventory Equipment Investment Non-controlling interest Entry I Income From Schwinn Dividends (20,000 X.70) Investment Income Assigned to Schwinn Dividends (20,000X.30) Non-Controlling interest Entry D Depreciation Expense Accumulated Depreciation 420,000 180,000 2000 30,000 110,000 520,000 222,000 20,300 14,000 6300 8700 6000 2700 11,000 11,000 Entry C Cost of Goods Sold Inventory 30,000 30,000 ACC 4303 Name: Hina Rehman Durran Consolidation Worksheet 12/31/2011 negative numbers indicate a credit balance Sales Income from Schwinn Credits Account Pinarello Inc. Schwinn Inc. -800,000 -400,000 -20,300 -820,300 -400,000 Cost of Goods Sold Deprecation Expense Other Expenses Debits 390,000 70,000 40000 500,000 282,000 38,000 10000 330,000 -320,300 -288,000 -320,300 160,000 -70,000 -180,000 -70,000 20,000 -448,300 -230,000 188,000 196,000 286,000 322,000 1,400,000 526,300 120,000 100,000 150,000 120,000 1,200,000 -560,000 -310,000 -600,000 -1,000,000 -448,300 -640,000 -120,000 -280,000 -420,000 -230,000 Consolidated Net Income Income to NCI Income, carry forward Retained Earnings, Jan 1 Income, from above Dividends Declared Retained Earnings, Dec 31 Carry forward Cash Accounts Receivable Inventory Land Buildings & Equipment Investment in Schwinn Stock Goodwill Total Debits Accumulated Depreciation Accounts Payable Bonds Payable Common Stock R/E, from above Non-Controlling Interest Total Credits ame: Hina Rehman Durrani Eliminations Debit Credit Consolidation -1,200,000 -20,300 30,000 11,000 702,000 119,000 50000 871,000 8700 180,000 70,000 14,000 30,000 110,000 2000 420,000 180,000 -6,000 -288,000 -320,300 188,000 Journal Entries Entry SA Common Stock Retained Earnings Goodwill Inventory Equipment Investment Non-controlling interest Entry I Income From Schwinn Dividends (20,000 X.70) Investment Income Assigned to Schwinn Dividends (20,000X.30) Non-Controlling interest Entry D Depreciation Expense Accumulated Depreciation 420,000 180,000 2000 30,000 110,000 520,000 222,000 20,300 14,000 6300 8700 6000 2700 11,000 11,000 Entry C Cost of Goods Sold Inventory 30,000 30,000