NPV formula error?

[elle_clara]

Hi, I'm taking a basic course in accounting and for some reason Excel doesn't offer me the correct answer for Net Present Value: when I insert the following data and the following formula, it gives the result as -222.91, although I know from the problem's answer and by using another calculator, online, that the answer should be -245.20

Any idea why that must be? It really bugs me. The only thing I did to Excel was install the Equation Solver. Could that have messed it up?
Any help is greatly appreciated, really don't know what to do here. I can't use an online calculator for all the problems I've got...

 

[alansidman]

The correct formula is =NPV(0.1,A2:A5)+A1

 

[elle_clara]

You're right, this way it gives the correct answer. Thank you, Alan!

 

[MARK858]

@elle_clara, just to add to what Alan has posted have a read of the link below...

https://www.propertymetrics.com/blog/2014/09/30/how-not-to-use-npv-in-excel/

 

[elle_clara]

Heh, that's exactly what I did wrong. Really interesting read, thanks Mark!