DEPSL Function

Returns the straight-line depreciation.

Category: Financial

Syntax

DEPSL(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 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.

Example

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
   d=depsl(9/12,1000,10);
The value returned is 75.00. The first and the third arguments are expressed in years.