Filled out excel sheet

PR 16-1B Statement of cash flows OBJ. 2, 3, 4, 5 The comparative balance sheet of Merrick Equipment Co. for December 31, 2049 and 20Y8, is as follows: Dec. 31, 2049 Dec. 31, 20Y8 Assets $ 70,720 207,230 298,520 0 $ 47,940 188,190 289,850 102,000 0 358,020 (84,320) $901,680 295,800 438,600 (99,110) $1,211,760 Cash.... Accounts receivable (net). Inventories.. Investments.. Land... Equipment... Accumulated depreciation-equipment.. Total assets..... Liabilities and Stockholders' Equity Accounts payable..... Accrued expenses payable..... Dividends payable... Common stock, $1 par... Paid-in capital in excess of par. Retained earnings.... Total liabilities and stockholders' equity.. $ 205,700 30,600 25,500 202,000 354,000 393,960 $1,211,760 $194,140 26,860 20,400 102,000 204,000 354,280 $901,680 Additional data obtained from an examination of the accounts in the ledger for 2049 are as follows: a. Equipment and land were acquired for cash. b. There were no disposals of equipment during the year. c. The investments were sold for $91,800 cash. d. The common stock was issued for cash. e. There was a $141,680 credit to Retained Earnings for net income. f. There was a $102,000 debit to Retained Earnings for cash dividends declared. Instructions Prepare a statement of cash flows, using the indirect method of presenting cash flows from (used for) operating activities. MERRICK EQUIPMENT CO. Statement of Cash Flows For the Year Ended December 31, 20Y9 Cash flows from operating activities: Net income Adjustments to reconcile net income to net cash flow from operating activities: Depreciation Changes in current operating assets and liabilities: Net cash flow from operating activities Cash flows from (used for) investing activities: Net cash flow used for investing activities Cash flows from (used for) financing activities: Net cash flow from financing activities Increase (decrease) in cash Cash at the beginning of the year Cash at the end of the year