Returns the sum-of-years'-digits depreciation of an asset for the specified period.
Syntax
 Copy Code
|
|---|
SYD( Number cost, Number salvage, Number life, Number period ) → Currency |
Parameters
- cost
- Required. The initial cost of the asset.
- salvage
- Required. The value at the end of the depreciation (also known as the salvage value).
- life
- Required. The number of periods over which the asset is being depreciated.
- period
- Required. The period; it must use the same units as life.
Remarks
SYD is calculated as follows: SYD = (cost - salvage) * (life - per + 1) * 2 / (life * (life + 1)).
If life is zero, the function returns the #DIV/0! error value. If life is less than zero or period is greater than life, the return is #NUM!.
Example
| Formula
Copy Code
|
|---|
=SYD(10000,1500,10,1) |
See Also
Function Reference
DDB Function
SLN Function