Gerry Jacobs, a financial analyst for Best Valu Supermarkets, has prepared the following sales and cash disbursement estimates for the period August through December of the current year.

Month	Sales	Cash Disbursements
August	$500	$400
September	600	600
October	600	800
November	700	500
December	800	600

90 percent of sales are for cash, the remaining 10 percent are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September is $25. Prepare a cash budget for the months of October, November, and December, noting any needed financing or excess cash available.

Calculate

Net Cash Flow in

Sep = Blank Oct = Blank Nov = Blank Dec = Blank

Ending Cash Balance in

Sep = Blank Oct = Blank Nov = Blank Dec = Blank

Required Financing in

Sep = Blank Oct = Blank Nov = Blank Dec = 0

Excess Cash in

Sep = 0 Oct = 0 Nov = 0 Dec = Blank

Gerry Jacobs, a financial analyst for Best Valu Supermarkets, has prepared the following sales and cash disbursement estimates for the period August through December of the current year. Month Sales Cash Disbursements Aueust $500 $400 September 600 600 October 600 800 November 700 500 December 800 600 90 percent of sales are for cash, the remaining 10 percent are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September is $25. Prepare a cash budget for the months of October, November, and December, noting any needed financing or excess cash available. Calculate Net Cash Flow in Sep = Oct = Nov = Dec = Ending Cash Balance in Sep = Oct = Nov = Dec = Required Financing in Sep = Oct Nov = Dec = 0 Excess Cash in Sep = 0 Oct = 0 Nov = 0 Dec =