Thanks but this is not what I am looking for.
My cash flow changes all the time according to the scenario I run, so I need
a formula to give me the year of ROI
--
caroline


"Fred Smith" wrote:

Just do a running balance or your cash flows. That will tell you when it
turns from -ve to +ve.

Regards,
Fred.

"caroline" wrote in message
...
hello,
I am doing a cash flow and NPV calculation. so far so good....
However I also want to find out the year of my return of investment (i.e.
when the cash flow turns from a Negative to a Positive). Any idea how I
could
do this easily?
thanks
--
caroline