Interests, payment and payment plan

**tiwas** · 06-01-2009, 03:19 AM

Hi all!

I have a loan from my father which I need some help calculating. Hopefully, some of the experts in here can give me a hand

What I'm looking for is something which will let me enter the day the money was lent (there are several smaller amounts), and calculate these including interest and interest on the interest. Then, I will pay back in several steps, this debt but I would like to subtract the paid amount on the day it's registered and then stop acumulating interest. The last step is to show the outstanding debt.

I guess the payments and the calculation of interest could be done by some sort of nested, re-iterating function...?...

If someone could help me with this I would be REALLY grateful :D

Cheers!

**squiggler47** · 06-01-2009, 04:50 AM

This might be what you want, to add a line click on bottom line of table

Top figure is the ammount owed as of today, will refresh instantly all interest is calculated for ballance between transactions!