next up previous contents index
Next: TIME Up: A Function Reference Previous: TBILLYIELD

TERM

 

Syntax: @TERM(P, R, FV)

P = amount of periodic payments
R = interest rate
FV = future value of the investment

@TERM returns the number of payment periods for an investment given the periodic payment P, the interest rate R and future value FV. The function is given by:

displaymath16383

Examples:

@TERM(1050, 0.105, 300000) = 34.39

@TERM(R13, RATE, S19) = 16.48, where R13 = 360, S19 = 15000, and RATE is a named cell = 11%

@TERM(100, 0.095, -1) = error!, ``P'' and ``FV'' must have the same sign


next up previous contents index
Next: TIME Up: A Function Reference Previous: TBILLYIELD

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999