Public Function DoubleDecliningBalanceDepreciation( _
ByVal vCost As Variant _
, ByVal vSalvage As Variant _
, ByVal vLife As Variant _
, ByVal vPeriod As Variant _
, Optional ByVal vFactor As Variant _
) As Variant
Calculate the double-declining balance depreciation (or depreciation using a similar method) for an asset for a specific period. Example: What is the double-declining balance depreciation for the third year of an asset that costs $2,000, has a useful life of 5 years, and has a value of $200 at the end of those five years? $288.
DoubleDecliningBalanceDepreciation(2000, 200, 5, 3) = 288See the DoubleDecliningBalanceDepreciationVerify Subroutine for more examples of this Function.
DDB Function (Visual Basic)
DDB Function (Microsoft Excel)vCost: Initial cost of the asset. Function returns Null if vCost is Null, less than zero (<0), or cannot be interpreted as a number.
vSalvage: Value of the asset at the end of its useful life. Function returns Null if vSalvage is Null, less than zero (<0), or cannot be interpreted as a number.
vLife: Length of the asset's useful life. Function returns Null if vLife is Null, less than zero (<0), or cannot be interpreted as a number.
vPeriod: Period for which the depreciation is calculated. Function returns Null if vPeriod is Null, less than zero (<0), greater than vLife, or cannot be interpreted as a number.
Note: vPeriod is rounded to the nearest integer, unlike the treatment of vPeriod in the Visual Basic and Excel DDB functions.
vFactor: Optional rate at which the balance declines. vFactor defaults to 2 (meaning double-declining balance) if it is missing or Null or cannot be interpreted as a number. Function returns Null if vFactor is less than zero (<0).
Corresponding Units: The vLife and vPeriod arguments must be expressed in corresponding units. If the useful life (vLife) is expressed in months, then the depreciation period (vPeriod) must also be expressed in months.
v2.0 Addition: This function is new to this version of Entisoft Tools.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.