The table below shows the calculation used to depreciate an asset over 5 years.
By default, the VDB function will switch to straight line calculation.
VDB stands for variable…
DB Function
The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The calculation is based on initial asset cost, salvage value, the number of periods over which the asset is depreciated and, optionally, the number of months in the first year.
