Excel functions / Financial
DB function
Depreciation for one period, losing the same percentage of the remaining value each period.
Syntax
=DB(cost, salvage, life, period, [month])
Arguments
cost: What the asset cost.salvage: What it is worth at the end.life: How many periods it is used for.period: Which period to get the depreciation for.month(optional): Months in the first year (default 12).
When to use it
DB gives depreciation by the fixed-declining-balance method: the same percentage of the remaining value each year, so the amounts fall over time. A fifth argument says how many months the asset was owned in the first year.
Examples
The first year, bought in June
A B C D E 1 Cost Salvage Life 2 1000000 100000 6 186083.33 In E2:
=DB(A2, B2, C2, 1, 7)→ 186083.33The second year
A B C D E 1 Cost Salvage Life 2 1000000 100000 6 259639.42 In E2:
=DB(A2, B2, C2, 2, 7)→ 259639.42
Common mistakes
- The month argument. Left out, DB assumes a full first year (12 months).
DB in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ODPIS.ZRYCH
- Danish: DB
- Dutch: DB
- Finnish: DB
- French: DB
- German: GDA2
- Hungarian: KCS2
- Italian: AMMORT.FISSO
- Norwegian: DAVSKR
- Polish: DB
- Portuguese (Brazil): BD
- Portuguese (Portugal): BD
- Russian: ФУО
- Spanish: DB
- Swedish: DB
- Turkish: AZALANBAKİYE
Related functions
- DDB: Depreciation for one period at double the straight-line rate (or another multiple).
- SLN: Straight-line depreciation: the same loss of value every year.
- SYD: Sum-of-years’ digits depreciation: more in the early periods, less in the late ones.
- VDB: Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.