I have a client who borrows and repays money at different times. Assume the following example
What is the correct way to calculate the repayment rate and more importantly, the time until repayment (i.e. how long does it take to pay back a the borrowed amount) when there are multiple borrowing and repayment activities? How can I weight the time until repayment by the amount that is being borrowed and repaid?