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, 2043 Adjusted Trial Balance Income Statement Account Title Dr. Cr. Dr. Cr. Balance Sheet Dr. Cr. Cash 12 Accounts Receivable 103 4 2 190 SO Supplies Prepaid Insurance Land Equipment Accum. Depr.-Equipment Accounts Payable Wages Payable Common Stock 7 36 1 50 210 Retained Earnings Dividends 8 213 111 Fees Earned Wages Expense Rent Expense Insurance Expense 12 10 Iee Ennen Complete the following end-of-period spreadsheet for Alert Security Services Co. If an amount 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, 2013 Account Title Adjusted Trial Balance Adjusted Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet Debit Credit Credit Debit Credit Cash 12 Accounts Receivable 103 10 Supplies Prepaid Insurance 2 Deble . 4 190 190 50 7 7 Land Equipment Accum. Dept Equipment Accounts Payable Wages Payable Common Stock 36 1 1 50 50 210 210 Retained Earnings Dividends 8 Fees Eamed 213 213 111 11 X Wages Expense Rent Expense Insurance Expense 12 10 Check My Work 50 7 7 Equipment Accum. Depr.- Equipment Accounts Payable Wages Payable Common Stock 36 1 50 50 210 210 Retained Earnings Dividends Fees Earned 8 213 213 111 11 12 10 Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense- Equip. Miscellaneous Expense 1000 6 4 3 2 Totals 517 517 517 X 148 x 213 X 369 X Net Income (loss)