XNPV

Try it

When to use it

When should I use XNPV instead of NPV?

Use XNPV when cash flows occur on irregular dates — it accepts an explicit dates array and discounts each flow by its actual elapsed time, whereas NPV assumes equal spacing between periods.

Used in

finance

Syntax

XNPV(rate, values, dates)

Examples

=XNPV(0.08,{200,250,300},{DATE(2012,6,23),DATE(2013,5,12),DATE(2014,2,9)}) // => 698.112843006581