Please show calculations for support.

Foyert Corp. requires a minimum $7,900 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $7,900 and the company has an outstanding loan of $3,900. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. 0.83 points October November Cash receipts $23,900 $17,900 Cash payments 26,850 16,900 December $21,900 14,100 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) X Answer is not complete. FOYERT CORP. Cash Budget For October, November, and December Beginning cash balance Cash receipts October $ 7,900 23,900 31,800 26,850 78 November $ 7,900 17,900 25,800 16,900 December $ 7,900 21,900 29,800 14,100 Total cash available Cash payments Interest on bank loan Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan balance Loan balance - Beginning of month $ 3,900 Additional loan (loan repayment) Loan balance - End of month