Returns the accumulated straight-line depreciation
Category: Financial
DACCSL ( p,v,y )
p
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.
v
is numeric, the depreciable initial value of the asset.
y
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
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
a=daccsl(1.75,1000,10);
The value returned is 175.00. The first and the third arguments are expressed in years .