ALL WORK MUST BE ON AN EXCEL FILE please all parts

Preparing financial statements including a classified balance sheet in report form, preparing and posting closing entries, and preparing a post-closing trial balance.

The adjusted trail balance of Elmo Real Estate Appraisal at June 30, 2016, follows

Requirements:

1) Prepare the companys income statement for the year ended June 30, 2016.

2)Prepare the companys statement of owners equity for the year ended June 30, 2016. (Assume that there were no contributions made by the owner during this year)

3) Prepare the companys classifies balance sheet in report form at June 30, 2016.

4) Journalize the closing entries.

5) Open the T-Accounts using the balances from the adjusted trail balance and post the closing entries to the T-Accounts.

6)Prepare the companys post-closing trail balance at June 30, 2016.

ELMO REAL ESTATE APPRAISAL Adjusted Trial Balance June 30, 2016 Balance Debit Credit Account Title Cash Accounts Receivable Office Supplies Prepaid Insurance Builcing 4,900 4,800 2,700 1,900 79,000 26,600 Land Accounts Payable Interest Payable Salaries Payable Unearned Revenue Notes Payable (long-term) Elmo, Capital Elmo, Withdrawals Service Revenue Insurance Expense Salaries Expense Supplies Expense Interest Expense Usilities Expense 12,600 19,300 8,300 1,700 800 42,000 43,000 27,100 48,400 4,000 33,900 200 8,300 2,800 7,900 Total 190,100 190,100