Thanks, but this is not exactly what I am looking for
My NPV is calculated as follow:
=NPV($H$115,$H$109:OFFSET($H$109,0,H108-$H$108))
where $H$115 is the rate
line 109 is the cash flow for each year and 108 are the years
and this formula is dragged for 20 years. I need to see the NPV for 20 years
in case the project stops.

But I also need to display the year of ROI.
I hope that I am clear, not sure :)
thanks any way

--
caroline


"Niek Otten" wrote:

Hi Caroline,

Look in HELP for the NPER() function
Or, even better, look at this article, whicht explains all these related
functions:

http://office.microsoft.com/en-us/ex...117451033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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