Downloads
DAXFinancialIntermediate

DDB

Returns the double declining balance depreciation of an asset for a given period.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals