# VDB

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the depreciation of an asset for any period you specify using the variable declining balance method.

## Syntax

VDB(*cost*,*salvage*,*life*,*start*,*end*,*factor*,*switchnot*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *cost* | Initial cost of the asset |
| *salvage* | Value at the end of the depreciation period |
| *life* | Number of periods over which the asset is being depreciated |
| *start* | Number representing the starting period for which to calculate the depreciation in the same units as *life*; if not an integer, the number is truncated |
| *end* | Number representing the ending period for which to calculate the depreciation in the same units as *life*; if not an integer, the number is truncated |
| *factor* | [Optional] Rate at which the balance declines; if omitted, uses two (2) |
| *switchnot* | [Optional] Logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation; if omitted uses FALSE |

## Remarks

If *factor* is omitted, the calculation uses two, which represents the double‑declining balance method. For other methods, use a different value. For more information about the double‑declining balance method, see [DDB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDDB).

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`VDBD(B1,1000,10,1,8)`
`VDB(50000,500,1200,100,1000,1)` gives the result $37,122.94

## Version Available

This function is available in product version 1.0 or later.

## See Also

[DB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDB) \| [DDB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDDB) \| [SLN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSLN) \| [SYD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSYD) \| [Financial Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsfinance)