DB function
DB returns an asset's depreciation for one period using the fixed-declining-balance method. It applies a constant rate to the remaining book value, so deductions are larger in the early periods.
Example
Read it as a sentence: for an asset that cost $10,000 and is worth $1,000 after 5 years, find the declining-balance depreciation for year 1.
A
B
C
D
1
3690
2
3
Syntax
DB(cost, salvage, life, period, [month])
Arguments in [square brackets] are optional.
-
cost(required) - Initial cost of the asset.
-
salvage(required) - Value at the end of its life.
-
life(required) - Number of periods the asset is depreciated over.
-
period(required) - Period to calculate, in the same unit as life.
-
month(optional) - Months in the first year; defaults to 12.
Returns: Depreciation for one period using the fixed-declining-balance method.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DB(1000000,100000,6,1) | $319,000.00 | Year 1 |
=DB(1000000,100000,6,1,7) | $186,083.33 | First-year month 7 |
=DB(1000000,100000,6,7,7) | $15,845.10 | Year 7 (life+1) with month 7 |
=DB(1000,0,5,1) | $1,000.00 | Salvage 0 |
=DB(1000,2000,5,1) | ($149.00) | Salvage > cost |
=DB(1000,100,5,1.5) | $369.00 | Fractional period |
=DB(1000000,100000,6,7) | #NUM! | Year 7 without month |
=DB(1000000,100000,6,1,0) | #NUM! | Month 0 |
Watch out for
- Excel rounds the internal rate to three decimals, so results differ slightly from an exact calculation.
- If month is under 12, an extra final period is needed.
Where it works
- Excel
- DB is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .