E8-16 Preparing Cash Budget [LO 8-4] Walter Company has the following information for the month of March: Cash balance, March 1 Collections from customers Paid to suppliers Manufacturing overhead Direct labor Selling and administrative expenses S 19,170 46,000 24,200 8,000 9,200 6,100 Walter pays all expenses in the month incurred. Manufacturing overhead includes $2,150 for machinery depreciation, but the amount for selling and administrative expenses is exclusive of depreciation. Additionally, Walter also expects to buy a piece of property for $8,900 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $19,000 Required Prepare Walter's cash budget for the month of March Beginning Cash Balance Budgeted Cash Receipts Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed Ending cash balance