Exercise 10-29 (Algo) Cash Budget [LO 10-4] Marsha Incorporated has the following budgeted data for the coming year: Cash balance, beginning Collections from customers Direct materials purchases Expenses: Operating expenses Payroll Income taxes Other: Machinery purchases $ 16,400 146,400 26,400 52,800 76,400 6,000 31,400 Operating expenses include $21,400 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. Required: 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.) Required: 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.) Answer is not complete. Marsha, Inc. Cash Budget for Coming Year Beginning cash balance $ 16,400 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: $ 146,400 162,800 $ 31,400 76,400 6,000 (98,800) Purchase of machinery 31,400 Financing activities: Cash excess (shortage) before financing $ (8,800) Minimum cash balance required New financing required Budgeted end-of-period cash balance 25,000 33,800