Prepare a complete statement of cash flows using a spreadsheet under the indirect method.

Required information [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. Additional Information on Current Year Transactions a. Purchased equipment for $44,400 cash. b. Issued 12,500 shares of common stock for $5 cash per share. c. Declared and paid $94,000 in cash dividends. Required information \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Spreadsheet for Statement of Cash Flows } \\ \hline \multicolumn{6}{|c|}{ For Current Year Ended December 31} \\ \hline & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} December 31, Prior \\ Year \end{tabular}}} & \multicolumn{2}{|c|}{ Analysis of Changes } & \multirow{2}{*}{\begin{tabular}{l} December 31, \\ Current Year \end{tabular}} \\ \hline & & & Debit & Credit & \\ \hline \multicolumn{6}{|l|}{ Balance sheet-debit balance accounts } \\ \hline Cash & $ & 112,500 & & & 169,000 \\ \hline Accounts receivable & & 76,000 & & & \\ \hline Inventory & & 531,000 & & & \\ \hline \multirow[t]{2}{*}{ Equipment } & & 304,000 & & & \\ \hline & $ & 1,023,500 & & & 169,000 \\ \hline \multicolumn{6}{|l|}{ Balance sheetcredit balance accounts } \\ \hline Accumulated depreciation-Equipment & $ & 106,500 & & & \\ \hline Accounts payable & & 76,000 & & & \\ \hline Income taxes payable & & 27,600 & & & \\ \hline Common stock, \$2 par value & & 573,000 & & & \\ \hline Paid-in capital in excess of par value, common stock & & 167,500 & & & \\ \hline \multirow[t]{2}{*}{ Retained earnings } & & 72,900 & & & \\ \hline & $ & 1,023,500 & & & $ \\ \hline \multicolumn{6}{|l|}{ Statement of cash flows } \\ \hline \multicolumn{6}{|l|}{ Operating activities } \\ \hline \multicolumn{6}{|l|}{ C } \\ \hline \\ \hline \multicolumn{6}{|l|}{F} \\ \hline \\ \hline \multicolumn{6}{|l|}{p} \\ \hline \multicolumn{6}{|l|}{ C } \\ \hline \multicolumn{6}{|l|}{7} \\ \hline \multicolumn{6}{|l|}{ Investing activities } \\ \hline \\ \hline \multicolumn{6}{|l|}{7} \\ \hline \multicolumn{6}{|l|}{ Financing activities } \\ \hline \\ \hline \multicolumn{6}{|l|}{=} \\ \hline \multicolumn{6}{|l|}{=} \\ \hline & & & $ & $ & \\ \hline \end{tabular}