please do it in Excel

PROBLEM 2 A comparative balance sheet for Halpern Corporation is presented below HALPERN CORPORATION Comparative Balance Sheet 2017 2016 Assets Cash Accounts receivable (net) Prepaid insurance Land Equipment Accumulated depreciation Total Assets .36.000 70,000 25,000 18,000 70,000 (20,000) $199.000 31,000 60,000 17,000 40,000 60,000 (13,000) $195.000 Liabilities and Stockholders' Equity Accounts payable Bonds payable Common stock Retained earnings Total liabilities and stockholders' equity 11000 27,000 140,000 21,000 $199.000 6,000 19,000 115,000 55,000 $195.000 Additional information: Net loss for 2017 is $20,000. 1 Cash dividends of $14,000 were declared and paid in 2017 Land was sold for cash at a loss of $4,000. This was the only land transaction during the year. 2. 3. 4. Equipment with a cost of $15,000 and accumulated depreciation of $10,000 was sold for $5,000 cash. $22,000 of bonds were retired during the year at carrying (book) value. 5. 6. Equipment was acquired for common stock. The fair value of the stock at the time of the exchange was $25,000 Instructions Prepare a statement of cash flows for the year ended 2017, using the indirect method