(AppendiX 11B) Using a Spreadsheet to Prepare a Statement of Cash Flows Jane Bahr, a controller of Endicott \& Thurston, provided the following balance sheet information: LTARTI TTTEC A MA EAUTTU 1. Computing equipment with a cost of $250,000 and accumulated depreclation of $230,000 was sold for $5,000, New computing equipment was purchased for. $375,000. 2. New office furniture was purchased at a cost of $35,000. 3. Depreciation expense was $40,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 $25,000 principal payment on the long-term note was made. 6. A portion of the cash needed to purehase computing equipment was secured by issuing bonds payable for $140,000 cash. 7. Net income was $71,000 and dividends were $37,000. Required: 1. Using the data above and Exhibit 10 as a gulde, create a spreadsheet to prepare a statement of cash flows. Cash flows from operating activities: Adjustments to reconcile net income to net cash provided by operating activities: Cash flows from investing activities: Cash flows from financing activities: Cash flows from investing activities: Cash flows from financing activities: Cash, Jan. 1 Cash, Dec, 31