| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IRR function when the cash flows are not in array? | Excel Worksheet Functions | |||
| IRR for 2 cash flows | Excel Worksheet Functions | |||
| IRR formula for monthly cash flows | Excel Worksheet Functions | |||
| PV of uneven stream of cash flows | Excel Worksheet Functions | |||
| Future Value function with differenct cash flows | Excel Discussion (Misc queries) | |||
Linear Mode
