User Manual

Windows CE Page 4-125
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.
PPmt(rate, per, nper, pv, fv, type) Returns the payment on the principal
for a given period of an investment. For more information see Pmt. Example:
Ppmt(0.01, 1, 36, 1000) equals -23.21.
Pv(rate, nper, pmt, fv, type) Returns the present value of an investment.
For more information see Pmt.
Example: Pv(0.01, 5*12, 1000, 0) equals -44955.04.
Rate(nper, pmt, pv, fv, type, guess) Returns the interest rate per period of
an annuity. For more information see Pmt. Guess is your guess for what the
rate will be.
Example: Rate(36, -300, 10000, 0) equals 0.42%.
Sln(cost, salvage, life) Returns the straight-line depreciation of an asset for
one period. Cost is the initial cost of the asset. Salvage is the value at the end
of the depreciation. Life is the number of periods.
Example: Sln(40000, 5000, 8) equals 4375.
Syd(cost, salvage, life, period) Returns the sum-of-years’ digits
depreciation of an asset for a specified period. Cost is the initial cost of the
asset. Salvage is the value at the end of the depreciation. Life is the number of
periods. Period is the period.
Example: Syd(40000, 5000, 8, 8) equals 972.22.