Calculating Discounted Payback automatically in Excel
 

Hello,
I've been reading through the user forum's and I've noticed that people
have come up with elaborate Macros to automatically calculate the
discounted payback.

In looking at Jaxworks, I've found one possible solution. It's almost
working for me, but not when I start playing around with my cash flows.


The formula is:

=INDEX((Year-CumulativeDiscountedCashFlow/DiscountedCashFlow),1,SUM(IF(CumulativeNetCashFlow <=0,1,0))+1)

All of the words such as Year, CumulativeDiscountedCashFlow, etc. refer
to rows of values.
For example, Year = row of cells with years 0 to 5.

Is there a glitch in this formula?
Has anyone ever made it work before?
Any other suggestions?

Jordan