DACCSL Function

Returns the accumulated straight-line depreciation.

Category:

Financial

Syntax

DACCSL(p,v,y)

Required Arguments

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

Details

The DACCSL function returns the accumulated depreciation by using the straight-line method, which is given by

\begin{matrix} D A C C S L (p, v, y) = {\begin{matrix} 0 & p < 0 \\ v (\frac{p}{y}) & 0 \leq p \leq y \\ v & p > y \end{matrix} \end{matrix}

The p and y arguments must be expressed by using the same units of time.

Example

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.