Returns the declining balance with conversion to a straight-line depreciation.

Category: | Financial |

The DEPDBSL function
returns the depreciation by using the declining balance method with
conversion to a straight-line depreciation, which is given by the
following equation:

$\begin{array}{c}DEPDBSL(p,v,y,r)=\{\begin{array}{cc}0\hfill & p\le 0\hfill \\ v\frac{r}{y}{(1-\frac{r}{y})}^{p-1}\hfill & 0<p\le t\hfill \\ \frac{v(1-\frac{r}{y})\begin{array}{c}t\hfill \\ \phantom{\rule{0.212em}{0ex}}\hfill \end{array}}{(y-t)}\hfill & t<p\le y\hfill \\ 0\hfill & p>y\hfill \end{array}\hfill \end{array}$

Copyright © SAS Institute Inc. All rights reserved.