Appendix 1: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 386 Accounts Receivable 2,834 Supplies 129 Prepaid Insurance 97 Land 3,220 Equipment 1,288 Accum. Depr.-Equipment 258 Accounts Payable 1,159 Wages Payable 129 Common Stock 40 Retained Earnings 5,562 Dividends 258 Fees Earned 3,156 Wages Expense 773 Rent Expense 386 Insurance Expense 322 Utilities Expense 225 Supplies Expense 193 129 Depreciation Expense-Equip. Miscellaneous Expense 64 10,304 10,304 10,304 10,304 Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Enter all amounts as positive numbers. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y3 Adjusted Trial Balance Debit Adjusted Trial Balance Credit Income Statement Debit Income Statement Credit Balance Sheet Debit Balance Sheet Credit 386 Account Title Cash Accounts Receivable 2834 Supplies 129 Prepaid Insurance 97 Land 3220 Equipment 1288 Accum. Depr.-Equipment 258 Accounts Payable 1159 Wages Pa 129 Common Stock 40 Retained Earnings 5562 Dividends 258 Fees Earned 3156 Wages Expense 773 Rent Expense 386 Insurance Expense 322 Utilities Expense 225 Supplies Expense 193 Depreciation Expense-Equip. 129 Miscellaneous Expense 64 Totals 10304 10304 10304 Net income (loss)