Question

In: Accounting

Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete...

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 Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 250 Accounts Receivable 1,830 Supplies 83 Prepaid Insurance 62 Land 2,080 Equipment 832 Accum. Depr.-Equipment 166 Accounts Payable 749 Wages Payable 83 Brenda Schultz, Capital 3,620 Brenda Schultz, Drawing 166 Fees Earned 2,038 Wages Expense 499 Rent Expense 250 Insurance Expense 208 Utilities Expense 146 Supplies Expense 125 Depreciation Expense 83 Miscellaneous Expense 42 Totals 6,656 6,656 Net income (loss) Check My Work

Solutions

Expert Solution

Adjusted Trial Balance Income Statement Balance Sheet
Debit Credit Debit Credit Debit Credit
Cash 250 250
Accounts Receivable 1830 1830
Supplies 83 83
Prepaid Insurance 62 62
Land 2080 2080
Equipment 832 832
Accum. Depr Equipment 166 166
Accounts Payable 749 749
Wages Payable 83 83
Brenda Schultz,Capital 3620 3620
Brenda Schultz,Drawing 166 166
Fees earned 2038 2038
Wages expense 499 499
Rent expense 250 250
Insurance expense 208 208
Utilities expense 146 146
Supplies expense 125 125
Depreciation expense 83 83
Miscellaneous expense 42 42
Totals 6656 6656 1353 2038 5303 4618
Net income (loss) 685 685
2038 2038 5303 5303

Related Solutions

Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert...
Appendix: Completing 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, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 213 Wages...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
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: Fees earned, but not yet billed, $34. Supplies on hand, $8. Insurance premiums expired, $42. Depreciation expense, $17. Wages accrued, but not paid, $17. Enter the adjustment data, and place...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
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, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $18. Supplies on hand, $4. Insurance premiums expired, $22. Depreciation expense, $9. Wages accrued but not paid, $9. Enter the adjustment data and place...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 13.00 5 Accounts Receivable 108.00 6 Supplies 8.00 7 Prepaid Insurance 2.00 8 Land 184.00 9 Equipment 50.00...
Appendix: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: 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, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned...
Appendix 1: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...
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 223 Accounts Receivable 1,637 Supplies 74 Prepaid Insurance 56 Land 1,860 Equipment 744 Accum. Depr.-Equipment 149 Accounts Payable 670 Wages Payable 74 Common Stock 40 Retained Earnings 3,195 Dividends 149 Fees Earned 1,823...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...
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, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 18.00 5 Accounts Receivable 90.00 6 Supplies 14.00 7...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...
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, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 12.00 5 Accounts Receivable 90.00 6 Supplies 8.00 7...
Chapter 4: Completing the Accounting Cycle The end of period spreadsheet is useful in preparing an...
Chapter 4: Completing the Accounting Cycle The end of period spreadsheet is useful in preparing an Adjusted Trial Balance from which the three Financial Statements can be prepared. Please indicate the results in the adjusted Trial Balance under the following circumstances. Please provide an example. a. An account has a debit balance. The adjustment requires a credit to that account. The debit amount is higher than the credit amount. Is the result in the Adjusted Trial Balance a debit or...
Discussion Question: Super Security Co. offers a range of security services for athletes and entertainers. Each...
Discussion Question: Super Security Co. offers a range of security services for athletes and entertainers. Each type of service is considered within a separate department. Marc Pincus, the overall manager, is compensated partly on the basis of departmental performance by staying within the quarterly cost budget. He often revises operations to make sure departments stay within the budget. Says Pincus, “I will not go over budget even if it means slightly compromising the level and quality of service. These are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT