Appendix 1: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business dients. 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 12 Accounts Receivable 103 4 Supplies Prepaid Insurance 2. Land 190 50 Equipment Accum. Depr.-Equipment 7 36 Accounts Payable 1 Wages Payable Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 213 Wages Expense 111 Rent Expense 12 Insurance Expense 10 6 Litilities Finance Utilities Expense 6 Supplies Expense 4 Depreciation Expense-Equip. 3 N Miscellaneous Expense 517 517 Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2083 Adjusted Trial Balance Income Statement Credit Debit Account Title Adjusted Trial Balance Debit Income Statement Credit Balance Sheet Debit Balance Sheet Credit 12 103 Cash Accounts Receivable Supplies Prepaid Insurance Land 4 2 190 50 7 Equipment Accum. Depr.Equipment Accounts Payable Wages Payable Common Stock 36 1 50 210 Retained Earnings Dividends 8 Fees Earned 213 111 12 10 Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense- Equip 6 3 Previous Next > heck My Work Save and Exit All work saved Submit Assignment for Gradin eBook Calculator 12 103 4 Accounts Receivable Supplies Prepaid Insurance Land Equipment 2 190 50 Accum. Depr-Equipment 7 36 1 Accounts Payable Wages Payable Common Stock Retained Earnings Dividends 50 210 8 Fees Earned 213 111 12 10 Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense- Equip Miscellaneous Expense 4 3 2 Totals 517 517 Net Income (loss)