It is the end of 2019, and you have been asked to create financial statements for...

   

Transcribed Image Text:

It is the end of 2019, and you have been asked to create financial statements for the year. Your manager has given you the trial balance on the left. Accounts Cash Accounts Receivable Supplies Equipment 31-Dec-19 Land Accounts Payable Notes Payable Owner's Capital Owner's Withdrawal Consulting Revenue Rent Expense Wage Expense Insurance Expense Advertising Expense Tax Expense Totals DR 22000 13000 2600 5000 20000 4600 15000 30000 3000 6250 7350 CR 9500 15600 28000 75700 128800 128800 Using Excel, create the following: • Income Statement • Balance Sheet • Statement of Owner's Equity It is the end of 2019, and you have been asked to create financial statements for the year. Your manager has given you the trial balance on the left. Accounts Cash Accounts Receivable Supplies Equipment 31-Dec-19 Land Accounts Payable Notes Payable Owner's Capital Owner's Withdrawal Consulting Revenue Rent Expense Wage Expense Insurance Expense Advertising Expense Tax Expense Totals DR 22000 13000 2600 5000 20000 4600 15000 30000 3000 6250 7350 CR 9500 15600 28000 75700 128800 128800 Using Excel, create the following: • Income Statement • Balance Sheet • Statement of Owner's Equity