The Excel SYD function returns the “sum-of-years” depreciation for an asset in a given period. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
Syntax:= SYD (cost, salvage, life, period)
The SYD function syntax has the following arguments:
- Cost Required. The initial cost of the asset.
- Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
- Life Required. The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
-
Per Required. The period and must use the same units as life.
Example: Let’s look at some Excel SYD function examples and explore how to use the SYD function as a worksheet function in Microsoft Excel:
In the example below, the SYD function uses the sum-of-years’ digits depreciation method to calculate the yearly depreciation of an asset that costs $100,000 at the start of year 1, and has a salvage value of $21,000 after 20 years.
Syntax: =SYD(B1,B2,B3,1)
Result:
Based on the Excel spreadsheet above, the following SYD examples would return:
Syntax: =SYD(B1,B2,B3,2)
Result: $7,147.62
Syntax: =SYD(B1,B2,B3,3)
Result: $6,771.43
Syntax: =SYD(B1,B2,B3,4)
Result: $6,395.24
Syntax: =SYD(B1,B2,B3,5)
Result: $6,019.05
Syntax: =SYD(B1,B2,B3,6)
Result: $5,642.86
Syntax: =SYD(B1,B2,B3,7)
Result: $5,266.67
Syntax: =SYD(B1,B2,B3,8)
Result: $4,890.48
Syntax: =SYD(B1,B2,B3,9)
Result: $4,514.29
Syntax: =SYD(B1,B2,B3,10)
Result: $4,138.10
Note:
- We need to provide the arguments life and per in the same units of time: days, months, or years.
- #VALUE! error – Occurs when the given arguments are non-numeric.
- #NUM! error – Occurs when:
- The salvage argument provided is less than zero.
- The life or per argument given is less than or equal to zero.
- The per argument provided is greater than the life argument provided in the formula.
- SYD is calculated as follows:
