Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2048 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 Common Stock Retained Earnings Dividends Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Net income 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. Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 2048 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 Common Stock Retained Earnings Dividends Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Net income
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started