DACCDB Function

Returns the accumulated declining balance depreciation.

Category: Financial



Required Arguments


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


is numeric, the rate of depreciation expressed as a decimal.

Range r > 0


The DACCDB function returns the accumulated depreciation by using a declining balance method. The formula is
D A C C D B ( p , v , y , r ) = { 0 p 0 v ( 1 - ( 1 - r y ) i n t ( p ) ) ( 1 - ( p - i n t ( p ) ) r y ) p > 0
Note that int(p) is the integer part of p. The p and y arguments must be expressed by using the same units of time. A double-declining balance is obtained by setting r equal to 2.


An asset has a depreciable initial value of $1000 and a fifteen-year lifetime. Using a 200 percent declining balance, the depreciation throughout the first 10 years can be expressed as
The value returned is 760.93. The first and the third arguments are expressed in years.