I need a little program could also be in Excel where I can calculate the amount someone owes me a loan.
There are many periods of missed payments so the program needs to calculate the compounded interest for those periods.
Also part way through the loan the amount of the loan was increased. The payments have remained the same.
I want to know the amount that I am now due.
I am perfectly happy to input all the data, i.e. original amount, interest rate etc, and the dates upon which I have received payment provided the program shoots me out the answer.
Thanks.