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

TBILLYIELD

XIRR

Last updated 11 months ago

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`

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