VDB
Name
Variable depreciation
Description
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 )
Remarks
This function has the following 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 |
If factor is omitted, the calculation uses two, which represents the double-declining balance method. For other methods, use a different value.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
VDB(B1,100,10,1,8)
VDB(50000,500,1200,100,1000,1)=37122.94