I
ile
Hi
How to calculate NPV of an investment occurring in three years (2012-2014)
and followed by savings it creates (2015-2030)? I wanted to calculate the NPV
in the beginning of year 2009. Basically my data is row 1: years 2009-2030,
row 2: investment (i.e. negative values) and row 3: savings (positive values).
The NPV function gives different results when the blank cells have zeros or
not. How the blank cells shuld be treated?
Please advise
How to calculate NPV of an investment occurring in three years (2012-2014)
and followed by savings it creates (2015-2030)? I wanted to calculate the NPV
in the beginning of year 2009. Basically my data is row 1: years 2009-2030,
row 2: investment (i.e. negative values) and row 3: savings (positive values).
The NPV function gives different results when the blank cells have zeros or
not. How the blank cells shuld be treated?
Please advise