Excel functions / Financial
VDB function
Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
Syntax
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Arguments
cost: What the asset cost.salvage: What it is worth at the end.life: How many periods it is used for.start_period: Where the stretch starts, in the same units as life. 0 is the day the asset is bought.end_period: Where the stretch ends.factor(optional): How fast the value falls (default 2: double-declining).no_switch(optional): TRUE never switches to straight-line. Default FALSE.
When to use it
VDB gives declining-balance depreciation between any two points in an asset's life, including part periods, and switches to straight-line once that gives more, as tax rules often require.
Examples
The first year
A B C D E 1 Cost Salvage Life 2 2400 300 10 480 In E2:
=VDB(A2, B2, C2, 0, 1)→ 480From month 6 to month 18, at 1.5 times the straight-line rate
A B C D E 1 Cost Salvage Life 2 2400 300 10 311.81 In E2:
=VDB(A2, B2, C2*12, 6, 18, 1.5)→ 311.81
Common mistakes
- Units. The start and end are in the same units as the life: months if the life is in months.
VDB 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.ZA.INT
- Danish: VSA
- Dutch: VDB
- Finnish: VDB
- French: VDB
- German: VDB
- Hungarian: ÉCSRI
- Italian: AMMORT.VAR
- Norwegian: VERDIAVS
- Polish: VDB
- Portuguese (Brazil): BDV
- Portuguese (Portugal): BDV
- Russian: ПУО
- Spanish: DVS
- Swedish: VDEGRAVSKR
- Turkish: DAB