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)
|