Prepare a cash budget for Data Logic using the following assumptions. Collections on total sales have been projected to be: 20% collected during the month of sale 60% collected one month after sale 20% collected two months after sale All expenses are paid during the month incurred, except rent and labor. Rent and labor will be paid the following month. Cash on hand on July 1,2012 is projected to be $25,000. A minimum cash balance of $25.000 should be maintained through the cash budget penod Prepare a monthly cash budget for the last six months of 2012 . How much monty will Data Logic need to borrow (or how much will it have avalable to invest) each moneth? Use the if function to calculate the loan requirement and surplus for each month. Save Excel file as cashflowt Prepare a monthly cash budget for the last six months of 2012 Change the following assumptions 1 Coliections on sales have been projected to be 35% collected during the month of sale 55% colected one morath affer tale 5% collected two months after sale 5% will be uncollectable Haw much money will Dara Logic need to bonow for how much will a base aacable to imest) 46 - each month? Use the IF function to calculate the losn require mert and aupius for wack rortit. 49 Save Excel file as cashflow2 50