5. EX.04.23.ALGO (Algorithmic) Appendix 1: Financial Statements From 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 491 Accounts Receivable 3,599 Supplies 164 Prepaid Insurance 123 Land 4,090 1,636 Equipment 327 1,472 Accum. Depr.-Equipment Accounts Payable Wages Payable Common Stock Retained Earnings 164 40 7,078 Dividends 327 Dividends 327 Fees Earned 4,008 Wages Expense 982 491 Rent Expense Insurance Expense 409 286 Utilities Expense Supplies Expense Depreciation Expense-Equip. 245 164 Miscellaneous Expense 82 13,089 13,089 Prepare an income statement for Alert Security Services Co. Alert Security Services Co. Income Statement For the Year Ended October 31, 2013 Expenses: $ Total expenses $ Prepare a statement of stockholders' equity for Alert Security Services Co. During the year ended October 31, 20Y3, common stock of $7 was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Alert Security Services Co. Statement of Stockholders' Equity For the Year Ended October 31, 2013 Common Stock Retained Earnings Total $ $ Prepare a balance sheet for Alert Security Services Co. Alert Security Services Co. Balance Sheet October 31, 2013 Assets Current assets Alert Security Services Co. Balance Sheet October 31, 2013 Assets Current assets: Total current assets Property, plant, and equipment: $ $ Total property, plant, and equipment Total assets Liabilities Current liabilities: $ Total liabilities Total liabilities Stockholders' Equity Total stockholders' equity Total liabilities and stockholders' equity