VDB
Description
Returns the depreciation of an asset, based on the double declining balance method or a different specified method, for a specified period.
Syntax
VDB(
cost
,
salvage
,
life
,
start_period
,
end_period
, [
factor
], [
no_switch
])
- cost: The initial cost of the asset.
- salvage: The value of the asset after depreciation.
- life: The number of periods to depreciate the asset over.
- start_period: The starting period to calculate the depreciation for.
- end_period: The ending period to calculate the depreciation for.
- factor: The rate of decline for the balance. The default is 2.
- no_switch: Specifies whether to switch to straight line depreciation when depreciation is more than the declining balance result. 0 or Empty = switch; 1 = do not switch.