Re: [libreoffice-users] Re: NPV Function in Calc

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