Was this helpful?
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)
Argument
Data Type
Description
cost
Float
Original cost of the asset
salvage
Float
Asset salvage value at end of life
life
Integer
Life of asset (number of periods)
period
Integer
Specific period
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);
Last modified date: 12/20/2023