CFLib.org – Common Function Library Project

Description:
This function outputs the current value of an item based on straight line depreciation.

Return Values:
Returns a number.

Example:

<cfoutput>
Current Value as of Today: #LSCurrencyFormat((getDepreciatedValue(125000,'9/1/2006', 8)))#
</cfoutput>

Parameters:

Full UDF Source:

<!---
 This function outputs the current value of an item based on straight line depreciation.
 
 @param acq_cost 	 Cost of item. (Required)
 @param act_date 	 Date item acquired. (Required)
 @param numberOfYears 	 Number of years to depreciate the item. (Required)
 @return Returns a number. 
 @author Steve Walker (&#115;&#110;&#101;&#97;&#107;&#121;&#108;&#108;&#97;&#109;&#97;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;) 
 @version 1, June 4, 2008 
--->
<cffunction name="getDepreciatedValue" output="no" returntype="numeric" hint="Calculates the current straight line depreciated value">
	<cfargument name="acq_cost" required="yes" type="numeric" hint="The acquistion cost or value of an item">
	<cfargument name="acq_date" type="date" required="yes" hint="the acquisition date of the item">
	<cfargument name="numberofYears" type="numeric" default="5" required="yes" hint="the number of years to depreciate the item.">
	<cfset var DV = "">
	<cfset var cost = arguments.acq_cost>
	<cfset var days = arguments.numberofYears * 365>
	<cfset var age = dateDiff('d', DateFormat(arguments.acq_date,'mm/dd/yyyy'), DateFormat(Now(),'mm/dd/yyyy'))>
	
	<cfif age gte days>
		<cfset age = days>
	</cfif>
	
	<cfset DV = (cost*((age/days)-1)*-1)>
	
	<cfreturn DV>
</cffunction>