# XNPV function

XNPV(rate, values, dates) XNPV(rate; values; dates)

## rate — Number or { Number }

The annual interest date.

## values — { Number }

An array containing payments made. This number is positive if paid to you and negative if you pay.

## dates — { Number }

An array containing the dates on which those payments are made.

## Returns — Number or { Number }

The net present value of an investment with irregular cash payments.

Returns the net present value of an investment with irregular cash payments.

## Examples

XNPV(5%, { -1000, 500, 550 }, { DATE(2008, 1, 1), DATE(2009, 1, 1), DATE(2009, 7, 1) })XNPV(5%; { -1000; 500; 550 }; { DATE(2008; 1; 1); DATE(2009; 1; 1); DATE(2009; 7; 1) })

Returns roughly \$-12.65. If you bought an investment for \$1,000 on January 1, 2008, which paid \$500 on January 1, 2009 and \$550 on July 1, 2009 you would make a small loss, compared to investing at a 5% interest rate.

XNPV(5%, { 0, 500, 550 }, { DATE(2008, 1, 1), DATE(2009, 1, 1), DATE(2009, 7, 1) })XNPV(5%; { 0; 500; 550 }; { DATE(2008; 1; 1); DATE(2009; 1; 1); DATE(2009; 7; 1) })

Returns roughly \$987.35, the net present value on January 1, 2008, of an investment which paid \$500 on January 1, 2009 and \$550 on July 1, 2009, using a 5% interest rate.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.