80.2K

Verified Solution

Link Copied!

Statement of Cash Flows

Collection from customers: =+ENTERANSWER!C18+ENTERANSWER!C26

To employees: =+ENTERANSWER1!L29

To suppliers: =+ENTERANSWER1!K22+ENTERANSWER1!C24

Aquisition of land: =-ENTERANSWER1!F29

Issued common stock: =+ENTERANSWER1!H29

Payment of cash dividends: =+ENTERANSWER1!I29

In the Statement of Cash Flows, should I type the figures from the Balance of each item for ''To employees, Aquisition of land, Issued common stock, and Payment of cash dividends''?

For example, is Issued common stock in Statement of Cash Flows =+ENTERANSWER1!H29?

If so, does Aquisition of land in the Statement of Cash Flows need to be typed =-ENTERANSWER!F29 to reverse the sign?

Excel ABU 8 - RA 79 23 Regular 11 A. A Yamazak Miller Nobles7e-Using Eroul Christ NL TRUST B 1 U. DELHEXY $11 xfx B F G H N 9 Description Assets Equity 10 Lisbilitie Contributed Capital Accounts Common Payable Stock Accounts Office Receivable Supplies Retained Eaming Service Rent Sales Dividends Revenue Exbond Total Assets Total Liabilities Totu Equity A- L+SE Cash Land 450,000 50,000 0 0 o 0 0 0 0 0 o TRUE 50,000 50,000 +50,000 50,000 -23.000 27,000 +23,000 23,000 50.000 0 0 0 0 0 0 50,000 50.000 TRUE +300 300 +300 300 23,000 50.000 ol ol 0 0 0 50,100 300 27.000 50.000 TRUE +7.500 34.500 +7,500 7,500 23.000 0 300 0 50.000 0 ol 300 300 57.500 TRUE 57,800 Received $50,000 cash from Lui 12 1 Stefani and issued stock. 3 Balance 2 Purchased land for 1.000 cash 05 Balance Purchased $300 of office supplies 63 on account Balance Received $7,500 cash for services 84 performed 9 Balance Performed services on account 5 $2.000 Balance Paid in case $1.500 for rent & 28 $1,100 for employees salaries 3 Balance 17 Pald $250 to creditor on account. 5 Balance Collected $1,600 from customers 58 on account Balance 9 Paid $4,000 cash dividend. 3 Balance +2.000 2.000 42.000 9.500 0 0 01 300 300 50,000 59.800 34,500 23.000 59.500 TRUE 300 -1.500 -1.100 -1.500 1.100 ol 9.500 300 57,200 56.900 TRUE 50,000 2.000 300 23.000 -2.600 31.900 -250 31.650 300 -250 50 0 9,500 50 -1.500 50.000 56,950 -1,100 23.000 56.500 TRUE 2,000 300 -1.600 400 50 56.950 300 $6.900 TRUE 23,000 9.500 50 50,000 -1.500 1.100 +1,600 33,250 -4,000 29,250 0 4,000 -4.000 50 52.900 TRUE $2.950 9.500 400 23,000 50 50,000 -1.500 1.100 300 + ENTERANSWERSS ENTERANSWERS ENTERANSWERS ENTERANSWERS4 ENTERANSWERS Instructions ART CAT Regular (.. 11 AA WOUTRA B I U E19 Xfx --ENTERANSWERS11F29 B D E F G H M 4 $ 9,100 (2.850) 6,250 5 ECHO LAKE CORPORATION 6 Statement of Cash Flows 7 Month Ended November 30, 2018 8 9 Cash Flows from operating activities: 10 Receipts: 11 Collections from customers 12 Payments: 13 To employees $ 0.100) To suppliers -1,750 15 Total Payments 16 Net cash provided by operating activities 17 15 Cash flows from Investing activities: 19 Acquisition of land (23,000) 20 Net cash used by investing activities 21 22 Cash flows from financing activities: 23 Issued common stock 50,000 24 Payment of cash dividends (4,000) 25 Net cash provided by financing activities 26 27 Net Increase in cash 28 Cash balance, November 1, 2018 25 Cash balance, November 30, 2018 30 31 32 32 HINTS 34 Cell Hint 35 E13 E24 Be sure that the amount is entered as a negative number if it is an outflow 35 (23,000) 46,000 29.250 0 $ 29,250

Answer & Explanation Solved by verified expert

See Answer