ASSETS Current dessets: Cash Accounts receivable Prepaid rent Total current assets Long-term investments Property, plant, and equipment: Current liabilitiest Accounti payable Salaries payable Total current liabilities \begin{tabular}{rr} $58,000 & $56,000 \\ 105,000 & 89,000 \\ \hline$163,000 & $145.000 \end{tabular} Long-term liabilitien Notes payable Bonds payable Total liabilites Equity: Common stock Retained earnings Toral equity Total siabilities and equity 7ocitionial information: 1. Computing equipment with a cost of $250,000 and aceumulated depreciation of $230,000 was told for $5,000. Nev tompurting 2. New office furnicure was purchased at a cost of $35,000. 3. Depreciation expense was $43,000 4. Investments costing $20,000 were sold for cash at a loss of $2,000. Additional investments were purchased for $31,000 cash. 5. A. 525,000 principal payment on the long-term note vat made. 6. A portion of the cash needed to purchase computing equipment was secured by issuing bonds payable foe $140,000 cash. 7. Net income was $72,000 and dividends were 536,000 . Required: 1. Using the dath above and Exh bir 10 as a guide, create a spreadsheet to prepare a staternent of cash flows. 2. Using your spreadsheet, construct the Statement of Cash Flovs below. Assume Endicatt 5 Thurston use the indirect method. Use Endicott and Thurston Associates Statement of Cash Flows For the year ending December 31 Cash flows from operating activities