Check out this site:
http://www.tvmcalcs.com/excel_tvm_functions_page3.htm
It sums things up pretty well (no pun intended). Look at the section titled
€˜Future Value of Uneven Cash Flows Follow the example here. Post back if
you have any more questions.
Regards,
Ryan€”
--
RyGuy
"TonyY" wrote:
How to Return the FUTURE VALUE for a schedule of cash flows that is NOT
PERIODIC with a fixed internal rate.
In other words the other side of XIRR function where a series of dates and
cash flows and internal rate is known.
or
XNPV (with FUTURE value rather than PRESENT value)