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 538 Accounts Receivable 3,942 179 Supplies Prepaid Insurance 134 Land 4,480 Equipment 1,792 358 Accum. Depr.-Equipment Accounts Payable 1,613 Wages Payable 179 Common Stock 40 Retained Earnings 7,756 Dividends 358 Fees Earned 4,390 Wages Expense 1,075 Rent Expense 538 Insurance Expense 448 Utilities Expense 314 Supplies Expense 269 Depreciation Expense-Equip. 179 Miscellaneous Expense 90 14,336 14,336 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 Account Title Adjusted Trial Balance Debit Adjusted Trial Balance Credit Income Statement Debit Income Statement Credit Balance Sheet Debit Balance Sheet Credit Cash 538 Accounts Receivable 3942 1111 III 110 Supplies 179 Prepaid Insurance 134 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 Income Income Adjusted Trial Statement Balance Credit Statement Debit Credit Account Title Adjusted Trial Balance Debit Balance Balance Sheet Debit Sheet Credit Cash 538 Accounts Receivable 3942 Supplies 179 Prepaid Insurance 134 Land 4480 Equipment 1792 358 Accum. Depr.- Equipment Accounts Payable 1613 Wages Payable 179 Common Stock 40 Retained Earnings 7756 Dividends 358 358 Accum. Depr.- Equipment Accounts Payable 1613 Wages Payable 179 Common Stock 40 Retained Earnings 7756 Dividends 358 Fees Earned 4390 Wages Expense 1075 Rent Expense 538 Insurance Expense 448 Utilities Expense 314 Supplies Expense 269 179 Depreciation Expense-Equip. Miscellaneous Expense 90 Totals 14336 14336 14336 Net income (loss)