I need help filling out this chart in excel? Thank you. Zoom in if you can\'t se

Question

I need help filling out this chart in excel? Thank you. Zoom in if you can't see.

14 15 16 17 18 19 20 21 Balance Sheet Assets Liabilities Stockholders' E Capital Wages Statement of Cash Flows Accounts Accum Accounts Unearned Notes Retained Payable+Revenue Payable Payable + Stock Earnings ncome Cash Receivable Prepaid Ins. Supplies Building De + Land Statement Inc. b/f adj Ins. exp Balances brought forward Jan. 31 Insurance exp Balances Jan. 31 Supplies exp Balances Jan. 31 Depr. exp Balances Jan. 31 Rent revenue Balances Jan. 31 Wages exp Balances Jan. 31 Fees earned Balances Net incr. (decr.) in cash Beginning cash balance Ending cash balance Supplies exp." 23 24 25 26 Depr. exp Rent rev Wages exp 28 29 30 31 32 Fees earned Net income 34

Explanation / Answer

Accounts Prepaid Accumulated Accounts Unearned Wages Notes Capital stock Retained Cash Receivable insurance Supplies Building depreciation Land Payable revenue Payable Payable Earnings Balance Jan 1 20000 34500 700 1000 150000 -11200 120000 7500 0 0 30000 50000 227500 Jan 1 Rent received 15000 0 15000 Balance 35000 34500 700 1000 150000 -11200 120000 7500 0 0 30000 50000 242500 Jan 1 Insurance -4200 -4200 30800 34500 700 1000 150000 -11200 120000 7500 0 0 30000 50000 238300 Jan 6 supplies 1800 1800 30800 34500 700 2800 150000 -11200 120000 9300 0 0 30000 50000 238300 Jan 9 Service 27500 -27500 0 58300 7000 700 2800 150000 -11200 120000 9300 0 0 30000 50000 238300 Jan 11 Creditors -3000 -3000 55300 7000 700 2800 150000 -11200 120000 6300 0 0 30000 50000 238300 Jan 18 investment 25000 25000 80300 7000 700 2800 150000 -11200 120000 6300 0 0 30000 75000 238300 Jan 20 Biiling 62000 62000 80300 69000 700 2800 150000 -11200 120000 6300 0 0 30000 75000 300300 Jan 25 Service 12900 12900 93200 69000 700 2800 150000 -11200 120000 6300 0 0 30000 75000 313200 Jan 30 Expenses -37700 -37700 55500 69000 700 2800 150000 -11200 120000 6300 0 0 30000 75000 275500 Jan 30 dividends -15000 -15000 40500 69000 700 2800 150000 -11200 120000 6300 0 0 30000 75000 260500

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.