The following unadjusted trial balance is for Ace Construction Co. as of the end of its 2011 fiscal year.

Required
1. Prepare a 10-column work sheet for fiscal year 2011, starting with the unadjusted trial balance and including adjustments based on these additional facts:
a. The supplies available at the end of fiscal year 2011 had a cost of $3,420.
b. The cost of expired insurance for the fiscal year is $3,150.
c. Annual depreciation on equipment is $9,000.
d. The June utilities expense of $580 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $580 amount owed needs to be recorded.
e. The company's employees have earned $1,200 of accrued wages at fiscal year-end.
f. The rent expense incurred and not yet paid or recorded at fiscal year-end is $200.
g. Additional property taxes of $1,000 have been assessed for this fiscal year but have not been paid or recorded in the accounts.
h. The long-term note payable bears interest at 12% per year. The unadjusted Interest Expense account equals the amount paid for the first 11 months of the 2011 fiscal year. The $300 accrued interest for June has not yet been paid or recorded. (The company is required to make a $6,000 payment toward the note payable during the 2012 fiscal year.)
2. Use information on the accounting adjustments and the resulting balances entered into the work sheet in part 1 to journalize the adjusting and closing entries.
3. Prepare the income statement and the statement of retained earnings for the year ended June 30 and the classified balance sheet as of June 30, 2011.
Analysis Component
4. Analyze the following separate 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. Assume that the adjustment for supplies used consisted of a credit to Supplies for $3,420 and a debit for $3,420 to Supplies Expense.
b. When the adjusted trial balance in the work sheet is completed, assume that the $19,500 Cash balance is incorrectly entered in the Credit column.

Transcribed Image Text:

ACE CONSTRUCTION CO Unadjusted Trial Balance June 30, 2011 No. 101 Cash 126 Supplies 128 Prepaid insurance 167 Equipment 168 Accumulated depreciation-Equipment 201 Accounts payable 203 Interest payable 208 Rent payable 210 Wages payable 213 Property taxes payable 251 Long-term notes payable 307 Common stock 318 Retained earnings 319 Dividends 401 Construction fees earned 612 Depreciation expense-Equipment 623 Wages expense 633 Interest expense 637 Insurance expense 640 Rent expense 652 Supplies expense 683 Property taxes expense 684 Repairs expense 690 Utilities expense Account Title Debit Credit $19,500 9,500 5,000 152,160 $27,000 5,800 0 0 30,000 46,000 40,760 143,000 0 48,000 3,300 0 13,000 0 4,500 600 3,000 292,560 Totals