Problem 4-1A Completing a work sheet L01 excel CHECK FIGURE: 3. Adjusted trial balance columns = $646,265 The March 31, 2020, unadjusted trial balance for Silva Rentals after its first year of operations is shown below: Silva Rentals Trial Balance.xlsx mert Page Layout Fom P1B Silva Rentals Unadjusted Trial Balance March 31, 2020 Unadjusted 5 Trial Balance 6 No. Account Dr. Cr. 7 101 Cash $ 7.000 8 110 Rent receivable 31.000 4 124 Office supplies 2.250 10 141 Notes receivable, due 2023 46.000 11 161 Fumitur 16.000 12 173 Building 216.000 13 183 Land 41,000 14 191 Patent 9.600 15 201 Accounts payable $ 13.750 16 252 Long-term note payable 175,000 17 301 Stephen Silva, capital 40.250 18 302 Stephen Silva, withdrawals 92.000 19 406 Rent revenue 328.800 20 620 Office salaries expense 52.000 21 633 Interest expense 5.250 22 655 Advertising expense 14,600 23 673 Janitorial expense 41.000 24 640 Utilities expense 34.100 25 Totals $ 607.800 $ 607.800 Required 1. Enter the unadjusted trial balance onto a work sheet. 2. Using the following additional information, enter the adjustments into the work sheet (the Chart of Accounts in Appendix IV may be useful when additional accounts are required): a. It was determined that the balance in the Rent Receivable account at March 31 should be $36,000. b. A count of the office supplies showed $1,830 of the balance had been used. c. Annual depreciation on the building is $25,000 and $3,500 on the furniture. d. The two part-time Office staff members each get paid $1,600 biweekly. The last biweekly pay period ended Friday, March 20. At March 31, six days' salary had accrued. 6. A review of the balance in Advertising Expense showed that $2,400 was for advertisements to appear in the April issue of Page 288 Canadian Business magazine f. Accrued utilities at March 31 totalled $2,620. 8. March interest of $425 on the long-term note payable is unrecorded and unpaid as of March 31. 3. Complete the work sheet