VDB

Depreciation of asset for period

Description

Calculates an asset's depreciation for a given period.

Function signature

VDB(cost: Number, salvage: Number, life: Number, startperiod: Number, endperiod: Number, factor: Number = 2, noswitch: Boolean) => Number

Parameter

Description

Cost

Initial cost of the asset.

Salvage

Value of the asset at the end of depreciation (salvage value).

Life

Number of periods of depreciation (useful life of the asset).

Start period

Starting period to calculate depreciation.

End period

Ending period to calculate depreciation.

Factor

Rate of balance decline (the default is 2: the double-declining balance method).

No switch

Whether to switch to straight-line depreciation when the depreciation is greater than the declining balance calculation

Examples

Formula

Return value

VDB(100, 10, 20, 10, 11, 2, true)

3.4867844

VDB(100, 33, 20, 10, 11, 2, false)

1.86784401

VDB(100, 33, 20, 10, 11, 2)

1.86784401

VDB(100, 33, 20, 10, 11)

1.86784401