Financing and Excel

Please read the relevant parts of your textbook, which refer to cash flow and financial planning. To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a cash budget for his latest venture: Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next 9 months: March 100,000 April 275,000 May 320,000 June 450,000 July 700,000 August 700,000 September 825,000 October 500,000 November 115,000 He has also gathered the following collection estimates regarding the forecast sales: Payment collection within the month of sale 25% Payment collection the month following sales 55% Payment collection the second month following sales 20%...