VDB
Returns the depreciation of an asset for a specified or partial period by using a declining balance method
Syntax
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Parameters
- cost: Required. The initial cost of the asset
- salvage: Required. The value at the end of the depreciation
- life: Required. The number of periods
- start_period: Required. The starting period for which you want to calculate the depreciation
- end_period: Required. The ending period for which you want to calculate the depreciation
- factor: Optional. The rate at which the balance declines (default 2)
- no_switch: Optional. Whether to switch to straight-line depreciation (FALSE=switch, TRUE=don't switch)
Example
=VDB(2400, 300, 10*365, 0, 1)