answer in excel form.

Problem 1: The Comparative Balance Sheet of XYZ Inc. for December 31, 2019 and 2018 is shown as follows: 12/31/19 12/31/18 Assets Cash $625,760 $585,920 227,840 208,960 Accounts Receivable $641,760 $617,120 Inventories 0 240,000 Investments 328,000 0 Land 705,120 553,120 Equipment Accumulated Depreciation equipment (148,000) (166,400) $2,362,080 $2,057,120 Total Assets Liabilities and Stockholders' Equity $424,480 $404,960 Accounts payable (merchandise creditors) Accrued expenses payable (operating expenses) 42,240 52,640 Dividends payable 24,000 19,200 Common Stock, $4 par 150,000 100,000 Paid In Capital - common stock 417,500 280,000 Retained earnings 1,303,860 1,200,320 Total Liabilities and Stockholders' equity 2,362,080 2,057,120 Additional data obtained from an examination of the accounts in the ledger for 2019 are as follows: a) The Investments were sold for $280,000 cash. b) Equipment and land were acquired for cash c) The common stock was issued for cash d) There was a $199,540 credit to Retained Earnings for net income e) There was a $96,000 debit to Retained Earnings for cash dividends declared Instructions: Prepare a statement of cash flows using the indirect method