this question is right besides the last portion: Which includes the bottom picture for easy solving...

Required information (The following information applies to the questions displayed below.) Part 2 of 2 Golden Corp., a merchandiser, recently completed its 2017 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, (5) Other Expenses are all cash expenses, and (6) any change in Income Taxes Payable reflects the accrual and cash payment of taxes. The company's balance sheets and income statement follow. points eBook GOLDEN CORPORATION Comparative Balance Sheets December 31, 2017 and 2016 2017 2016 Print $ 180,000 107,000 625,000 912,000 378,100 (166,000) $1,124,100 $ 124,600 87,000 542,000 753,600 315,000 (112,000) $ 956,600 Assets Cash Accounts receivable Inventory Total current assets Equipment Accum. depreciation-Equipment Total assets Liabilities and Equity Accounts payable Income taxes payable Total current liabilities Equity Common stock, $2 par value Paid-in capital in excess of par value, common stock Retained earnings Total liabilities and equity $ $ 119,000 44,000 163,000 87,000 33, 100 120, 100 624,000 212,000 125,100 $1,124,100 584,000 184,000 68,500 $ 956,600 Part 2 of 2 GOLDEN CORPORATION Income Statement For Year Ended December 31, 2017 Sales $1,872,000 Cost of goods sold 1,102,000 Gross profit 770,000 Operating expenses Depreciation expense $ 54,000 Other expenses 510,000 564,000 Income before taxes 206,000 Income taxes expense 44,400 Net income $ 161,600 points eBook Additional Information on Year 2017 Transactions Print a. Net income was $161,600. b. Accounts receivable increased. c. Inventory increased. d. Accounts payable increased. e. Income taxes payable increased. f. Depreciation expense was $54,000. g. Purchased equipment for $63,100 cash. h. Issued 13,600 shares at $5 cash per share. i. Declared and paid $105,000 of cash dividends. Required: Prepare a complete statement of cash flows using a spreadsheet; report operating activities under the indirect method. (Enter all amounts as positive values.) Part 2 of 2 GOLDEN CORPORATION Spreadsheet for Statement of Cash Flows For Year Ended December 31, 2017 Analysis of Changes December 31, 2016 Debit Credit December 31, 2017 points $ $ Balance sheet-debit balance accounts Cash Accounts receivable Inventory Equipment 180,000 107,000 eBook 124,600 87,000 542,000 315,000 1,068,600 20,000 83,000 63,100 625,000 378,100 1,290,100 Print $ $ $ Balance sheet-credit balance accounts Accumulated depreciation Equipment Accounts payable Income taxes payable Common stock, $2 par value Paid-in capital in excess of par value, common stock Retained earnings 112,000 87,000 33,100 584,000 184,000 68,500 1,068,600 54,000 32,000 10,900 40,000 28,000 161,600 166,000 119,000 44,000 624,000 212,000 125,100 1,290,100 105,000 161,600 | Statement of cash flows Operating activities Net income Depreciation expense Increase in accounts receivable Increase in inventory Increase in accounts payable 54,000 20,000 83,000 32,000 Increase in accounts payable Increase in income tax payable 32,000 10,900 Investing activities Increase in inventory 63,100 Financing activities Cash paid for income taxes Issued common stock for cash Paid cash dividends (28,000) (40,000) 105,000 492,600 $ 461,600 $ Investing activities Increase in inventory 63,100 Financing activities Cash paid for income taxes Issued common stock for cash Paid cash dividends (28,000) (40,000) 105,000 492,600 $ 461,600 $