Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > T

TERM1

Scroll Prev Top Next More

(TERM1(pv,int,fv))

 

Returns the number of compounding periods (the term) for a return of future value fv, based on the present value, pv, and the interest rate, int.

 

In the following example, TERM1 returns the number of months your money must stay invested if you want to accumulate $10,000 on an initial investment of $5,000 at a compounded monthly rate of 1% (12% annually). The value of vterm1 (the term) is 70.

 

SET VAR vterm1 = (TERM1(5000,.01,10000))