C D Debit Credit Formula Bar F 1) Prepare an income statement for the year ended December 31, 2019 Income Statement For Year Ended December 31, 2019 Revenues Total revenues Expenses 1 2 Account Cash 4. Accounts receivable 5 Inventory Supplies 7 Prepaid rent Prepaid Insurance Accounts payable Salaries payable Unearned revenue Notes payable Owner's capital Owner's withdrawal Sales revenue cost of goods sold Salanes expense w Supplies expense Rent expense 10 Utvities expense 21 Totals Tral Balance Amount 9,700 38,000 27,300 800 6,500 12,000 6,470 1,500 1,200 25.000 54,700 20,000 315,000 215,800 36,400 7,200 24,000 6,170 807,740 Total expenses 2) Prepare a statement of owner's equity for the year ended December 31, 2019. The owner invested so during the current year, Statement of Owner's Equity For Year Ended December 31, 2019 Owner's Capital, January 1, 2019 Investment by owner Instructions 24 ONLY use cell referencing and formulas, do not type text! 5 Using cell referencing only build the financial statements Owner's Capital, December 31, 2019 L K 3) Prepare a Balance Sheet for December 31, 2019 Balance Sheet December 31, 2019 Assets Total assets Liabilities and Equity Liabilities Total liabilities Equity Total liabilities and equity