Juniper Systems Allegro DOS Manual - Manual (Page 137)

Windows CE Page 4-71
Financial Functions
Ddb(cost, salvage, life, period, factor) Returns the depreciation of an asset
for a specified period using the double-declining balance method (you
can specify another method). Cost is the initial cost of the asset. Salvage
is the value at the end of the depreciation. Life is the number of periods
over which the asset is being depreciated. Period is the period for which
you want to calculate the depreciation. Period must use the same units
as life. Factor is the rate at which the balance declines. If factor is
omitted, it is assumed to be 2. All the arguments must be positive
numbers.
Example: Ddb(30000, 500, 3650, 10) equals 16.357.
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 find 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%.
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.