VDB function
VDB returns variable declining balance depreciation across a span of periods you choose. It can cover partial periods and switch to straight-line when that gives a bigger deduction.
Example
Read it as a sentence: find the depreciation from the start up to period 2 on a $10,000 asset with a $1,000 salvage value over 5 periods, which gives 6400.
A
B
C
D
1
6400
2
3
Syntax
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
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 of use.
-
start_period(required) - Start of the span, counting from 0.
-
end_period(required) - End of the span.
-
factor(optional) - Declining-balance multiplier; 2 if omitted.
-
no_switch(optional) - TRUE stops it moving to straight-line; FALSE (default) allows the switch.
Returns: Depreciation across a chosen span of periods.
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 |
|---|---|---|
=VDB(2400,300,10,0,1) | $480.00 | Period 0-1 |
=VDB(2400,300,10,0.5,1.5) | $432.00 | Partial periods |
=VDB(2400,300,10,6,10,2,TRUE) | $329.15 | no_switch TRUE |
=VDB(2400,300,10,6,10,2,FALSE) | $329.15 | no_switch FALSE |
=VDB(2400,300,10,0,1,0) | $210.00 | Factor 0 |
=VDB(1000,2000,5,0,1) | ($1,000.00) | Salvage > cost |
=VDB(2400,300,10,2,1) | #NUM! | Start > end |
=VDB(2400,300,10,0,11) | #NUM! | End > life |
Watch out for
- Periods run from 0, so start 0 to end 1 is the first period.
- Unlike DDB, it can switch to straight-line automatically.
Where it works
- Excel
- VDB 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 .