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