2011 Archives by date, by thread · List index

# 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 ***
```

### Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.