help!!!! so confused...

oration's current year Income statement, comparative balance sheets, and additional information follow. 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, and (5) any change in Income Taxes Payable reflects the accrual and cash payment of taxes. GOLDEN CORPORATION Comparative Balance Sheets December 31 Current Year Prior Year $ 181,000 108,500 626,500 916,000 380,800 (166,500) $ 1,130,300 $ 125,700 88,000 543,000 756,700 316,000 (112,580) $ 960,200 Assets Cash Accounts receivable Inventory Total current assets Equipment Accumulated 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 $ 121,880 45,000 166,000 $ 88,000 33,600 121,600 612,400 226,600 125,300 $ 1,130,300 585,000 185,500 68, 100 $ 960,200 GOLDEN CORPORATION Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Income before taxes Income taxes expense Net income $ 1,877,000 1,103,000 774,000 511,000 54,000 209,000 45,800 $ 163,200 Additional Information on Current Year Transactions Additional Information on Current Year Transactions a. Purchased equipment for $64,800 cash b. Issued 13,700 shares of common stock for $5 cash per share. c. Declared and paid $106,000 in cash dividends. Required: Prepare a complete statement of cash flows using a spreadsheet under the indirect method (Enter all amounts as positive values.) GOLDEN CORPORATION Spreadsheet for Statement of Cash Flows For Current Year Ended December 31 Analysis of Changes December 31, Prior Year Debit Credit December 31, Current Year $ 181,000 Balance sheet-debit balance accounts Cash Accounts receivable Inventory Equipment 125,700 88,000 543,000 316,000 1,072,700 $ $ Balance sheet-credit balance accounts Accumulated depreciation-Equipment Accounts payable Income taxes payable Common stock, $2 par value Pald-in capital in excess of par value, common stock Retained earnings 112,500 88,000 33,600 585,000 185,500 68,100 1,072,700 $ Statement of cash flows $ 1,072,700 $ 112,500 88,000 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 33,600 585,000 185,500 68,100 1,072,700 $ Statement of cash flows Operating activities Investing activities Financing activities