Use Excel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs.Use Excel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs.

D E F H I J K L M N O P Q Contributed Capital Common Stock Accounts Receivable Office Supplies Accounts Payable Retained Earnings Service Rent Salaries Dividends Revenue Expense Expense Total Assets Total Liabilities Total Equity A = L + SE Cash Land 1 +50,000 50,000 -23,000 27,000 +50,000 50,000 50,000 0C 50,000 TRUE 2 +23,000 023,0000 0 50,000 0 0 00 50,0000 50,000 TRUE 3 T 27,0000 +300 300 23,000 +300 30050,0000 0 00 50,300 300 50,000|TRUE 4 +7.500 34,500 +7,500 7,500 0 300 23,000 300 50,000 o 0 0 57,800 300 57,500 TRUE Received $50,000 cash from Luigi Stefanni and issued stock. Balance Purchased land for $23,000 cash. Balance Purchased $300 of office supplies on account. Balance Received $7,500 cash for services performed. Balance Performed services on account, $2,000. Balance Paid in cash: $1,500 for rent & $1,100 for employees' salaries Balance Paid $250 to creditor on account. Balance Collected $1,600 from customers on account. Balance Paid $4,000 cash dividend. Balance 5 +2,000 2,000 34,500 300 23,000 300 50,000 +2,000 9,500 0 0 0 59,800 300 59,500 TRUE 6 -1,500 -1,500 -1,100 -1,100 2,000 300 23,000 50,000 0 9,500 57,200 300 56,900 TRUE -2,600 31,900 -2501 31,650 7 300 -250 50 2,000 300 23,000 50,000 0 9,500 -1,500 -1,100 56,950 50 56,900 TRUE 8 -1,600 4001 300 23,000 50 50,000 9,500 -1,500 -1,100 56,950 50 56,900 TRUE +1,600 33,250 -4,000 29,250 9 0 -4,000 -4,000 400 300 23,000 50 50,000 9,500 -1,500 -1,100 52,950 52,900 TRUE Prepare the income statement. Fill in the blue shaded areas using a formula that references the account balances at the end of 1 the ENTERANSWERS1 tab. 2 (Always use cell references and formulas where appropriate to receive full credit.) ECHO LAKE CORPORATION Income Statement Month Ended November 30, 2018 Revenues: Service Revenue Expenses: Salaries Expense Rent Expense Total Expenses Net Income HINTS Cell | Hint: D12:D13 Expenses should be entered as positive numbers in the income statement. 21 Add a negative sign in front of each formula for expense on the income statement to reverse the sign. 22 23 25 26 ENTERANSWERS1 ENTERANSWERS ENTERANSWERS3 ENTERANSWERS4 ENTERANSWERS5 A Prepare the statement of retained earnings. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the 1 ENTERANSWERS1 and the ENTERANSWERS2 tabs. 2 (Always use cell references and formulas where appropriate to receive full credit.) ECHO LAKE CORPORATION Statement of Retained Earnings Month Ended November 30, 2018 $ 0 Retained Earnings, November 1, 2018 Net Income for the month Dividends Retained Earnings, November 30, 2018 HINTS Cell Hint: 18 E9 and E11 Be sure that the amount is entered as a negative number if it is an outflow. Prepare the balance sheet. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 and the ENTERANSWERS3 tabs. Always use cell references and formulas where appropriate to receive full credit.) ECHO LAKE CORPORATION Balance Sheet 43434 Assets Cash Accounts Receivable Land Office Supplies Total Assets Liabilities Accounts Payable Stockholder's Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity ENTERANSWERS1 ENTERANSWERS2 ENTERANSWERS3 ENTERANSWERS4 ENTERANSWERS5 ECHO LAKE CORPORATION Statement of Cash Flows Month Ended November 30, 2018 Cash Flows from operating activities: Receipts: Collections from customers Payments: To employees To suppliers Total Payments Net cash provided by operating activities Cash flows from investing activities: | Acquisition of land Net cash used by investing activities Cash flows from financing activities: Issued common stock Payment of cash dividends Net cash provided by financing activities Net increase in cash Cash balance, November 1, 2018 Cash balance, November 30, 2018