Page 1 of 1

Amortization Function

PostPosted: Sun May 07, 2006 1:09 pm
by Nate
Anyone know of a GOOD amortization function that allows one to truly perform calcs based on all variables of a true loan amortization:

N (term)
PV (principal value)
INT (Interest rate)
PMT (payment amount)
FV (future value)

??

Nate

PostPosted: Sun May 07, 2006 2:41 pm
by John Sindelar
This is not really my area, but I've seen Techinfo # 4615 mentioned in this context.

Ben Goldstein also started a thread about this in our custom functions forum.

HTH.

Got it!

PostPosted: Wed May 10, 2006 3:05 pm
by Nate
Thanks, John.