VDB

Try it

When to use it

When should I use VDB?

Use VDB to calculate depreciation over any partial or full period using a variable declining-balance method — more flexible than DB or DDB because it can span fractional periods and optionally switch to straight-line when that yields a higher deduction.

Used in

finance

Syntax

VDB(cost, salvage, life, start, end, [factor], [no_switch])

Examples

=VDB(100,10,20,10,11,2,TRUE) // => 3.4867844010000013
=VDB(100,33,20,10,11,2,FALSE) // => 1.867844010000013