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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
