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. |