SYD function
The SYD function is one of the financial functions. It is used to calculate the depreciation of an asset for a specified accounting period using the sum of the years' digits method.
Syntax
SYD(cost, salvage, life, per)
The SYD function has the following arguments:
| Argument | Description |
|---|---|
| cost | The cost of the asset. |
| salvage | The salvage value of the asset at the end of its lifetime. |
| life | The total number of the periods within the asset lifetime. |
| per | The period you wish to calculate depreciation for. The value must be expressed in the same units as life. |
Notes
How to apply the SYD function.
Examples
The figure below displays the result returned by the SYD function.
