Please help me fill out the rest. I'm confused where to put some of the things at the top.

Statement of Cash Flows - Excel Additional info: (1) plant assets costing $30,000 with accumulated depreciation of $12,000 are sold for $12,000 cash, yielding a loss of $6,000; (2) notes with a book value of $34,000 are retired with a cash payment of $18,000, yielding a $16,000 gain on retirement; (3) plant assets costing $70,000 are purchased with a cash payment of $10,000 and an issuance of notes payable for $60,000. GENESIS Spreadsheet for Statement of Cash Flows-Indirect Method For Year ended December 31 Dec 31 Analysis of Changes Dec 31 2016 Debit Credit 2017 alance Sheet, Debit balance accounts Cash 5,000 $ 12,000 17,000 AR 20,000 - 40,000 a 20.00 60,000 Merchandise inventory 14.000 - 70,000 14.000 84,000 Prepaid expenses 2000 - 4,000 C 2100 6,000 Plant Assets 210,000 70000 130,00 250,000 $ 336,000 bought Sold $ 417,000 Balance Sheet, Credit balance accounts Accumulated depreciation 12,000 + $ 48,000 e 12.000 $ 60,000 A/P (,00 40,000 5,000 35,000 Interest payable 11.000)- 4,000 g. 1,000 3,000 Income taxes payable v.000 + 12,000 b) 10,000 22,000 N/P 21,000+ 64,000 90,000 Common stock, $5 par value 15.000 80,000 15,00 95,000 Retained earnings 88,000 14.0 39,000 112,000 net income, $38,000; dividends, $14.000 $ 336,000 $ 417,000 Statement of Cash Flows Information Operating activities Net income Investing activities Financing atavilec Noncash investing and financing activities