DEPRECIATION_SYD Function
Evaluates depreciation of an asset using the sum-of-years digits method.
Usage
result = DEPRECIATION_SYD (cost, salvage, life, period)
Input Parameters
cost—Initial value of the asset.
salvage—The value of an asset at the end of its depreciation period.
life—Number of periods over which the asset is being depreciated.
period—Period for which the depreciation is to be computed. period cannot be greater than life.
Returned Value
result—The sum-of-years digits depreciation of an asset for a specified period. If no result can be computed, NaN is returned.
Input Keywords
Double—If present and nonzero, double precision is used.
Discussion
Function DEPRECIATION_SYD computes the sum-of-years digits depreciation of an asset for a specified period. It is computed with the following:
Example
In this example, DEPRECIATION_SYD computes the depreciation of an asset, which costs $25,000 initially, lasts 15 years, and a salvage value of $5,000, for the 14th year.
PRINT, DEPRECIATION_SYD(25000, 5000, 15, 14)
; PV-WAVE prints: 333.333
