DEPDB Function

Returns the 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 that is expressed as a fraction.

Range r ≥ 0


The DEPDB function returns the depreciation by using the declining balance method, which is given by
D E P D B ( p , v , y , r ) = D A C C D B ( p , v , y , r ) - D A C C D B ( p - 1 , v , y , r )
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 an initial value of $1,000 and a fifteen-year lifetime. Using a declining balance rate of 200%, the depreciation of the value of the asset for the tenth year can be expressed as
The value returned is 36.78. The first and the third arguments are expressed in years.