Please show how it's done

Cash Budget with minimum balance requirement Samson, Inc. requires a $5,000 per month minimum cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month. Any excess cash is used to repay loans at month end. The cash balance on May 1 is $5,500 and the company has no outstanding loans. Forecasted cash reciepts and cash payments follow. Prepare a cash budget for May, June, and July