DEPSL Function

Returns the straight-line depreciation.

Category: Financial



Required Arguments


is numeric, the period for which the calculation is to be done. For fractional p, 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.

Range y > 0


The DEPSL function returns the straight-line depreciation, which is given by
D E P S L ( p , v , y ) = D A C C S L ( p , v , y ) - D A C C S L ( p - 1 , v , y )
The p and y arguments must be expressed by using the same units of time.


An asset, acquired on 01APR86, has a depreciable initial value of $1,000 and a ten-year lifetime. The depreciation in the value of the asset for the year 1986 can be expressed as
The value returned is 75.00. The first and the third arguments are expressed in years.