Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .