Loan drawdown and repayment - how to automate

Dear All

My company has a flexi loan where we can drawdown or repay anytime, but has to be made in the multiples of $50,000.

We have cash inflows and outflows and any cash deficit will be covered by the loan drawdown. Any cash surplus will be used to repay the loan.

All the same time, we have to maintain a minimum cash balance of $40,000 to $50,000.

Currently, what I do is to manually enter the loan drawdown/repayment amounts year-by-year, and have to repeat the process whenever the cash flow changes.

Appreciate your help to automate the process with formulas.

Thank you!
Joseph

Loan Drawndown & Repayment.png