Future Value of Cash Flows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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