pls answer it thanks

Presented the trial balance of sir G merchandising for December 31, 2020 Prepare a 10-column worksheet.

2 3 Trial Balance December 31, 2020 4 Credit 5 6 Debit 100,000.00 101,000.00 7 8 9 27,000.00 10 11 465,000.00 80,000.00 5,000.00 15,000.00 28,000.00 12 13 14 15 16 17 18 8,000.00 60,000.00 54.000.00 105,000.00 461,600.00 19 30,000.00 20 888,000.00 21 Cash Accounts Receivable Allowance for Bad Debts Notes Receivable Merchandise Inventory Office Supplies Prepaid Insurance Furniture and Fixtures Accum. Depreciation - Furniture & Fixtures Accounts Payable Notes Payable Mortage Payable Sir G, Capital Sir G, Drawing Sales Sales Returns & Allowances Sales Discount Purchases Freight-In Purchase Returns & Allowances Purchase Discount Sales Salaries Expense Utilities Expense - Store Office Salaries Utilities Expense - Office Bad Debts Expense Office Supplies Expense Interest Expense Interest Income Rent Income Totals 22 51,000.00 38,000.00 550,000.00 25,000.00 23 24 25 92,000.00 18,000.00 26 27 28 29 30 123,000.00 8,900.00 90,000.00 10,200.00 3,000.00 5,500.00 10,000.00 31 32 33 34 35 25,000.00 20,000.00 1,738,600.00 36 1,738,600.00 27 A B D E 77 G 1 2 3 4 a. Office Supplies expense for the year is P1,000 b. Annual depreciation of store furniture and fixtures is P2,500 c. Store Insurance Expense for the year is P8000 d. Unpaid sales salaries at year-end is P17,000 e. A physical count of the merchandise inventory at year-en showed unsold merchandise amounting to P60,000 5 6 7 8 4 No. Account Title Trial Balance Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Cash Accounts Receivable Allowance for Bad Debts Notes Receivable Merchandise Inventory Office Supplies Prepaid Insurance Furniture and Fixtures Accum. Depreciation - Furniture & Fixtures Accounts Payable Notes Payable Mortage Payable Sir G, Capital Sir G, Drawing Sales Sales Returns & Allowances Sales Discount Purchases Freight-In Purchase Returns & Allowances Purchase Discount Sales Salaries Expense Utilities Expense - Store Office Salaries Utilities Expense - Office Bad Debts Expense Office Supplies Expense Interest Expense Interest Income 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Rent Income 36 37 Totals 38