One Page One Chapter 04 Homework Alert Security Services Co, offers security services to business clients. The trial balance for Alert Security Services has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2013: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2013 Unadjusted Trial Balance. Cr. Adjustments Adjusted Trial Balance Dr. Cr. Dr. Cr. Account Title Dr. Cash 12 Accounts Receivable 90 Supplies B Prepaid Insurance 12 Land 190 Equipment 50 Accum. Depr-Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends 50 ' 210 Fees Earned 200 Wages Expense 110 Rent Expense 12 Insurance Expense 0 Utates Expense 6 Supplies Expense 0 Deprecation Expense-tou 0 Miscellaneous Expense 500 500 Problem One Page 2 The data for year-end adjustments are as follows: a. Fees earned, but not yet billed, $13. b. Supplies on hand, $4. c. Insurance premiums expired, $10. d. Depreciation expense, $3. e. Wages accrued, but not paid, $1. Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. If a box does not require an entry, leav Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2013 Account Title Debit Unadjusted Unadjusted Trial Balance Trial Balance Credit Adjusted Adjustments Adjustments Debit Credit Adjusted Trial Balance Trial Balance Debit Credit Cash 12 Accounts Receivable 90 Supplies 8 Prepaid Insurance 12 Land 190 Equipment 50 Accum. Depr.-Equipment Accounts Payable 36 Wages Payable 0 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 200 Wages Expense 110 Rent Expense 12 Insurance Expense 0 Utilities Expense 6 Supplies Expense Depreciation Expense-Equip. Miscellaneous Expense 2 Totals 500 500 Problem two page one Complete the following end-of-period spreadsheet for Alert Security Services Co. If an amount box does not require an entry, leav Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2013 Adjusted Adjusted Income Income Balance Balance Trial Balance Trial Balance Statement Statement Sheet Sheet Credit Debit Credit Debit Credit Account Title Debit Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190. Equipment 50 Accum. Depr.-Equipment Accounts Payable 7 36 Wages Payable 1 Common Stock Retained Earnings Dividends Fees Earned 50 210 00 8 213 Wages Expense 111 Rent Expense 12 Insurance Expense 10 Utilities Expense 6 Supplies Expense 4 3 Depreciation Expense-Equip. Miscellaneous Expense Totals Net income (loss) 517 517 Problem two page two Complete the following end-of-period spreadsheet for Alert Security Services Co. If an amount box does not require an entry, le Account Title Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y3 Adjusted Income Adjusted Income Trial Balance Trial Balance Statement Statement Credit Debit Credit Balance Balance Sheet Sheet Debit Credit Debit Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr.-Equipment 7 36 1 Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned 50 210 00 8 213 Wages Expense 111 Rent Expense 12 Insurance Expense 10 Utilities Expense 6 Supplies Expense 4 Depreciation Expense-Equip. 3 Miscellaneous Expense 2 Totals 517 517 Net income (loss) Problem three page one Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance Income Statement Balance Sheet Cr. Dr. Cr. Dr. Cr. Account Title Dr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment Accum. Depr.-Equipment Accounts Payable 50 7 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 213 Wages Expense 111 Rent Expense 12 Insurance Expense 10 Utilities Expense 6 Supplies Expense 4 Depreciation Expense-Equip. Miscellaneous Expense 3 2 517 517 Problem three page two Problem three page three Current assets: Alert Security Services Co. Balance Sheet October 31, 2013 Assets Total current assets Property, plant, and equipment: Total property, plant, and equipment Total assets Liabilities Current liabilities: Total liabilities Stockholders' Equity Total stockholders' equity Total liabilities and stockholders' equity