Exercise 4-3 Preparing a work sheet L01 CHECK FIGURE: 3. Adjusted trial balance columns= $358.200 The December 31, 2017, unadjusted trial balance for Musical Sensations after its second year of opera- tions follows: 93 5 Home P18 Musical Sensations Work Sheet.xls SOLVE T excel insert Page Layout Formula Dato Data Review View fx A Musical Sensations Work Sheet December 31, 2017 6 7 Cash 8 Accounts receivable 9 Office supplies 10 Musical equipment 11 Accumulated depreciation, musical equipment Account 12 Accounts payable 13 Uneamed performance revenue 14 Jim Daley, capital 15 Jim Daley, withdrawals 16 Performance revenue 17 Salaries expense 18 Travelling expense 19 Totals B Unadjusted Trial Balance Debit $ 7,500 14,200 790 125,000 52,000 86,000 45,010 $ 330,500 C Credit $ 21.600 4,200 12,400 154,300 138,000 $ 330,500 Required 1. Enter the unadjusted trial balance onto a work sheet. 2 Using the following additional information, enter the adjustments into the work sheet: a. A review of the Unearned Performance Revenue account revealed a balance remaining of $9,225. b. Annual depreciation on the musical equipment is $21,600. e. Accrued salaries at December 31 totalled $6,100. d. It was determined that $650 of the balance in the Office Supplies account had been used. 3. Complete the work sheet. 4. Calculate the balance in the capital account as it would appear on the December 31, 2017, balance sheet.

Exereise 4-3 Preparing a werk sheet Lo1 excel CHECK FEURE: 3. Adjusted trial balance columns =$358.200 The December 31, 2017, unadjusted trial balance for Musical Sensations after its second gear of operathons follows Aequired 1. Enter the unadjusted trial balance onto a work sheec. 2. Using the following additional information, enter the adfustanents into the work sheet: a. A review of the Unearned Performance fievenue account revealed a balance remaining of 90,225 b. Annual depreciation on the musical equipment is 821,600 . c. Accrued salaries at December 31 totalled \$8,100. d. It was determined that M60 of the balance in the Ornce Supplies account had been used. 3. Complete the work sheet. 4. Galculate the balance in the capital account as it would appear on the December 31, 2017, talance sheet