DDB
Returns the double declining balance depreciation of an asset for a given period.
DDB(<cost>, <salvage>, <life>, <period> [, <factor>])Returns: A number. Each period charges a fixed share of the remaining book value, which is twice the straight-line rate by default.
What it does
DDB is the most aggressive of the common accelerated methods. It charges a share of the remaining book value each period, and that share is twice the straight-line rate unless a different factor is given. The asset's value falls fast at first, and the charge is never allowed to take the book value below the salvage value. Finance teams use it for assets that lose value quickly, such as computers and vehicles, and where a policy or tax plan calls for early charges.
Syntax and arguments
- cost: the original cost of the asset. Required.
- salvage: the value at the end of the useful life. The book value is never reduced below this amount. Required.
- life: the number of periods in the useful life. Required.
- period: the period to calculate, from 1 to life. Required.
- factor: the rate multiplier. Optional, and 2 is the default, which gives double declining balance. Use 1.5 for a 150 percent declining balance method.
Example
The same equipment (cost 120,000, salvage 10,000, life 5 years). The controller wants the charge for each of the first two years.
Depreciation Year 1 = DDB(120000, 10000, 5, 1)
Depreciation Year 2 = DDB(120000, 10000, 5, 2)
The year 1 charge is 2 divided by 5, which is 40 percent of 120,000, so it is 48,000.00. The year 2 charge is 40 percent of the remaining 72,000, which is 28,800.00.
Example: a second, different use
The full five-year schedule for the same asset. DDB stops the charge in year 5 so that the book value does not drop below the salvage value of 10,000.
Depreciation Year 5 = DDB(120000, 10000, 5, 5)
The result is 5,552.00, not the 6,220.80 a plain 40 percent charge would give. The year 4 book value is 15,552.00, and a full 40 percent charge would take it to 9,331.20, below the salvage value.
Things to watch
- DDB does not reduce book value below salvage. Check the last years of the schedule, where the charge is cut back.
- The charge is highest in year 1 and falls each year, so DDB and SYD both front-load the expense, but DDB falls faster.
- Use the factor argument only when a policy or tax rule specifies it. The default is 2.
- A total of the periods adds up to cost minus salvage, which is a useful check.
In business terms
DDB supports depreciation for technology and vehicles, accelerated book and tax schedules, and the early-year expense that affects reported profit in the first years of an asset. Controllers compare DDB with SLN to show the effect of the method choice on each year's profit.