fllied the table pls based on the question

Problem 4-2A Completing a work sheet L01 eXcel CHECK FIGURE: 3. Adjusted trial balance columns = $67,380 The June 30, 2020, unadjusted trial balance for Trenton Consulting after its first year of operations follows: 1 2 4 Home P18 Trenton Consulting Trial Balance.xlsx fo Trenton Consulting Unadjusted Trial Balance June 30, 2020 5 6 7 Cash 8 Accounts receivable 9 Prepaid rent 10 Equipment 11 Accounts payable 12 Toni Trenton, capital 13 Toni Trenton, withdrawals 14 Consulting revenue 15 Wages expense 16 Insurance expense 17 Rent expense 18 Totals Account Unadjusted "Trial Balance DF 680 2,900 3,660 9,600 6,880 24,920 1,620 8,320 58,580 Cr. 1,730 26,650 30,200 58,580 Required 1. Enter the unadjusted trial balance onto a work sheet. 2. Using the following additional information, enter the adjustments onto the work sheet: a. Annual depreciation on the equipment is $1,500. b. The balance in the Prepaid Rent account is for six months of rent commencing March 1, 2020. c. Unpaid and unrecorded wages at June 30 totalled $3,200. d. Accrued revenues at June 30 totalled $4,100. 3. Complete the work sheet. 4. Calculate the balance in the capital account as it would appear on the June 30, 2020, balance sheet. Analysis Component: What effect does a loss have on the accounting equation? 718 " 10 11 12 13 14 15 16 17 18 #PRERAZARREARS23RRS 19 20 40 No. 101 110 124 141 161 173 83888888 183 Land 101 Patent (20 673 090 Cash Rent receivable Office supplies Notes receivable, due 2023 Furniture Bulding Accounts payable Long-term note payable Capital Withdrawals Account Rent revenue office salaries expense Interest experee Advertising expense Janitorial expense Ubities expense Totals Totals Profit Total Unadjusted Trial Balance Debit Credit 7.000 31,000 2.250 46,000 16,000 216,000 41,000 9,600 12.000 12.000 5,250 14.600 41,000 34,100 D 607,80 $3,750 175,000 90,250 328,000 607,800 Silve Rentals Work Sheet For Year Ended March 31, 2020 Adjustments Debit Credit Adjusted Trial Balance Credit Debit Income Statement Debit Credit N Balance Sheet & Debit Credit O P