VDB
Category: Financial Function.
Description: Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.
Syntax: VDB(cost, salvage, life, start_period, end_period, factor, no_switch)
The VDB function syntax has the following arguments:
Cost: initial cost of the asset.
Salvage: value at the end of the depreciation.
Life: number of periods over which the asset is depreciated.
Start_period: starting period for which you want to calculate the depreciation. Must have the same units as life.
End_period: ending period for which you want to calculate the depreciation. Must have the same unit as life.
Factor: rate at which the balance declines. If omitted, it is assumed to be 2.
No_switch: a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.