Required:

Preparing the worksheet of the information given in MS Excel

AGZ fx E F H 1 J K L M O P Q R S . B D Preparing the worksheet of the information given in MS Excel 2 3 N Liability Equity Revenue Expense 4 ABC Company Worksheet For the Year Ended December 31, 2020 5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Statement of Financial Position 6 Account Titles Accounts Type! Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 12000 35000 40000 36000 8000 ??? ??? ??? ??? ??? 12000 5000 ??? Asset Asset Asset Asset Asset Revenue Liability Expense Expense Asset Expense Equity Asset 130000 15000 ??? ??? ??? 7 8 Cash 9 Bank 10 Land 11 Perpaid Rent 12 Furniture 13 Service Revenue 14 Accounts Payable 15 Phone Expense 16 Electricity Expense 17 Accounts Receivable 18 Salaries & Wages Expenses 19 Capital 20 Supplies 21 Totals 22 Rent Expense 23 Supplies Expense 24 Salaries & Wages Payable 25 Depre. Expense-Furniture 26 Accum. Depre. -Furniture 27 28 3000 1500 5500 50000 ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? 5000 4000 ??? 50000 ??? 2400 ??? 4000 ??? ??? 12000 2400 ??? ??? Expense Expense Liability Expense Asset 4000 ??? 870 ??? ??? 870 ??? Totals ??? ??? ??? Profit/Loss Totals ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? 29