6) Complete a Cash Budget given the information provided in the excel sheet tab Cash budget. Determine the net cash flow for December through April. Look carefully there is a twist from the homework. Monthly Cash Receipts Actual Sales Pro Forma Sales and Cash Rece November December January February March 5 22,525 $ 26.455 5 27.444 5 20.000 $ 25.000 Sales Current Month Collection at 32% of Sales Outstanding Current Month Accounts Receivable (AR) 72% of AR Collected Month Following Sale 28% of AR Collected in 2nd Month Following Sale Total Receipts Monthly Cash Payments S 10.280 5 8,645 5 7.450 8.525 5 Accounts Payable 65% Accounts Payable paid this Month 35% Accounts Payable paid next month Total Payments Monthly Cash Budget Total Receipts Total Payments Net Cash Flow