We are assuming 23.99% simple interest, calculated and compounded daily
(ooh, that's nasty! )

There may be simpler ways to do this, but this way should get you your
answer:

Beginning in F1 enter the start date (i.e. 10/22/03) and auto fill that
down until you reach 8/23/05 (F672). In G1 enter the beginning value of
the loan ($4324.13). In G2, enter this formula:

=G1+(G1*(0.2399/365)) and copy down to the end of the range (double
click on the drag handle)

For more data, you could see the total amount of interest added to date
by using this in H2:

=G2-G1

and this in H3, copied down:

=G2-G1+H2

Your total will be in G672 (you can continue down with the formulas if
the bugger hasn't paid up yet).

Good Luck!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=398353