On Feb 19, 9:09 am, caroline
wrote:
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

It might not be what you are "looking for", but if your cash flow
"changes all the time", I cannot imagine any other way to do it.

Perhaps if you offered some specifics, we could be more helpful. For
example, if your cash flow simulation is driven by a mathematical
relationship, there might be a solution. But you would need to let us
know what that mathematical relationship is.

NPER is useful only if your cash flow is the same amount at regular
intervals, or if you have only one date for investment and one date
for redemption. But in that case, you could use PV instead of NPV in
the first place.


----- original posting -----

On Feb 19, 9:09*am, caroline
wrote:
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- Hide quoted text -

- Show quoted text -