This unadjusted trial balance is for Challenger Construction at the end of its fiscal year, September 30, 2023. The beginning balance of the owner’s capital account was $46,000 and the owner invested another $25,000 cash in the company during the year.

Required
1. Prepare a 10-column work sheet for fiscal 2023, starting with the unadjusted trial balance and including these additional facts:
1. The inventory of supplies at the end of the year had a cost of $3,200.
2. The cost of expired insurance for the year is $8,400.
3. Annual depreciation of the equipment is $17,600.
4. The September utilities expense was not included in the trial balance because the bill arrived after it was prepared. Its $750 amount needs to be recorded.
5. The company’s employees have earned $4,200 of accrued wages.
6. The interest expense of $120 for September has not yet been paid or recorded.
2. Use the work sheet to prepare the adjusting and closing entries.
3. Prepare an income statement, a statement of changes in equity, and a classified balance sheet. $16,000 of the long-term note payable is to be paid by September 30, 2024.

Analysis Component:
Analyze the following potential errors and describe how each would affect the 10-column work sheet. Explain whether the error is likely to be discovered in completing the work sheet and, if not, the effect of the error on the financial statements.
a. The adjustment to record used supplies was credited to Supplies for $3,200 and debited the same amount to Supplies Expense.
b. When completing the adjusted trial balance in the work sheet, the $22,000 cash balance was incorrectly entered in the Credit column.

Transcribed Image Text:

1234567 00 8 Home Insert Page Layout Formulas Data Review View P18 Challenger Construction Trial Balance.xlsx No. fx A Challenger Construction Unadjusted Trial Balance September 30, 2023 Account 101 Cash 126 Supplies 9 128 Prepaid insurance 10 149 Land not currently used in operations 11 167 Equipment 12 168 Accumulated depreciation, Equipment 13 191 Copyright 14 201 Accounts payable 15 203 Interest payable 16 210 Wages payable 17 251 Long-term notes payable 18 301 Chris Challenger, capital 19 302 Chris Challenger, withdrawals 20 401 Construction revenue B 21 612 Depreciation expense. equipment 22 623 Wages expense 23 633 Interest expense 24 637 Insurance expense 25 640 Rent expense 26 652 Supplies expense 27 683 Business taxes expense 28 684 Repairs expense 29 690 Utilities expense 30 Totals Unadjusted Trial Balance Dr. $ 22,000 17,200 9,600 50,000 106,000 6,000 68,000 -O- 96,000 1,200 -O- 26,400 -O- 10,000 5,020 7,800 $ 425,220 C Cr. $ 40,500 8,100 -O- -O- 50,000 71,000 255,620 $425,220