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. GOLDEN CORPORATION Comparative Balance Sheets December 31, 2017 and 2016 2017 2016 $ 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 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 Additional Information on Year 2017 Transactions 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.) 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 Balance sheet-debit balance accounts Cash 180,000 124,600 87,000 Accounts receivable Inventory Equipment 542,000 315,000 1,068,600 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 Statement of cash flows Operating activities Relleu llys 66,00 1,068,600 Statement of cash flows Operating activities Investing activities Financing activities