Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ex 04.24 Appendix: Adjustment Data on an End-of-Period SpreadsheetAlert Security Services Co. offers security services to business clients. The trial balance for Alert Security ServicesCo.

Ex 04.24 Appendix: Adjustment Data on an End-of-Period SpreadsheetAlert Security Services Co. offers security services to business clients. The trial balance for Alert Security ServicesCo. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. Inaddition, the data for year-end adjustments are as follows:a. Fees earned but not yet billed, $25.b. Supplies on hand, $6.c. Insurance premiums expired, $31.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 doesnot require an entry, leave it blank.

image text in transcribed
1/30/22, 8:51 AM 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: a. Fees earned but not yet billed, $25. b. Supplies on hand, $6. C. Insurance premiums expired, $31. d. Depreciation expense, $12. . 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, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 93 Accounts Receivable 248 Supplies 25 Prepaid Insurance 37 Land 310 Equipment 124 Accumulated Depreciation 12 Accounts Payable 112 Wages Payable 0 Brenda Schultz, Capital 583 Brenda Schultz, Drawing 25 279 Fees Earned Wages Expense 62 Rent Expense 37 Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense c=activityService_activity_16435577880538xdm_p=1 Page 1 of 2 https://cxp.cengage.com/activityservice/run/html5/handler.jsp?id=d2_engageno

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Finance

Authors: Arthur Keown, John Martin, J. Petty

10th Edition

0136102654, 9780136102656

More Books

Students also viewed these Accounting questions