Tags: automatically, calculating, discounted, elaborate, excel, macros, microsoft, msdn, payback, reading, software, user

Calculating Discounted Payback automatically in Excel

On Microsoft » Microsoft Excel

780 words with 0 Comments; publish: Thu, 22 May 2008 18:12:00 GMT; (306125.00, « »)

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

All Comments

Leave a comment...

  • 0 Comments