I use a Per Diem rate on the amount due something like this...

In the InterestArrears col:

=PerDiemAmnt*(TODAY()-DueDate)

...where PerDiemAmnt is calculated by dividing the annual interest rate
by days/year, and multiplying AmountPastDue by the result as a
percent...

So PerDiemAmnt = AmountPastDue*(AnnualRate/DaysPerYr)%

In your scenario, though, you need a separate col for entering the
short payment amount (AmountPastDue) for each DueDate, and run separate
calcs for each short payment amount so that you also track interim
payments correctly without messing up your payment history...

The 1st payment was due 05/05 but paid 06/13 and so $10K is late for
the days between DueDate and DatePaid. Same goes for each subsequent
DueDate.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion