Required information Use the following Information for the Problems below. (Statle) [The following information applies to the questions displayed below.) Golden Corporation'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 $164,880 83,689 601,080 848,888 335,880 (158.ee) $ 1,025,680 $ 187,082 71,880 526,880 784,880 299,00 (184,880) $ 899,000 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 Connon stock, $2 par value Paid-in capital in excess of par value, common stock Retained earnings Total liabilities and equity $ 87,88 28,888 115, cee $ 71,080 25.000 96.000 592,880 196,680 122,880 $ 1,025,000 568,888 160,000 75,880 $ 899,880 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,792, eee 1,086, eee 786,eee 494,000 54.ee 158,000 22, eee $ 136,000 Additional Information on Current Year Transactions a. Purchased equipment for $36,000 cash. b. Issued 12,000 shares of common stock for $5 cash per share. c. Declared and paid $89.000 in cash dividends. Problem 12-7AA (Static) Indirect: Cash flows spreadsheet LO P4 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 Balance sheet-debit balance accounts Cash $ $ 164.000 Accounts receivable Inventory Equipment 107.000 71,000 526,000 299,000 1,003,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 104,000 71,000 25,000 568,000 160,000 75,000 1,003,000 $ Statement of cash flows Operating activities Investing activities Financing activities