Returns the accumulated sum-of-years-digits depreciation.

Category: | Financial |

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.

is numeric, the depreciable initial value of the asset.

is numeric, the lifetime of the asset.

Range | y > 0 |

The DACCSYD
function returns the accumulated depreciation by using the sum-of-years-digits
method. The formula is

$\begin{array}{c}DACCSYD(p,v,y)=\{\begin{array}{cc}0\hfill & p<0\hfill \\ v\frac{int\left(p\right)(y-\frac{int\left(p\right)-1}{2})+(p-int\left(p\right))(y-int\left(p\right))}{int\left(y\right)(y-\frac{int\left(y\right)-1}{2})+{(y-int\left(y\right))}^{2}}\hfill & 0\le p\le y\hfill \\ v\hfill & p>y\hfill \end{array}\hfill \end{array}$

Copyright © SAS Institute Inc. All rights reserved.