Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Walter Company has the following information for the month of March Cash balance

ID: 2552394 • Letter: W

Question

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 18,270 43,000 23,600 7,400 8,900 5,500 Walter pays all expenses in the month incurred. Manufacturing overhead includes $1,850 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,300 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $13,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

Explanation / Answer

Prepare cash budget :

Beginning cash balance 18270 Budgeted cash receipts 43000 Budgeted cash payments 51850 Preliminary cash balance 9420 Cash borrowed 4000 Ending cash balance 13420