Hi. I think it is the way it is used. Say in your formula you have something worth 2000 in 5 years at 8%, you would write; NPV = 2000/(1+0.08)^5 =1361.17 In LO the function is for a series of payments, you have 1 payment at 5 years, you would write; =NPV(0.08;0;0;0;0;2000) = 1361.17
steve On 19/03/11 10:04, NoOp wrote: > 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 ***
