This function returns the sum-of-years’ digits depreciation of an asset for a specified period.
Syntax
SYD(cost,salvage,life,period)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| cost | Initial cost of the asset |
| salvage | Value at the end of the depreciation |
| life | Number of periods over which the asset is being depreciated |
| period | Period for depreciation; must use the same units as the life argument. |
Remarks
This function calculates the digits depreciation as follows:
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
SYD(B1,1000,10,1)
SYD(R1C2,1000,10,1)
SYD(100000,10000,5,2) gives the result $2,4000
See Also