Complete the following problems in excel

P4-27A Preparing financial statements including a classified balance sheet in reparing and posting closing entries, and preparing a Learning objectives 1, 3,4 report form, post-closing trial balance Net Loss $(8,700) The adjusted trial balance of Elias Real Estate Appraisal at June 30, 2014, follows: ELIAS REAL ESTATE APPRAISAL Adjusted Trial Balance June 30, 2014 Balance Account Title Debit Credit S 4,900 5,300 2,400 1,800 74,400 Accounts Receivable Office Supplies Prepaid Insurance Building Accumulated Depreciation-Building Land Accounts Payable Interest Payable Salaries Payable Unearned Revenue Notes Payable (long-term) Elias, Capital Elias, Withdrawals Service Revenue Insurance Expense Salaries Expense Supplies Expense Interest Expense Utilities Expense Depreciation Expense-Building Total $ 26,700 13,600 19,500 8,800 2,200 1,300 40,000 40,500 27,900 48,200 4,500 33.300 600 8,800 2,200 7,500 187,200 S 187.200 uifements 1. Prepare the company's income statement for the year ended June 30, 2014 2. Prepare the company's statement of owners equity for the year ended June 30, 2014. Assume that there were no contributions made by the owner during the year. 3. Prepare the company's classified balance sheet in report form at June 30, 2014 4. Journalize the cdosing entries. 5. Open the T-accounts using the balances from the adjusted trial balance and post 2 the closing entries to the T-accounts. 6. Prepare the company's post-closing trial balance at June 30, 2014