3 P1 P2 adjusted trial balance is for Ace Construction Co. as of the end of its 2012 fiscal year. The June 30, 2016, credit balance the one's capital account was $53,660, and the owner invested $35.000 cash in the company during the 2017 fiscal year. Credit $ 26,250 6,800 ACE CONSTRUCTION CO. Unadjusted Trial Balance June 30, 2017 No Account Title Debit 5 101 Cash $ 18,500 6 126 Supplies 9.900 7 128 Prepaid insurance 7.200 8 167 Equipment 132,000 9 168 Accumulated depreciation Equipment 10 201 Accounts payable 11 203 Interest payable 12 208 Rent payable 13210 Wages payable 14 213 Property taxes payable 15251 Long-term notes payable 10 301 V. Ace, Capital 17 302 V. Ace. Withdrawals 33.000 18 401 Construction fees earned 19612 Depreciation expense-Equipment 20 623 Wages expense 46.860 21 633 Interest expense 2.750 22 637 Insurance expense 23 640 Rent expense 12.000 24 652 Supplies expense 25 083 Property taxes expense 7.800 20684 Repairs expense 2.910 27 690 Utilities expense 5.890 Totals $278,810 25.000 88.660 132.100 $278.810 @ Aa O D Required 1. Prepare and complete a 10 column work sheet for fiscal year 2017, starting with the unadjusted trial balance and including adjustments based on these additional facts. ant Ratio a. The supplies available at the end of fiscal year 2017 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 acounts. 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 2017 fiscal year. The $250 accrued interest for June has not yet been paid or orded. (The company is required to make a $5,000 payment toward the note payable during the 2018 fiscal year.)