VDB
Calculate depreciation using variable declining balance method.
Syntax of Excel VDB formula:
=VDB(cost,salvage,life,start_period,end_period,[factor],[no_switch])
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:
Putting this formula in cell B9:
=VDB(B1,B2,B3,B4,B5,B6,B7) will give depreciation of $9444.44