Excel functions / Financial
DDB function
Depreciation for one period at double the straight-line rate (or another multiple).
Syntax
=DDB(cost, salvage, life, period, [factor])
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.factor(optional): How fast the value falls (default 2: double-declining).
When to use it
DDB gives depreciation by the double-declining-balance method: twice the straight-line rate, applied to what is left each period. It writes an asset down fastest at the start. A fifth argument changes the factor from 2.
Examples
The first year
A B C D E 1 Cost Salvage Life 2 2400 300 10 480 In E2:
=DDB(A2, B2, C2, 1)→ 480The first day, counting the life in days
A B C D E 1 Cost Salvage Life 2 2400 300 10 1.32 In E2:
=DDB(A2, B2, C2*365, 1)→ 1.32
Common mistakes
- Switching to straight line. DDB never switches to straight-line depreciation when that would give more. VDB does.
DDB 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.ZRYCH2
- Danish: DSA
- Dutch: DDB
- Finnish: DDB
- French: DDB
- German: GDA
- Hungarian: KCSA
- Italian: AMMORT
- Norwegian: DEGRAVS
- Polish: DDB
- Portuguese (Brazil): BDD
- Portuguese (Portugal): BDD
- Russian: ДДОБ
- Spanish: DDB
- Swedish: DEGAVSKR
- Turkish: ÇİFTAZALANBAKİYE
Related functions
- VDB: Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
- DB: Depreciation for one period, losing the same percentage of the remaining value each period.
- 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.