Using the Excel DDB Function
SummaryThe Excel DDB function uses the double-declining balance method, or some other user specified method, to return the depreciation of an asset for a specified period.
To switch to the straight-line depreciation method when depreciation is greater than the declining balance, use the VDB function.
Syntax=DDB (cost, salvage, life, period, [factor])
Required. Initial cost of the asset.
Required. Salvage value of the asset or the value at the end of the depreciation. This argument will accept 0 (zero) as a value.
Required. The useful life of the asset, or the number of periods over which the asset is being depreciated.
Required. Period for which you want to calculate the depreciation. Must be in the same unit as life.
Optional. Rate at which the balance declines. If omitted, it is assumed to be 2 (the double-declining method).
Usage NotesDDB uses the double-declining balance method to calculate the depreciation of an asset for a given period of time. The double-declining method computes depreciation as an accelerate rate, with depreciation highest in the first period and decreasing each successive period. The following formula is used to compute the depreciation:
=MIN((cost - total prior depreciation) * (factor / life), (cost - salvage, total prior depreciation))
The function defaults to using 2 for the optional factor argument. This can be changed to use some other depreciation method.
Other Depreciation Functions
SYD Function: Sum-of-years depreciation method
DB Function: Fixed-declining balance depreciation method
SLN Function: Straight-line depreciation method
VDB Function: Variable declining balance depreciation method