SYD Function
The SYD function calculates the sum-of-year's digits depreciation for a specified period in the life of an asset that was purchased at cost and that has an estimated salvage value.
This function has the following syntax:
SYD(cost = value, salvage = value, life = value, period = value)
This function returns:
• Float—Sum of the years digits depreciation
• Null—On error
Example—SYD function:
/* Compute the sum of years digits depreciation for
** the third year in the life of an asset with an
** initial cost of $5,000, a life of five years, and
** a salvage value of $1,000.
*/
dep = syd(cost = 5000, salvage = 1000, life = 5, period = 3);