SYD
Returns the sum-of-years' digits depreciation of an asset for a specified period
Syntax
SYD(cost, salvage, life, per)
Parameters
- cost: Required. The initial cost of the asset
- salvage: Required. The value at the end of the depreciation
- life: Required. The number of periods over which the asset is depreciated
- per: Required. The period
Example
=SYD(30000, 7500, 10, 1)