View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Helge's Helge's is offline
external usenet poster
 
Posts: 16
Default Calculate NPV - Array must be flexible

On 18 Jan, 22:53, "RB Smissaert"
wrote:
What is NPV and how is it calculated?

RBS

"Helge's" wrote in message

...



I have a database with different dataset. That is the input to a
worksheet that calculate NPV.


The array that I want to calculate NPV could look like this:


0
0
-200
50
50
50
-10
40
30
-20
-20
-20


The array for this dataset must be from -200 to 30. How could the
arrayargument in the NPV-function look like? I am thinking of using
OFFSET or some kind of Arrayfunction.– Skjul sitert tekst –


– Vis sitert tekst –


NPV calculates the net present value of an investment with the
discount rate and several future payments and income: =NPV(rate,array)