No.

XNPV will calculate the present value (in other words, the value at the *start*
of the series). However, you want "XNFV", the value at the end of the series
(which Excel doesn't have). function).

You can simulate an XNFV function with:

=FV(rate,term,0,xnpv(rate,cashflows,dates))

--
Regards,
Fred


"Goalpost" wrote in message
...
Is there an excel function that will calculate a current value of past
payments which were dissimilar in amount and time (diff payment amounts
occuring at various times)?