Description
Calculate the sum-of-years' digits depreciation of an asset for a specified period.
Signature
Depreciation_SYD('cost', 'salvage', 'life', 'period')
Parameters
| Name | Required | Type | Description |
|---|---|---|---|
| cost | Yes | double | The initial cost of the asset. |
| salvage | Yes | double | The value of the asset at the end of the depreciation |
| life | Yes | double | The number of periods over which the asset is depreciated |
| period | Yes | double | The period and must use the same units as life. |
Example 1
Depreciation_SYD(1000,200,5,1) Returns 266.66