Calculatin NPV for a range of numbers.
 

hi everyone! i require some assistance with a model i am trying to
build. what i want to do is to calcuate the NPV for a range of numbers.
i cant do each individually as there are too many combinations (ie costs
running from 1000-10000, benefits between 56250 and 84750 with three
interest rates). is there anyway i can calculate these values? perhaps
i dont need to as all i want to do with the results is run descriptve
statistics on them. can anyone help?
thanks very much, any help is massively appreciated.
j.


--
kjd23
------------------------------------------------------------------------
kjd23's Profile: http://www.excelforum.com/member.php...o&userid=29346
View this thread: http://www.excelforum.com/showthread...hreadid=490565