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, 20 Y8 Accum. Depreciation Accounts Payable Salaries Payable Unearned Fees Common Stock Retained Earnings Dividends 10,500 0 0 Fees Earned Salary Expense 1,380 36,210 Rent Expense Supplies Expense 0 0325 Depreciation Expense Insurance Expense 0 01,600 x Miscellaneous Expense 1,295 01,370 x Miscellaneous Expense Net income Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 20 Y8