Future Value of Cash Flows
 

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

Future Value of Cash Flows
 

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

Jim Thomlinson


"Goalpost" wrote:

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

Future Value of Cash Flows
 

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