I DONT KNOW HOW TO INSERT CURRENT PORION OF LONG TERM NOTES PAYABLE AND LONG TERM NOTES PAYABLE ON CHART!!!!

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 $52,200, and the owner invested $28,000 cash in the company during the 2017 fiscal year. Credit Debit $ 19,000 7,500 5,500 136,040 $ 21,500 5,200 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 OOOOOO 26,000 80, 200 29,000 132,000 40,000 2,860 14,000 0 4,400 2,100 4,500 $264,900 $264,900 Adjustments: a. The supplies available at the end of fiscal year 2017 had a cost of $2,700. b. The cost of expired insurance for the fiscal year is $3,465. c. Annual depreciation on equipment is $8,900. d. The June utilities expense of $540 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $540 amount owed needs to be recorded. e. The company's employees have earned $1,700 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 $800 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 $260 accrued interest for June has not yet been paid or recorded. (The company is required to make a $4,500 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. ACE CONSTRUCTION CO. Work Sheet For Year Ended June 30, 2017 Unadjusted Trial Adjusted Trial Balance Income Statement Adjustments Dr. Cr. Account Title Cr. Dr. Cr. Balance Dr. Cr. $ 19,000 7,500 5,500 $ 4.800 Dr. 19,000 2,700 2,035 136,0401 insurance 3,465 136,040 I 21,500 5,200 8,900 540 260 500 1,700 800 lated depreciationEquipment s payable payable yable payable taxes payable portion of Long-term notes payable* Em notes payable* Capital Nithdrawals ction fees earned ation expense-Equipment 30,400 5,740 260 500 1,700 800/ 4,500 21,500 80,200 Balance Sheet and Statement of Owner's Equity Dr. $ 19,000 2,700 2,035 136,040 30,400 5,740 260 500 1,700 800 4,500 21,500 80,200 29,000 4,500 21,500 80,200 29,000 29,000 132,000 132,000 132,000 8,900 8,900 8,900 xpense 40,000 1,700 41,700 41,700 expense 2,860 260 3,120 3,120 e expense 3,465 3,465 3,465 Jense 14,000 500 14,500 14,500 expense 4,800 4,800 4,800 taxes expense 4,400 800 5,200 5,200 expense 2,100 2,100 2,100 ?xpense 4,500 540 5,040 5,040 $ 264,900 $ 264,900 $ 20,965 $ 20,965 $ 277,600 $ 277,600|| 88,825 43,175 $ 132,000 ove, the notes payable account is reclassified into current and long-term portions for the unadjusted trial balance columns of the work sheet. 225 132,000 188,775 me 145,600 43,175 188,775 $ 132,000 $ 188,775 $