Signature (Visual Basic / VBA)
Public Function SumOfYearsDigitsDepreciation( _
ByVal vCost As Variant _
, ByVal vSalvage As Variant _
, ByVal vLife As Variant _
, ByVal vPeriod As Variant _
) As Variant
Code Example
SumOfYearsDigitsDepreciation(2000, 200, 5, 2) = 480
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. |
| vPeriod | Period for which the depreciation is calculated. Function returns Null if vPeriod is Null or cannot be interpreted as a number. 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. |
Notes & Version History
| Example | What is the sum-of-years' digits depreciation for the second 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? $480. See the SumOfYearsDigitsDepreciationVerify Subroutine for more examples of this Function. |
| v2.0 Addition | This function is new to this version of Entisoft Tools. |