Gerry Jacobs, financial analyst for Best Valu Supermarkets, han prepared the following sales and cash disbursement estimates for the period Aupant through December of the current year Sales Cash Disturments $300 $400 Month August September October November 500 100 600 600 500 450 500 Demir 700 70 percent of sales we fiecast, the remaining 10 percent are collected one month later. All listansements we on a cash basis. The film withes to maintain a minimum cudi Hutance of se. The beginning and balance in September a $25. Prepare a cash badpet for the mouth of October November, and December, noting any needed financing on exces cant wallable. Calculate Net Cash Flow in Sep Dec Ending Cash Balance in Oct Nov Sep Oct Nov Dec Required Financing in Sep OC Nov Dec 0 Excess Cash in Sep=0 Oct 0 Novo Dec