SYD Function
Microsoft.VisualBasic.Financial
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
A Double giving the sum-of-years depreciation of an asset for a given period
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.
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))
No credit card required