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.