VDB

VDB depreciation of an asset

Synopsis

VDB(cost,salvage,life,start_period,end_period,factor,no_switch)

Arguments

cost: initial cost of asset

salvage: value after depreciation

life: number of periods

start_period: first period to accumulate for

end_period: last period to accumulate for

factor: factor at which the balance declines

no_switch: do not switch to straight-line depreciation

Description

VDB calculates the depreciation of an asset for a given period range using the variable-rate declining balance method.

Note

If no_switch is FALSE, the calculation switches to straight-line depreciation when depreciation is greater than the declining balance calculation.

See also

DB, DDB.