File	Doc	Category	Size	Date	Package
FinanceLib.java	API Doc	Apache Poi 3.0.1	5973	Sun Mar 11 12:59:30 GMT 2007	org.apache.poi.hssf.record.formula.functions

FinanceLib

• java.lang.Object

Fields Summary

Constructors Summary
private FinanceLib()

Methods Summary
public static double	fv(double r, double n, double y, double p, boolean t) Future value of an amount given the number of payments, rate, amount of individual payment, present value and boolean value indicating whether payments are due at the beginning of period (false => payments are due at end of period) param r rate param n num of periods param y pmt per period param f future value param t type (true=pmt at end of period, false=pmt at begining of period) return double retval = 0; if (r == 0) { retval = -1*(p+(n*y)); } else { double r1 = r + 1; retval =((1-Math.pow(r1, n)) * (t ? r1 : 1) * y ) / r - p*Math.pow(r1, n); } return retval;
public static double	nper(double r, double y, double p, double f, boolean t) param r param n param p param f param t return double retval = 0; if (r == 0) { retval = -1 * (f + p) / y; } else { double r1 = r + 1; double ryr = (t ? r1 : 1) * y / r; double a1 = ((ryr - f) < 0) ? Math.log(f - ryr) : Math.log(ryr - f); double a2 = ((ryr - f) < 0) ? Math.log(-p - ryr) : Math.log(p + ryr); double a3 = Math.log(r1); retval = (a1 - a2) / a3; } return retval;
public static double	npv(double r, double[] cfs) calculates the Net Present Value of a principal amount given the discount rate and a sequence of cash flows (supplied as an array). If the amounts are income the value should be positive, else if they are payments and not income, the value should be negative. param r param cfs cashflow amounts return double npv = 0; double r1 = r + 1; double trate = r1; for (int i=0, iSize=cfs.length; i<iSize; i++) { npv += cfs[i] / trate; trate *= r1; } return npv;
public static double	pmt(double r, double n, double p, double f, boolean t) param r param n param p param f param t return double retval = 0; if (r == 0) { retval = -1*(f+p)/n; } else { double r1 = r + 1; retval = ( f + p * Math.pow(r1, n) ) * r / ((t ? r1 : 1) * (1 - Math.pow(r1, n))); } return retval;
public static double	pv(double r, double n, double y, double f, boolean t) Present value of an amount given the number of future payments, rate, amount of individual payment, future value and boolean value indicating whether payments are due at the beginning of period (false => payments are due at end of period) param r param n param y param f param t return double retval = 0; if (r == 0) { retval = -1*((n*y)+f); } else { double r1 = r + 1; retval =(( ( 1 - Math.pow(r1, n) ) / r ) * (t ? r1 : 1) * y - f) / Math.pow(r1, n); } return retval;