90
IRR(range,
guess
)
Calculates the internal rate of return for a range of
values that occur at equal and regular intervals.
guess
is a starting approximation to the expected
result, or assumed to be 0.1 (10%) if omitted.
Example: IRR(C9:G9) returns -2.12% where
C9:G9 contains (-70000, 12000, 15000, 18000,
21000).
IRR(C9:E9, -10%) returns -44.35% (same interval
as above.)
NPER(rate, pmt, pv,
fv
,
type
)
Calculates the number of periods for an invest-
ment pv based on periodic, constant payments
pmt and a constant interest rate.
fv
is the cash
balance after the last payment is made. If
fv
is
omitted, it assumes to be 0. If
type
is 0 or omitted,
it is assumed that payments are made at the end
of each period, if
type
is 1, at the beginning of
month.
Example: NPER(1%,-100,1000) returns approxi-
mately 11.
NPER(12%/12,-100,-1000,10000,1) returns
approximately 60.
NPV(rate, values...)
Computes the net present value for a range or a
series of values that occur at equal and regular
intervals, when discounted at a fixed, periodic
interest rate. It assumes that cash flow occurs at
the end of each period.
Example: NPV(8%,C15:G15) returns 41922.1
where C15:G15 contains (8000, 9200, 10000,
12000, 14500).
NPV(10%,-10000,3000,4200,6800) returns
1188.44.
PMT(rate, nper, pv,
fv
,
type
)
Computes the periodic payment needed to pay off
the starting principal pv over the number of
periods nper, at a fixed interest rate. It assumes
the future value, or a cash balance after the last
payment is made, to be 0 if
fv
is omitted; it also
assumes the payments are made at the end of
each period if
type
is 0 or omitted, and at the
beginning of the month if
type
is 1.
Example: PMT(1%,5,-5000) returns 1030.20.
PMT(8%/12,10,10000,0,1) returns -1030.16.
To Next Page
Loading...
