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


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:

\begin{displaymath}
\frac{\log ( 1 + ( {\it FV} \frac{R}{P} ))}{\log (1 + R)}
\end{displaymath}

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

Excel function: N/A


next up previous contents index
Next: TIME Up: A. Function Reference Previous: TBILLYIELD   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003