Syntax: @NPV(R, CF)
R = periodic interest rate
CF = future cash flow series represented by a range
@NPV returns the present value of a series of future cash flows, CF, at a given rate R. The function is given by:
Blanks and text are treated as zeros.
Examples:
@NPV(.095, C3..C8) = 287.29, where the interest rate is 9.5% and the future cash flow is in the range C3..C8 and are each $65
@NPV(.10, C3) = Error! cash flow series must be a range