Juniper Systems Allegro CX Manual - Manual (Page 158)

158 Allegro CX Owner’s Manual
Fv(rate, nper, pmt, pv, type)
Returns the future value of an investment. Rate is the interest rate
per period. Nper is the total number of payment periods in an
annuity. Pmt is the payment made each period. Pv is the present
value. Type can be 0 or 1 (0 - payments at the end of the period, 1 - at
the beginning). If type is omitted, it is assumed to be 0.
Example: Fv(0.01, 12, -500) equals 6341.25.
IPmt(rate, per, nper, pv, fv, type)
Returns the interest payment for an investment. Per is the period for
which you want to fi nd the interest (must be 1 <= per <= nper). For
more information see Pmt.
Example: Ipmt(0.01, 1, 24, 5000) equals -50.
Irr(values, guess)
Returns the internal rate of return. Values is a reference to cells that
contain the numbers for which you want to calculate the internal rate
of return. Guess is your guess of the result. If guess is omitted, it is
assumed to be 0.1.
Example: A1:A6 contain the following values: $-100,000, $10,000,
$16,000, $20,000, $22,000 and $24,000 Irr(A1:A6) equals -2.43%.
Mirr(reference, interestRate, interestRateReinvested)
Returns the internal rate of return for a series of periodic cash fl ows.
Nper(rate, pmt, pv, fv, type)
Returns the number of periods for an investment. For more
information see Pmt.
Example: Nper(0.01, -100, -1000, 20000) equals 101.
Npv(rate, value1, value2...)
Returns the net present value of an investment. Rate is the rate
of discount over the length of one period. Value1, value2, are
arguments representing the payments (negative values) and income
(positive values).
Example: Npv(10%, -10000, 4000, 5000, 6000) equals 2069.53.
Pmt(rate, nper, pv, fv, type)
Returns the periodical payment for an annuity. Rate is the interest
rate per period, nper is the number of payment periods in an
annuity, pv is the present value, fv is the future value, type see Fv.
Example: Pmt(0.01, 10, 10000) equals -1055.82.