NPV(n1, n2 [, ...])
A numeric value or expression representing a cash flow value, which must occur at the end of a period. It is important that the values specified in n2 and beyond are in the correct sequence.
The function returns an error if n1 is negative or 0. If any of the parameters are null, the function returns null.
4694.83568075117, which is the net present value of an investment earning 6.5% per year that will generate $5000.
11529.60863329007, which is the net present value of an investment earning 10% a year that will generate $500, $1500, $4000, and $10,000 in each of the next four years.
273.14193838457, which is the net present value of an investment earning 2.75% year that will generate $50, $60, $40, $100, and $25 in each of the next five months.

NPV