Appendix EX 4-25 Completing an end-of-period spreadsheet (work sheet)

Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet (work sheet) for Alert Security Services Co.


Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2014
Adjusted
Trial Balance
Income
Statement
Balance
Sheet
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12
Accounts Receivable 103
Supplies 4
Prepaid Insurance 2
Land 190
Equipment 50
Accum. Depr.—Equipment 7
Accounts Payable 36
Wages Payable 1
Brenda Schultz, Capital 260
Brenda Schultz, Drawing 8
Fees Earned 213
Wages Expense 111
Rent Expense 12
Insurance Expense 10
Utilities Expense 6
Supplies Expense 4
Depreciation Expense 3
Miscellaneous Expense 2
517 517
Net income (loss)


Answer:

ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2014
Account Title
Adjusted
Trial Balance
Income
Statement
Balance
Sheet
Debit Credit Debit Credit Debit Credit
Cash 12 12
Accounts Receivable 103 103
Supplies 4 4
Prepaid Insurance 2 2
Land 190 190
Equipment 50 50
Accum. Depr.—Equipment 7 7
Accounts Payable 36 36
Wages Payable 1 1
Brenda Schultz, Capital 260 260
Brenda Schultz, Drawing 8 8
Fees Earned 213 213
Wages Expense 111 111
Rent Expense 12 12
Insurance Expense 10 10
Utilities Expense 6 6
Supplies Expense 4 4
Depreciation Expense 3 3
Miscellaneous Expense 2 2
Totals 517 517 148 213 369 304
Net income (loss) 65 65
213 213 369 369