SYD
This method specifies the sum-of-years digits depreciation of an asset for a specified period.
Syntax
financial.SYD(cost, salvage, life, period)
Parameters
- financial
- Required. Reference to a Financial control.
- cost
- Required. Variant that specifies the initial cost of the asset.
- salvage
- Required. Variant that specifies the value of the asset at the end of its useful life.
- life
- Required. Variant that specifies the length of the useful life of the asset.
- period
- Required. Variant that specifies the period for which asset depreciation is calculated.
Return Value
Result of the SYD calculation.
Remarks
The life and period parameters must be expressed in the same units. For example, if life is given in months, period must also be given in months. All parameters must be positive numbers.