DB
Returns the fixed-rate declining balance depreciation of an asset for a given period.
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
- cost: the original cost of the asset. Required.
- salvage: the value at the end of the useful life. Required.
- life: the number of periods in the useful life. Required.
- period: the period to calculate, from 1 to life plus 1 if the first year is partial. Required.
- month: the number of months the asset is in use in the first year. Optional, and 12 is the default. For an asset put in service on July 1, use 6.
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
- DB compared with DDB: DB uses a fixed rate that is lower than double the straight-line rate, so it charges less than DDB in the first year. DDB uses a rate that is twice the straight-line rate.
- Check the last period of the schedule against the salvage value in your model, so that book value does not fall below it.
- With a partial first year, the schedule runs one period longer than the life. Plan the period numbers with that in mind.
- Check the result against a spreadsheet for the same inputs before publishing, because rounding of the rate is a common source of small differences.
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.