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

java.lang.Object
  org.apache.poi.hssf.record.formula.functions.NumericFunction
      org.apache.poi.hssf.record.formula.functions.FinanceFunction
          org.apache.poi.hssf.record.formula.functions.Pmt

All Implemented Interfaces:

Function

public final class Pmt
extends FinanceFunction

Implementation for the PMT() Excel function.

Syntax:
PMT(rate, nper, pv, fv, type)

Returns the constant repayment amount required for a loan assuming a constant interest rate.

rate the loan interest rate.
nper the number of loan repayments.
pv the present value of the future payments (or principle).
fv the future value (default zero) surplus cash at the end of the loan lifetime.
type whether payments are due at the beginning(1) or end(0 - default) of each payment period.

Field Summary

Fields inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction

E, PI

Constructor Summary

Pmt()

Method Summary

Eval	evaluate(Eval[] args, int srcRow, short srcCol)

Methods inherited from class org.apache.poi.hssf.record.formula.functions.FinanceFunction

getXlator, singleOperandNumericAsBoolean

Methods inherited from class org.apache.poi.hssf.record.formula.functions.NumericFunction

singleOperandEvaluate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Pmt

public Pmt()

Method Detail

evaluate

public Eval evaluate(Eval[] args,
                     int srcRow,
                     short srcCol)