|
SYD |
  
|
|
SYD |
|
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