Create an end-of-period spreadsheet using the data included.

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. a. Insurance expired during May is $275. b. Supplies on hand on May 31 are $715. c. Depreciation office equipment for May is $330. d. Accrued receptionist salary on May 31 is $325. e. Rent expired during May is $1,600. f. Unearned fees on May 31 are $3,210. If an amount box does not require an entry, leave it blank. Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2015 Adjustments Unadjusted Trial Balance Adjusted Trial Balance Credit Debit Credit Debit Debit Credit Account Title Cash Accounts Receivable Supplies I Prepaid Rent Prepaid Insurance Office Equipment Accum. Depreciation Accounts Payable Salaries Payable Unearned Fees Kelly Pitney, Capital Kelly Pitney, Drawing Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2045 Income Statement Balance Sheet Adjustments Adjusted Trial Balance Credit Credit Credit Debit Credit Debit Debit Debit a. Insurance expired during May is $275. Account Name Post. Ref. Insurance Expense Prepaid Insurance b. Supplies on hand on May 31 are $715. Account Name Post. Ref. Supplies Expense Supplies c. Depreciation of office equipment for May is $330. Account Name Post. Ref. Depreciation Expense Accumulated Depreciation Depreciation Expense Accumulated Depreciation d. Accrued receptionist salary on May 31 is $325. Account Name Post. Ref. Salary Expense Salaries Payable e. Rent expired during May is $1,600. Account Name Post. Ref. Rent Expense Prepaid Rent f. Unearned fees on May 31 are $3,210. Account Name Post. Ref. Unearned Fees Fees Earned