DEPSYD Function

Returns the sum-of-years-digits depreciation.

Category:

Financial

Syntax

DEPSYD(p,v,y)

Required Arguments

p

is numeric, the period for which the calculation is to be done. For noninteger p arguments, 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 in number of depreciation periods.

Range

y > 0

Details

The DEPSYD function returns the sum-of-years-digits depreciation, which is given by

\begin{matrix} D E P S Y D (p, v, y) & = D A C C S Y D (p, v, y) \\ - D A C C S Y D (p - 1, v, y) \end{matrix}

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

Example

An asset, acquired on 01OCT86, has a depreciable initial value of $1,000 and a five-year lifetime. The depreciations in the value of the asset for the years 1986 and 1987 can be expressed as

   y1=depsyd(3/12,1000,5);
   y2=depsyd(15/12,1000,5);

The values returned are 83.33 and 316.67, respectively. The first and the third arguments are expressed in years.