Class Microsoft.VisualBasic.Financial Syntax Dim result As Double = SYD(cost, salvage, life, period) cost (required; Double) The initial cost of the asset salvage (required; Double) The value of the asset at the end of its useful life life (required; Double) The length of the useful life of the asset period (required; Double) The period whose depreciation is to be calculated
Description The SYD function computes the sum-of-years' digits depreciation of an asset for a specified period. The sum-of-years' digits method allocates a larger amount of the depreciation in the earlier years of the asset. Usage at a Glance life and period must be expressed in the same time unit. For example, if life represents the life of the asset in years, period must be a particular year for which the depreciation amount is to be computed. All arguments must be positive numeric values. To calculate the depreciation for a given period, SYD uses the formula: (Cost-Salvage)*((Life-Period + 1)/(Life*(Life + 1)/2))
See Also DDB Function, SLN Function |