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

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 =