Thread: Year or ROI
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Year or ROI

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