91
PV(rate, nper, pmt,
fv
,
type
)
Computes the present value for a fixed payment
pmt made for the number of periods nper, at a
fixed interest rate. It assumes the future value to
be 0 if
fv
is omitted, assumes the payments are
made at the end of the periods if
type
is 0 or
omitted, and at the beginning of the month if
type
is 1.
Example: PV(7.5%,20,-10000) returns
101944.91.
PV(0.08/12,12*20, -500, 10000,1) returns
58145.95.
RATE(nper, pmt, pv,
fv
,
type
,
guess
)
Computes the periodic interest rate required for a
fixed payment pmt made for the number of periods
nper to have the present value pv. It assumes that
the future value to be 0 if
fv
is omitted. It assumes
payments to be made at the end of the periods if
type
is 0 or omitted, and at the beginning of the
periods if
type
is 1.
guess
is as a starting approxi-
mation to the expected result; it is assumed to be
10% if omitted.
Example: RATE(48, -200, 8000) returns 0.77%.
The annual rate would be 0.77%*12 which is
9.2%. RATE (60, -700, 100000, -140000, 1, 1%)
returns 0.0117 (or 1.17%).
SLN(cost, salvage, life)
Computes the straight-line depreciation of an
asset, acquired at cost, with the specified life and
estimated final salvage value. It spreads the rate
of depreciation evenly among all periods.
Example: SLN(30000, 7500, 10) returns 2250.
SYD(cost, salvage, life, per)
Calculates the sum-of-the-years depreciation for
an asset, acquired at cost, with specified life and
estimated final salvage, for the specified period
per.
Example: SYD(30000, 7500, 10, 1) returns
4090.91.
To Next Page
Loading...
