org.apache.poi.hssf.record.formula.functions
Class Npv

java.lang.Object
  extended by org.apache.poi.hssf.record.formula.functions.NumericFunction
      extended by org.apache.poi.hssf.record.formula.functions.NumericFunction.MultiArg
          extended by org.apache.poi.hssf.record.formula.functions.Npv
All Implemented Interfaces:
Function

public class Npv
extends NumericFunction.MultiArg

Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Minimum 2 arguments, first arg is the rate of discount over the length of one period others up to 254 arguments representing the payments and income.

Author:
SPetrakovsky

Nested Class Summary
 
Nested classes/interfaces inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction
NumericFunction.MultiArg, NumericFunction.OneArg, NumericFunction.TwoArg
 
Field Summary
 
Fields inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction
ABS, ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, CEILING, COMBIN, COS, COSH, DEGREES, DOLLAR, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MOD, POWER, RADIANS, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, TAN, TANH
 
Constructor Summary
Npv()
           
 
Method Summary
protected  double evaluate(double[] ds)
           
 
Methods inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction.MultiArg
eval
 
Methods inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction
evaluate, singleOperandEvaluate
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Npv

public Npv()
Method Detail

evaluate

protected double evaluate(double[] ds)
                   throws EvaluationException
Specified by:
evaluate in class NumericFunction.MultiArg
Throws:
EvaluationException


Copyright 2009 The Apache Software Foundation or its licensors, as applicable.