SYD Function Explained
The SYD Function in Microsoft Excel is used to calculate the sum-of-years’ digits depreciation of an asset for a specified period. It takes three arguments: cost, salvage, and life. The cost is the initial cost of the asset, the salvage is the value of the asset at the end of its useful life, and the life is the number of periods over which the asset is being depreciated. The function returns the depreciation amount for a specified period.
SYD Function Syntax
SYD(cost, salvage, life, period, [month])
- cost: The initial cost of the asset.
- salvage: The value of the asset at the end of its useful life.
- life: The number of periods over which the asset is being depreciated.
- period: The period for which you want to calculate the depreciation.
- [month]: (Optional) The number of months in the first year. If omitted, SYD uses 12.