Downloads
DAXFinancialIntermediate

DB

Returns the fixed-rate declining balance depreciation of an asset for a given period.

Syntax
DB(<cost>, <salvage>, <life>, <period> [, <month>])

Returns: A number. Each period charges a fixed percentage of the remaining book value, so the charge falls every year.

What it does

DB applies a fixed percentage to the asset's remaining book value each period. The rate is worked out from the cost, the salvage value and the life, so that the asset reaches its salvage value at the end of its life. The first year is the largest charge, and each later year takes a smaller amount. Finance teams use it for accelerated depreciation schedules, for equipment that loses most of its value early, and for comparing methods in a policy review.

Syntax and arguments

Example

The same equipment as before (cost 120,000, salvage 10,000, life 5 years), with a full first year.

Depreciation Year 1 = DB(120000, 10000, 5, 1)

Depreciation Year 2 = DB(120000, 10000, 5, 2)

For these figures, the fixed rate is 0.392, which is 1 minus the fifth root of 10,000 divided by 120,000, rounded to three decimal places. The year 1 charge is 120,000 times 0.392, which is 47,040.00. The year 2 charge is the remaining book value of 72,960 times 0.392, which is 28,600.32.

Example: a second, different use

An asset put into service on July 1, so the first year has six months. The month argument shows the partial first year.

Depreciation Year 1 (July start) = DB(120000, 10000, 5, 1, 6)

For these figures, the first year charge is the full-year charge of 47,040.00 scaled by 6 divided by 12, which is 23,520.00. The schedule then runs one period longer than the life, with the last part of the depreciation falling in the sixth year.

Things to watch

In business terms

DB supports accelerated depreciation schedules for equipment and vehicles, the book depreciation for fixed asset registers, the comparison of methods for a policy decision and the depreciation forecast in a budget. It shows how much value the asset loses early in its life.

Related functions

All DAX functions · View as Markdown · DAX fundamentals