Old MathJax webview

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 of 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. End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2015 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Title Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance office Equipment Accum. Depreciation Accounts Payable Salaries Payable Unearned Fees Kelly Pitney, Capital Kelly Pitney, Drawing Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Net Income ACCOUNT TITLE DEBIT CREDIT 1 Cash 22.100.00 2 Accounts Receivable 3,400.00 3 Supplies 1,350.00 4 Prepaid Rent 3,200.00 5 Prepaid Insurance 1,500.00 6 Office Equipment 14,500.00 7 Accumulated Depreciation 350.00 8 Accounts Payable 800.00 9 Salaries Payable 120.00 10 Unearned Fees 2,500.00 11 Kelly Pitney, Capital 42,300.00 12 Totals 46.050100 46.050.00 Kelly Consulting Adjusted Trial Balance May 31, 2015 Account Title Debit Balances Credit Balances Cash 44,195 Accounts Receivable 8,080 Supplies 715 Prepaid Rent 1,600 Prepaid Insurance 1,225 Office Equipment 14,500 Accumulated Depreciation 660 Accounts Payable 895 Salaries Payable 325 Unearned Fees 3,210 Kelly Pitney, Capital 42,300 Kelly Pitney, Drawing 10,500 Fees Earned 40,000 Salaries Payable 1,705 Rent Expense 1,600 Supplies Expense 1,370 Depreciation Expense 330 Insurance Expense Miscellaneous Expense 1295 87,390 87,390 Kelly Consulting UNADJUSTED TRIAL BALANCE May 31, 2015 ACCOUNT TITLE DEBIT CREDIT 1 Cash 44,195,00 2 Accounts Receivable 8,080.00 3 Supplies 2,085.00 4 Prepaid Rent 3,200.00 5 Prepaid Insurance 1,500.00 6 Office Equipment 14,500.00 7 Accumulated Depreciation 330.00 8 Accounts Payable 895.00 9 Salaries Payable 10 Unearned Fees 7,000.00 11 Kelly Pitney, Capital 42,300.00 12 Kelly Pitney, Drawing 10,500.00 13 Fees Earned 36,210.00 14 Salary Expense 1,380.00 15 Rent Expense