Table 12-2. Solver Functions for Equations (Continued)

 

Function

 

Description

 

 

 

 

 

Σ(cfr:c1:c2:s:expr)

 

Summation of the algebraic expression

 

 

 

expr for values of the counter ctr,

 

 

 

stepping from c1 to c2 at increments of s.

 

SIZEC(CFLO-listname)

 

See page 176.

 

 

The number of the last flow in specified

 

SIZES(SUM-listname)

 

CFLO list.

 

 

The number of items in specified SUM

 

 

 

list.

 

SPFV(i%:n)

 

Future value of a single $1.00 payment;

 

 

 

equivalent to (1 + i% ⎟ 100)n. n is the

 

 

 

number of compounding periods. i% is

 

 

 

the interest rate per compounding

 

 

 

period, expressed as a percentage.

 

SPPV(i%:n)

 

Present value of a single $1.00

 

 

 

payment; equivalent to 1 ⎟ SPFV(i%:n).

 

 

 

n is the number of compounding

 

 

 

periods. i% is the interest rate per

 

 

 

compounding period, expressed as a

 

 

 

percentage.

 

SQ(x)

 

Square of x ; x2.

 

SQRT(x)

 

Square root of x ; X .

 

#T(CFLO-listname:flow#)

 

The number of times that specified cash

 

 

 

flow occurs.

 

TRN(x:y)

 

Truncates x to y decimal places if 0 ≤ y

 

 

 

≤11, or truncates x to y significant digits

 

 

 

if －12 ≤ y ≤－1. y must be an integer.

 

USFV(i%:n)

 

Future value of a uniform series of

 

 

 

$1.00 payments; equivalent to

 

 

 

(SPFV(i%:n)－1) ⎟ (i% ⎟100). n is

 

 

 

number of payments. i% is periodic

 

 

 

interest rate, expressed as a

 

 

 

percentage.

 

USPV(i%:n)

 

Present value of a uniform series of

 

 

 

$1.00 payments; equivalent to

 

 

 

USFV(i%:n) ⎟ SPFV(i%:n). n is number of

 

 

 

payments. i% is periodic interest rate,

 

 

 

expressed as a percentage.

 

 

 

12: The Equation Solver 171

File name : English-M02-1-040308(Print).doc

Print data : 2004/3/9