The 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 |
