Prepare a cash budget for Greshak Company using the following assumptions: Collections related to all sales have been projected to be: 35% collected during the month of sale 40% collected one month after sale 25% collected two months after sale Expenses are projected to be as follows: Projected Additional general information is as follows: All expenses are paid during the month incurred. Cash on hand at July 1, 2021 is projected to be $15.000. A minimum cash balance of $15.000 should be maintained throughout the cash budget period (the amounts needed to maintain that balance will be borrowed if necessary). Required - Part I: Prepare a monthly cash budget for the last six months of 2021 (July - December). How much money will Greshak Company have to borrow (or how much will it have available to invest) each month? Use the "=IF(V" function to calculate the loan requirement and surplus for each month. Required - Part II: Create a copy of the analysis above in another worksheet tab. Prepare another monthly projected cash budget for the last six months of 2021 (July - December). Change the following assumptions: Collections on sales have been projected to be: 35% collected during the month of sale 40% collected one month after sale 22% collected two months after sale 3% will be uncollectible How much money will Greshak Company need to borrow (or how much will it have available to invest) each month? Use the "=|F(" function to calculate the loan requirement and surplus for each month