The following unadjusted trial balance is for Ace Construction Co. as of the end of its 2013 fiscal year. The June 30, 2012, credit balance of the owner’s capital account was $53,660, and the owner invested $35,000 cash in the company during the 2013 fiscal year.

Required
1. Prepare and complete a 10-column work sheet for fiscal year 2013, starting with the unadjusted trial balance and including adjustments based on these additional facts.
a. The supplies available at the end of fiscal year 2013 had a cost of $3,300.
b. The cost of expired insurance for the fiscal year is $3,800.
c. Annual depreciation on equipment is $8,400.
d. The June utilities expense of $650 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $650 amount owed needs to be recorded.
e. The company’s employees have earned $1,800 of accrued wages at fiscal year-end.
f. The rent expense incurred and not yet paid or recorded at fiscal year-end is $500.
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 2013 fiscal year. The $250 accrued interest for June has not yet been paid or recorded. (The company is required to make a $5,000 payment toward the note payable during the 2014 fiscal year.)
2. Using information from the completed 10-column work sheet in part 1, journalize the adjusting entries and the closing entries.
3. Prepare the income statement and the statement of owner’s equity for the year ended June 30 and the classified balance sheet at June 30, 2013.

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 and a debit to Supplies Expense for $3,300, when the correct amount was $6,600.
b. When the adjusted trial balance in the work sheet is completed, assume that the $18,500 Cash balance is incorrectly entered in the Creditcolumn.

ACE CONSTRUCTION CO Unadjusted Trial Balance June 30, 2013 Credit No. Account Title 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 301 V. Ace, Capital 302 V Ace, Withdrawals 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 Debit 18,500 9,900 7,200 132,000 S 26,250 6,800 25,000 88,660 33,000 132,100 0 46,860 2,750 0 12,000 0 7,800 2,910 5,890 $278,810 Totals $278,810