I am using your gem on a project and the npv calculation seems to give different outputs than when I use Excel with the same inputs.
For instance, when I try [1,2,3].npv(0.045) it gives 5.661 whereas Excel gives 5,42.
Do you have any idea what can cause the difference?
Hi,
I am using your gem on a project and the npv calculation seems to give different outputs than when I use Excel with the same inputs. For instance, when I try [1,2,3].npv(0.045) it gives 5.661 whereas Excel gives 5,42. Do you have any idea what can cause the difference?
Thanks