6. Functions : Finance Library Functions : SYD Function
 
Share this page                  
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