Please use your own data to fill the consolidation worksheet and elimination entries CHART. Thank you!

Here is an example.

Just make some reasonable data is good, thank you!

0 Company B Company J Adjustments and Eliminations Credit B and J Consolidated Debit Debit Credit Debit Credit Debit Credit 3 Blance Sheet and Income Statament Accounts 4 Accounts Receivable 5 Investment in Stock of Company B 6 Other Assets 7 Accounts Payable 8 Other Liabilities 9 Common Stock 10 Retained Earning: 300,000 805,000a 3,150,000 35,000 (2) 22,000313,000 (1) 805,000 1,013,000 4,163,000 85,000 280,000 10,000 25,000 (2) 220,000 538,000 (1) 88,000 500,000 10,000 22,000 538,000 Company B Company J 4,405,000 4,405,000 257,000 (1) 250,000 (3) 257,000 300,000 10,000 13 Sales 14 Equity in Earnings of Company B 15 Cost of Goods Sold 16 Depreciation Expense 17 Administrative Expense 18 Income Tax Expense 519,000 10,000 469,000 540,000 220,000 90,000 204,000 90,000 60,000 50,000 42,000 (3) 300,000 330,000 280,000 140,000 246,000 Totals 4,504,000 5,309,000 1,290,000 1,290,000 1,127,000 1,127,000 5,472,000 5,472,000 20 23 Eliminating the parent company's investment account 25 Common Stock -from books of Company B 26 Retained Earnings (Company B) 27 Equity in Earnings of Company - B from books of Company J 28 29 30 Eliminating the Intercompany Receivables and Payables 538,000 257,000 10,000 Investment in Stock of Company B-from books of company J 805,000 32 Accounts Payable 22,000 Account Receivable 22,000 34 35 Eliminating of Intercompany Sales and Purchases 36 37 Sales 38 10,000 Cost of Goods Sold 10,000