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