VDB functionThe VDB function returns the depreciation of an asset for a particular period (or partial period).
Parts of a VDB function
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Part
Description
cost
Initial cost of the asset.
salvage
Value of the asset at the end of depreciation (salvage value).
life
Number of periods of depreciation (useful life of the asset).
start_period
Starting period to calculate depreciation.
end_period
Ending period to calculate depreciation.
factor
[OPTIONAL] – Rate of balance decline (the default is 2: the double-declining balance method).
no_switch
[OPTIONAL] – Whether to switch to straight-line depreciation when the depreciation is greater than the declining balance calculation.
Examples
A
B
1
Formula
Result
2
=VDB(100, 10, 20, 10, 11, 2, TRUE)
$3.49
3
=VDB(100, 33, 20, 10, 11, 2, FALSE)
$1.87
Related functions
DB: The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
DDB: The DDB function calculates the depreciation of an asset for a specified period using the double-declining balance method.