SYD Function |
Yes
SYD(cost, salvage, life, period )
cost
Use: Required
Data Type: Double
The initial cost of the asset.
salvage
Use: Required
Data Type: Double
The value of the asset at the end of its useful life.
life
Use: Required
Data Type: Double
The length of the useful life of the asset.
period
Use: Required
Data Type: Double
The period whose depreciation is to be calculated.
A Double representing depreciation per 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))