CFLib.org – Common Function Library Project

FutureValue(IT, PMT, PV, NP)

Last updated August 2, 2001

author

Raymond Thompson

Version: 1 | Requires: CF5 | Library: FinancialLib

Description:
Calculate the future value of investment with regular deposits.

Return Values:
Returns a numeric value.

Example:

Future Value = <cfoutput>#FutureValue(0.08,500,0,24)#</cfoutput>

Parameters:

Name Description Required
IT Interest rate per year (8% = 0.08) Yes
PMT Number of payments. Yes
PV Present value. Yes
NP Number of periods. Yes

Full UDF Source:

/**
 * Calculate the future value of investment with regular deposits.
 * 
 * @param IT 	 Interest rate per year (8% = 0.08) 
 * @param PMT 	 Number of payments. 
 * @param PV 	 Present value. 
 * @param NP 	 Number of periods. 
 * @return Returns a numeric value. 
 * @author Raymond Thompson (rayt@qsystems.net) 
 * @version 1, April 23, 2002 
 */
function FutureValue(IR,PMT,PV,NP) {
  var tpv = abs(pv);
  var tnp = abs(np);
  var fv = pv;
  var tpmt = -abs(pmt);
  var tir = abs(ir) / 12;
  var scale=0;

  if(ArrayLen(Arguments) gt 4) {
    scale = 10^abs(Arguments[4]);
  }
  if (ir eq 0) {
    fv = tpv + abs(tpmt * tnp);
  } else {
    q = (1 + tir)^tnp;
    fv = (-pmt + q * pmt + tir * q * tpv) / tir;
  }
  if (scale NEQ 0) {
    fv = int(fv * scale + 0.5) / scale;
  }
  return(-fv);
}
blog comments powered by Disqus

Search CFLib.org


Latest Additions

Kevin Cotton added
date2ExcelDate
May 5, 2016

Raymond Camden added
CapFirst
April 25, 2016

Chris Wigginton added
loremIpsum
January 18, 2016

Gary Stanton added
calculateArrival...
November 19, 2015

Sebastiaan Naafs - van Dijk added
getDaysInQuarter
November 13, 2015

Created by Raymond Camden / Design by Justin Johnson