Create a statement of cash flows using the excel spreadsheet template below. The cash flows statement should include the Operating, Investing and Financing sections and should be based on the indirect method. use the financial information you are given below.

The first spreadsheet template includes the analysis template and the second includes the statement of cash flows template.

Oloperating) (Investing) or F (financing) Dec. 31, 2020 Dec 31, 2019 Change Operating Investing Financing No Cash Effect Total ASSETS LIABILITIES STOCKHOLDERS' EQUITY Totals Jensen Inc. Statement of Cash Flows Year Ended Dcember 31, 2020 2020 Cash flow from operating activities Cash flow from investing activities Cash flow from financing activities Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Financial Information for Jensen Inc. Jensen Inc. Income statement Year Ended December 31, 2020 Sales 850,000 Cost of goods sold 490,000 Gross Profit 360,000 Wages and other operating expenses 150,000 Depreciation expense 46,000 Interest expense 15,000 Dividend investment income Loss on sale of equipment (9,000) 5,000 (7,000) Gain on sale of investments Total expenses and other income 200,000 Income before income taxes 160,000 Income tax expense 54,000 106,000 Net income Jensen Inc. Balance Sheets Dec. 31, 2020 Dec. 31, 2019 Assets Cash 44,000 27,000 Accounts receivable 45,000 30,000 107,000 87,000 Inventory Prepaid expenses 12,000 5,000 Long-term investments 0 53,000 Land 180,000 100,000 354,000 275,000 Building, net of accumulated depreciation Equipment, net of accumulated depreciation 187,000 211,000 Total Assets 929,000 788,000 24,000 18,000 8,000 5,000 Liabilities and Stockholders' Equity Accounts payable Interest payable Income tax payable Notes payable Bonds payable 8,000 12,000 25,000 0 165,000 135,000 Preferred stock 80,000 80,000 Common stock 508,000 111,000 929,000 488,000 50,000 Retained earnings Total Liabilities and Stockholders' Equity 788,000 During 2020, the company incurred the following transactions and events: 1. Recorded depreciation of $16,000 on buildings and $30,000 on equipment. 2. Sold long-term investments with an original cost of $53,000 for $60,000 in cash. 3. Purchased land for cash. There were no sales of land during the year. 4. Sold equipment that originally cost $46,000 and had $27,000 of accumulated depreciation for cash. The company reported a loss of $5,000 on the sale. 5. Purchased equipment for $25,000 that was financed with notes payable. 6. Issued bonds payable at face value for cash. There were no repayments of bonds during the year. 7. Paid cash to purchase a new building. There were no sales or disposals of buildings during the year. 8. Issued 2,000 shares of common stock for cash at $10 per share. 9. Declared and paid a $45,000 cash dividend