Marsha Inc. has the following budgeted data for the coming year: 11 $ 17,000 147,000 27,000 8 02:40:55 Cash balance, beginning Collections from customers Direct materials purchases Expenses: Operating expenses Payroll Income taxes Other: Machinery purchases 54,000 77,000 6,000 32,000 Operating expenses include $22,000 depreciation for buildings and equipment. All purchases of materials are paid for in the period of purchase. The company requires a minimum cash balance of $25,000. Compute the amount the company needs to finance or the excess cash available for Marsha to invest. (Cash shortage should be indicated with a minus sign.) Marsha, Inc. Cash Budget for Coming Year Beginning cash balance Net cash flow from operations: Cash inflows: Cash collections from customers Cash outflows: Direct materials purchases Operating expenses Less: Depreciation Payroll Income taxes Investing activities: Purchase of machinery Financing activities: Cash excess (shortage) before financing Minimum cash balance required New financing required Budgeted end-of-period cash balance