Excel - Microsoft Excel SYD Function

Description

The Excel SYD function calculates the sum-of-years' digits depreciation for a specified period in the lifetime of an asset. 

The format of the function is : 

SYD( cost, salvage, life, per ) 

where the arguments are as shown in the table below: 

In the example below, the SYD function uses the sum-of-years' digits depreciation method to calculate the yearly depreciation of an asset that cost $10,000 at the start of year 1, and has a salvage value of $1,000 after 5 years. 

SYD Function Errors

If you get an error from the Excel SYD Function, this is likely to be one of the following : 

Common Errors