Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Cashflow -380 -190 -140 -65 100 130 110 300 350 350 350 350 350 350

Disc Rate 10%
NPV $390.93
XNPV $1,958.43




"Energy" wrote:

Hi there,

hoping someone can clarify something....

Why do you get different NPV values using NPV and XNPV, if the timeframes
are equal distance for the XNPV calculation?

I understand XNPV is for when the cashflow is not periodic??

But surely if the dates are periodic (in this case annually over 12 years)
it should give the same result as the standard NPV calculation?