CFLib.org – FutureValue

FutureValue(IT, PMT, PV, NP)

Last updated August 2, 2001

Download UDF

author

Raymond Thompson
Send Email

Version: 1 | Requires: ColdFusion 5 | Library: FinancialLib

Rated 0 time(s). Average Rating: 0

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

Return Values:
Returns a numeric value.

Example:

view plain print about

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

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:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<cfscript>
/**
 * 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 (&#114;&#97;&#121;&#116;&#64;&#113;&#115;&#121;&#115;&#116;&#101;&#109;&#115;&#46;&#110;&#101;&#116;) 
 * @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);
}
</cfscript>
		<cfscript>
/**
 * 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);
}
</cfscript>