solve please

Problem 4-2A Completing a work sheet LO1 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: Trenton Consulting Trial Balance.xisx Home Insert Page Layout Formulas Review P18 A B C Trenton Consulting Unadjusted Trial Balance June 30, 2020 Unadjusted Trial Balance 6 Account Dr. Cr. 7 Cash 680 8 Accounts receivable 2,900 q Prepaid rent 3,660 10 Equipment q,600 11 Accounts payable 1,730 12 Toni Trenton, capital 26,650 13 Toni Trenton, withdrawals 6,880 14 Consulting revenue 30,200 15 Wages expense 24,920 16 Insurance expense 1,620 17 Rent expense 8,320 18 Totals 58,580 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