Calculate depreciation using variable declining balance method.

Syntax of Excel VDB formula:

In words:
=Calculate depreciation of asset with(this cost, having expected residual value, starting from this period, and ending at this period, with this coefficient factor, [with this value of switch])

Examples of Excel VDB Formula

Have a look at following data:

excel vdb

Putting this formula in cell B9:

=VDB(B1,B2,B3,B4,B5,B6,B7) will give depreciation of $9444.44