Comprehensive Problem 1 Part 5: Work Sheet The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts 1, 2, 3, 4 before completing part 5. Part 5: Enter the unadjusted trial balance on an end-of-period spreadsheet (work sheet) and complete the spreadsheet using the following adjustment data. Insurance expired during May is $275. Supplies on hand on May 31 are $715. Depreciation of office equipment for May is $330. Accrued receptionist salary on May 31 is $325. Rent expired during May is $1,600. Unearned fees on May 31 are $3,210. If an amount box does not require an entry, leave it blank or enter "0". Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2014 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Title Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash 4500 Accounts Receivable 4500 Supplies Prepaid Rent Prepaid Insurance Office Equipment Accum. Depreciation 330 Accounts Payable 800 Salaries Payable 120 Unearned Fees 2500 Capital Stock 42300 Retained Earnings Dividends Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Net Income