DACCSL Function

Returns the accumulated 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 DACCSL function returns the accumulated depreciation by using the straight-line method, which is given by
D A C C S L ( p , v , y ) = { 0 p < 0 v ( p y ) 0 p y v p > 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 $1000 and a ten-year lifetime. The accumulated depreciation in the value of the asset through 31DEC87 can be expressed as
The value returned is 175.00. The first and the third arguments are expressed in years.