Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Calculate depreciation using variable declining balance method.
Syntax of Excel VDB formula:
=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])
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