Vdb

Syntax

Vdb(Cost, Salvage, Life, StartPeriod, EndPeriod, Factor, NoSwitch

Parameters

Cost. The initial cost of the asset.

Salvage. The value at the end of the depreciation.

Life. The number of periods, over which the asset is depreciated.

StartPeriod. Start period, for which depreciation should be calculated.

EndPeriod. End period, for which depreciation should be calculated.

Factor. Interest rate of decreasing remainder.

NoSwitch. Boolean value that determines whether linear depreciation should be used when depreciation is greater that the value calculated by declining balance method:

True. Use linear depreciation.
False. Do not use linear depreciation.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the value of asset depreciation over any selected period, including partial periods, using the method of double balance decrease or any other specified method.

Comments

The StartPeriod and EndPeriod parameters must be specified using the same measurement units, as the Life parameter.

Example

Formula	Result	Description
=Vdb(5000, 100, 12, 1, 3, 2, true)	1273,15	Depreciation over the first three periods.
=Vdb(5000, 100, 12, B6, C7, 1.5, true)	740,69	Depreciation over the range of periods. The beginning of the range is specified in the B6 cell, whereas the end is specified in the C7 cell. The B6 cell contains the 6 value, the C7 cell contains the 9 value.