|
VDB |
  
|
|
VDB |
|
This function returns the depreciation of an asset for any period you specify using the variable declining balance method.
Syntax
VDB(cost,salvage,life,start,end,factor,switchnot)
Arguments
This function has these arguments:
Argument |
Description |
cost |
Initial cost of the asset |
salvage |
Value at the end of the depreciation period |
life |
Number of periods over which the asset is being depreciated |
start |
Number representing the starting period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated |
end |
Number representing the ending period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated |
factor |
[Optional] Rate at which the balance declines; if omitted, uses two (2) |
switchnot |
[Optional] Logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation; if omitted uses FALSE |
Remarks
If factor is omitted, the calculation uses two, which represents the double‑declining balance method. For other methods, use a different value. For more information about the double‑declining balance method, see DDB.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
VDBD(B1,1000,10,1,8)
VDB(50000,500,1200,100,1000,1) gives the result $37,122.94
See Also