Amortize specific period ranges

[Dave Britten]

(06-20-2015 01:45 AM)Don Shepherd Wrote:  

(06-20-2015 01:02 AM)Dave Britten Wrote:  Can this be implemented easily with a 17BII solver equation? I don't see any amort functions mentioned in the manual, and I don't think you can directly reference the values stored in the TVM variables.

Dave, could the solver functions USFV() or USPV() give you what you want? I remember using them years ago for a project, but I can't remember the details now. I do remember thinking at the time, however, that they are very useful in certain situations.

I think you are right about not being able to reference the TVM variables in a solver equation, but I seem to recall that the 19bii solver (unlike the 17bii solver) did have some functions for those values.

Don

I believe you can use USPV and USFV to do TVM calculations "by hand" if necessary (though the 19BII has actual TVM functions in the solver). I don't see any functions for directly performing amortization, so you would probably have to do it yourself with the usual sum function.