Appreciate the help

Mike's Motors Corp. manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each monthend. If necessary, the company borrows to meet this requirement, at a cost of 2% interest per month (paid at the end of each month). Any cash balance above $30,000 at monthend is used to repay loans. The cash balance on July1 is $32,000, and the company has no outstanding loans at that time. Forecasted cash receipts and forecasted cash payments (other than for loan activity) are as follows. Cash Cash Receipts Payments July $ 83,333 $111,333 August 139,333 97, 933 September 148,888 125,488 Prepare a cash budget for July, August. and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your nal answers to the nearest whole dollar.) Prepare a cash budget for July, August. and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your nal answers to the nearest whole dollar.) Total cash available Preliminary cash balance Ending cash balance Loan balance, Monthend