Syntax :

=VDB( cost, salvage, life, start_period, end_period, [factor], [no_switch] )

Parameters :

• cost – The asset’s initial purchase price.

• Salvage – The asset’s worth at the conclusion of depreciation.

• life -The number of periods over which an asset will be depreciated.

• start period – The starting period for which the depreciation should be calculated.

• end period – The period at the end of which you wish to compute depreciation.

• [factor] – An optional parameter for specifying the rate of depreciation.
  If the function’s [factor] argument is missing, the default value of 2 (specifying the double declining depreciation technique) is used.
• [no switch] – When depreciation exceeds the decreasing balance calculation, an optional logical argument determines whether the technique should switch to straight line depreciation. Possible values include:

– TRUE – Do NOT use the straight-line depreciation technique when depreciation exceeds the falling balance calculation;

– FALSE – DO use the straight-line depreciation method when depreciation exceeds the decreasing balance calculation.
If the [no switch] option is missing, the default value is FALSE.