Practice free

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.

Practice this in the app

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.

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