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

Please use the template below. The highlighted sections are answer slots.

Forten Compony's current year income statement, comparative balance sheets, and additional information follow. For the yeor, (1) all sales are credit sales, (2) all credits to Accounts Receivoble reflect cosh receipts from customers, (3) all purchoses of inventory are on credit, and (4) all debits to Accounts Poyable reflect cosh poyments for inventory. Additional Information on Current Year Transactions a. The loss on the cosh sole of equipment wos $6,125 (detsils in b). b. Sold equipment costing $49,875, with accumulated depreciation of $31,125, for $12625 cosh. c. Purchssed equipment costing $97,375 by poying $32,000 cosh and signing o long-term notes poysble for the bolance. d. Poid $46,525 cosh to reduce the long-term notes poysble. e. Issued 2,600 shares of common stock for $20 cash per share. f. Declared and paid cosh dividends of $50,300. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ FORTEN COMPANY } \\ \hline \multicolumn{6}{|c|}{ Spreadeheet for statement of Cash Flowa } \\ \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|}{ Analysla of Changes } & \multirow{2}{*}{\begin{tabular}{l} December 31 , \\ Current Year \end{tabular}} \\ \hline & & & Deblt & Credlt & \\ \hline \multicolumn{6}{|l|}{ Balance sheet-debit } \\ \hline Cask & $ & 74,500 & & & 51,400 \\ \hline Acoounts receivable & & 51,625 & & & \\ \hline Iriventory & & 252,800 & & & \\ \hline Prepsid expenses & & 2,025 & & & \\ \hline \multirow[t]{2}{*}{ Equipment } & & 109,000 & & & \\ \hline & \$ & 489,950 & & & 51,400 \\ \hline \multicolumn{6}{|l|}{ Balance sheel-credit } \\ \hline Acoumulated depreciation-Equipment & $ & 46,500 & & & \\ \hline Accounts payabile & & 116,175 & & & \\ \hline Lang-term nobes paysable & & 55,950 & & & \\ \hline Common stock, $5 par value & & 151,250 & & & \\ \hline Paid-in capital in exceess of par value, comman stock & & 0 & & & \\ \hline \multirow[t]{2}{*}{ Retained earnings } & & 120,075 & & & \\ \hline & \$ & 489,950 & & & \$ \\ \hline \multicolumn{6}{|l|}{ Statement of cash flaws } \\ \hline \multicolumn{6}{|l|}{ Operating activities } \\ \hline & & & & & \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline & & & 7 & & \\ \hline \multicolumn{6}{|l|}{ Investing activities } \\ \hline \\ \hline \\ \hline & & & & & \\ \hline \multicolumn{6}{|l|}{ Financing activities } \\ \hline \\ \hline & & & & & \\ \hline & & & & & \\ \hline 7 & & & & & \\ \hline \multicolumn{6}{|l|}{ Nan cash investing and financing activities } \\ \hline \multicolumn{6}{|l|}{ Purchase of equipment financed by long-term notes payable } \\ \hline & & & 0 & 5 & \\ \hline \end{tabular}