12: The Equation Solver 171
File name : English-M02-1-040308(Print).doc Print data : 2004/3/9
Table 12-2. Solver Functions for Equations (Continued)
Function Description
Σ
(
cfr
:
c
1
:
c
2
:
s
:
expr
)
Summation of the algebraic expression
expr
for values of the counter
ctr
,
stepping from
c
1
to
c
2
at increments of
s
.
See page 176.
SIZEC(
CFLO-listname
)
The number of the last flow in specified
CFLO list.
SIZES(
SUM-listname
)
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
;
x
2
.
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.