Need help with trial balance, income statement, owner equity.

The trial balance of the Jordan Johnston Company as of December 31, 2022 is presented below. Prepare an income statement, statement of owner's equity and a balance sheet for the year ended (date of), December 31, 2022. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles. Cash Accounts receivable Inventory Prepaid rent Jordan Johnston Company Trial Balance December 31, 2022 Debit Equipment Accounts payable Unearned consulting revenue Jordan Johnston, Capital Jordan Johnston, Withdrawals Consulting revenue Rental revenue Wages expense Rent expense Insurance expense Totals $5,200 1,100 10,600 3,300 26,900 1,100 2,300 1,900 1,200 Credit $7,100 3,900 34,700 6,700 1,200 1) Prepare an income statement for Jordan Johnston Company for the year ended December 31, 2022. Revenues Total revenues Expenses Total expenses Jordan Johnston Company Income Statement For Year Ended December 31, 2022 2) Prepare a statement of owner's equity for Jordan Johnston Company for the year ended December 31, 2022. The owner invested $5,200 during the current year (Cell D52). Hint: You must calculate the beginning balance in the capital account. Jordan Johnston Company Statement of Owner's Equity For Year Ended December 31, 2022 Jordan Johnston, Capital, January 1, 2022 Investment by owner Subtotal Withdrawals by owner Jordan Johnston, Capital, December 31, 2022 5,200 3) Prepare a balance sheet for Jordan Johnston Company at December 31, 2022. Jordan Johnston Company Balance Sheet December 31, 2022 Assets Total assets Liabilities Total liabilities Equity Total liabilities and equity Liabilities and Equity 11