Problem 4-2A Preparing a work sheet, adjusting and closing entries, and financial statements LO C3, P1, P2 The following unadjusted trial balance is for ACE CONSTRUCTION CO. as of the end of its 2017 fiscal year. The June 30, 2016, credit balance of the owner's capital account was $51,000, and the owner invested $30,000 cash in the company during the 2017 fiscal year. Debit Credit $ 19,500 7,000 7,000 150,970 $ 30,000 6,400 0 ACE CONSTRUCTION CO. Unadjusted Trial Balance June 30, 2017 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 Totals 23,000 81,000 26,000 147,000 50,000 2,530 14,000 4,400 2,300 3,700 $287,400 $ 287,400 Adjustments: a. The supplies available at the end of fiscal year 2017 had a cost of $2,520. b. The cost of expired insurance for the fiscal year is $4,410. c. Annual depreciation on equipment is $8,400. d. The June utilities expense of $590 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $590 amount owed needs to be recorded. e. The company's employees have earned $1,600 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 $600 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 2017 fiscal year. The $230 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 2018 fiscal year.) Required: 1. Prepare a 10-column work sheet for fiscal year 2017, starting with the unadjusted trial balance and including adjustments based on the additional facts. 2a. Prepare the adjusting entries. (all dated June 30, 2017). 2b. Prepare the closing entries. (all dated June 30, 2017): 3a. Prepare the income statement for the year ended June 30. 3b. Prepare the statement of owner's equity for the year ended June 30. 3c. Prepare the classified balance sheet at June 30, 2017 Complete this question by entering your answers in the tabs below. Required 1 Required 2A Required 2B Required 3A Required Required 3C Prepare a 10-column work sheet for fiscal year 2017, starting with the unadjusted trial balance and including adjustments based on the additional facts. The June 30, 2016, credit balance of the owner's capital account was $51000, and the owner invested $30000 cash in the company during the 2017 fiscal year. ACE CONSTRUCTION CO. Work Sheet For Year Ended June 30, 2017 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Dr. Cr. Dr. Cr. Cr. Dr. Cr. $ $ 19,500 7,000 7,000 150,970 4,480 4,410 Dr. 19,500 2,520 2,590 150,970 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 Balance Sheet and Statement of Owner's Equity Dr. Cr. $ 19,500 2,520 2,590 150,970 38,400 8,400 38,400 30,000 6.400 Balance Sheet and Statement of Owner's Equity Dr. Cr. 19,500 2,520 2,590 150.970 38,400 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement No. Account Title Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. 101 Cash $ 19,500 $ 19,500 126 Supplies 7,000 4,480 2.520 128 Prepaid insurance 7,000 4.410 2,590 167 Equipment 150,970 150,970 168 Accumulated depreciation Equipment 30,000 8,400 38,4001 201 Accounts payable 6,400 203 Interest payable 208 Rent payable 210 Wages payable 213 Property taxes payable 220 Current portion of Long-term notes payable* 6.000 6,000 251 Long-term notes payable* 17,000 17.000 301 V. Ace, Capital 81,000 302 V. Ace, Withdrawals 26,000 401 Construction fees earned 147.000 612 Depreciation expense-Equipment 623 Wages expense 50,000 633 Interest expense 2,530 637 Insurance expense 640 Rent expense 14,000 652 Supplies expense 683 Property taxes expense 4.400 684 Repairs expense 2,300 690 Utilities expense 3,700 Totals $ 287,400 $ 287,400 $ 0 $ 17,290 $ 175,580 $ 61,400 0 Net Income Totals 0 $ * Using item h above, the notes payable account is reclassified into current and long-term portions for the unadjusted trial balance columns of the work sheet. 0 175,580 38,400 0 $ 175,580 $ 38,400 Required 1 Required 2A Required 2B Required 3A Required 3B Required 3C Prepare the adjusting entries (all dated June 30, 2017). View transaction list Journal entry worksheet The supplies available at the end of fiscal year 2017 had a cost of $2,520. Note: Enter debits before credits. Transation General Journal Debit Credit a. Record entry Clear entry View general journal Required 1 Required 2A Required 2B Required 3A Required 3B Required 3C Prepare the closing entries (all dated June 30, 2017). View transaction list Journal entry worksheet Record the entry to close revenue accounts. Note: Enter debits before credits. General Journal Debit Credit Date Jun 30 Record entry Clear entry View general journal Required 1 Required 2A Required 2B Required 3A Required 3B Required 3C Prepare the income statement for the year ended June 30, 2017. ACE CONSTRUCTION CO. Income Statement For Year Ended June 30, 2017 Revenues Expenses Total expenses 0 $ 0 Required 1 Required 2A Required 2B Required 3A Required 3B Required 3C Prepare the statement of owner's equity for the year ended June 30, 2017. The June 30, 2016, credit balance of the owner's capital account was $51,000, and the owner invested $30,000 cash in the company during the 2017 fiscal year. ACE CONSTRUCTION CO. Statement of Owner's Equity For Year Ended June 30, 2017 V. Ace, Capital, June 30, 2016 0 0 V. Ace, Capital, June 30, 2017 $ 0 ACE CONSTRUCTION CO. Balance Sheet June 30, 2017 $ 0 0 0 $ $ 0 $ 0 0