Function Math Financial Class

StraightLineDepreciation

Calculate the straight-line depreciation for an asset for one period. The depreciation amount is the same in all periods through the end of its useful life.

Signature (Visual Basic / VBA)

Public Function StraightLineDepreciation( _
      ByVal vCost As Variant _
    , ByVal vSalvage As Variant _
    , ByVal vLife As Variant _
    ) As Variant

Code Example

    StraightLineDepreciation(2000, 200, 5) = 360

Parameters

Parameter Description
vCost Initial cost of the asset. Function returns Null if vCost is Null 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 or cannot be interpreted as a number.
vLife Length of the asset's useful life. Function returns Null if vLife is Null or cannot be interpreted as a number.

Notes & Version History

Example What is the straight-line depreciation for one 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? $360. See the StraightLineDepreciationVerify Subroutine for more examples of this Function.
v2.0 Addition This function is new to this version of Entisoft Tools.