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, 2045. In addition, the data for year-end adjustments are as follows: : a. Fees earned but not yet billed, $23. b. Supplies on hand, $6. c. Insurance premiums expired, $29. d. Depreciation expense, $12. e. Wages accrued but not paid, $12. Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. If an amount 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, 2045 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 87 Accounts Receivable 232 Supplies 23 Prepaid Insurance 35 Land 290 Equipment 116 Accumulated Depreciation 12 Accounts Payable 104 Wages Payable 0 Brenda Schultz, Capital 545 Brenda Schultz, Drawing 23 Fees Earned 261 Wages Expense 58 Rent Expense 35 Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2015 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 87 Accounts Receivable 232 Supplies 23 Prepaid Insurance 35 Land 290 Equipment 116 Accumulated Depreciation 12 Accounts Payable 104 Wages Payable 0 Brenda Schultz, Capital 545 Brenda Schultz, Drawing 23 Fees Earned 261 Wages Expense 58 Rent Expense 35 Insurance Expense 0 Utilities Expense 17 Supplies Expense 0 Depreciation Expense 0 Miscellaneous Expense 6 Totals 922 922 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 an amount 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, 2017 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 154 Accounts Receivable 1,126 Supplies 51 Prepaid Insurance 38 Land 1,280 Equipment 512 Accumulated Depreciation 102 Accounts Payable 461 Wages Payable 51 Brenda Schultz, Capital 2,228 Brenda Schultz, Drawing 102 Fees Earned 1,254 Wages Expense 307 Rent Expense 154 Insurance Expense 128 Utilities Expense 90 Supplies Expense 77 Depreciation Expense 51 Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2017 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 154 Accounts Receivable 1,126 Supplies 51 Prepaid Insurance 38 Land 1,280 Equipment 512 Accumulated Depreciation 102 Accounts Payable 461 Wages Payable 51 Brenda Schultz, Capital 2,228 Brenda Schultz, Drawing 102 Fees Earned 1,254 Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense *******|| Depreciation Expense Miscellaneous Expense Totals 4,096 | Net income (loss)