Future Value of Cash Flows

[Guest]

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)?

 

[Guest]

XNPV might do the trick. Look it up in help...

 

[Fred Smith]

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))