1)

2)

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of- period spreadsheet for the year ended October 31, 2019. In addition, the data for year-end adjustments are as follows: a. Fees earned, but not yet billed, $26. b. Supplies on hand, $7. c. Insurance premiums expired, $33. d. Depreciation expense, $13. e. Wages accrued, but not paid, $13. Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. If a box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2019 Unadjusted Trial Balance Dr. cr. Adjustments Dr. cr. Adjusted Trial Balance Dr. cr. Account Title Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment 132 Accum. Depr.-Equipment Accounts Payable Wages Payable Brenda Schultz, Capital IIIIIIIIII Brenda Schultz, Drawing Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense Totals 1,050 1,050 Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2019 Adjusted Trial Balance Income Statement Balance Sheet Dr. Account Title Dr. Cr. Dr. Cr. Cash 289 Accounts Receivable 2,121 Supplies Prepaid Insurance Land 2,410 Equipment 964 Accum. Depr.-Equipment Accounts Payable Wages Payable Brenda Schultz, Capital 4,192 Brenda Schultz, Drawing Fees Earned 2,362 Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense Totals 7,711 Net income (loss)