Walter Company has the following information for the month of March:

Cash balance, March 1	$	18,870
Collections from customers		45,000
Paid to suppliers		24,000
Manufacturing overhead		7,800
Direct labor		9,100
Selling and administrative expenses		5,900

Walter pays all expenses in the month incurred. Manufacturing overhead includes $2,050 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,700 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $17,000.

Required:

Prepare Walters cash budget for the month of March.

Beginning Cash Balance
Budgeted Cash Receipts
Budgeted Cash Payments
Preliminary Cash Balance
Cash Borrowed
Ending Cash Balanace