Prepare balance sheet and retained earnings statement using statement of cash flows data Following are a statement of cash flows (indirect method) for Harris, Inc., for the year ended December 31, 2017, and the firm's balance sheet at December 31, 2016: HARRIS, INC. Statement of Cash Flows For the Year Ended December 31,2017 Cash Flows from Operating Activities: Add (deduct) items not affecting cash: 87,000 (18,000) 90,000 9,000 $ 207,000 Net cash provided by operating activities . Cash Flows from Investing Activities: (270,000) 21,000 Proceeds from sale of land at its cost....................... Net cash used by investing activities. __ ....._. __ ....._. .. ..__. _. ......$(249 Cash Flows from Financing Activities: (12,000) (27,000) 5,000 24,000 (15,000 Payment of Proceeds from issuance of long-term debt ....__ .. . . .___ . .. .___ . .. Proceeds from issuance of common stock..... _ _ . . . . . _ ....__....._...... Payment of cash dividends on common stock. .__ . ...___. .. . Net cash provided by financing activities ._____ ..._ _ _ .. .__._ ..._ ___ . ...$ 15,000 Net decrease in cash for the year...... . .. .. .. . .. . .. . .. .. . (27.000