DEPSYD Function

Returns the sum-of-years-digits depreciation.

Category: Financial



Required Arguments


is numeric, the period for which the calculation is to be done. For noninteger p arguments, the depreciation is prorated between the two consecutive time periods that precede and follow the fractional period.


is numeric, the depreciable initial value of the asset.


is numeric, the lifetime of the asset in number of depreciation periods.

Range y > 0


The DEPSYD function returns the sum-of-years-digits depreciation, which is given by
D E P S Y D ( p , v , y ) = D A C C S Y D ( p , v , y ) - D A C C S Y D ( p - 1 , v , y )
The p and y arguments must be expressed by using the same units of time.


An asset, acquired on 01OCT86, has a depreciable initial value of $1,000 and a five-year lifetime. The depreciations in the value of the asset for the years 1986 and 1987 can be expressed as
The values returned are 83.33 and 316.67, respectively. The first and the third arguments are expressed in years.