On 03/18/2011 10:28 AM, Andrew Priebe wrote:
Hello, I recently upgraded from OpenOffice and everything seems to be working great. I do have a question about the built-in NPV function in Calc however. Calculating the NPV of a given cash flow using the built-in function and doing a manual calculation provide drastically different results. I am not sure what the built-in function uses, but I am using the fairly standard formula of: (Value of Cash flow at period t) / (1 + r) ^ t Is this expected behavior? I am using a Debian build of version 3.3.1.
What specifically are you entering in the NPV formula? These might help: http://help.libreoffice.org/Calc/Financial_Functions_Part_Two#NPV <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_NPV_function> try these examples: http://office.microsoft.com/en-us/excel-help/npv-HP005209199.aspx -- Unsubscribe instructions: E-mail to users+help@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***