VDB (PQL  xl)
This function returns the depreciation of an asset for any period you specify using the variable declining balance method
 Library: PQL \ Spreadsheet \ Financial
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
 Solve: This function can be used with the Solve plugin: both as part of the objective function and constraint functions
Syntax
Function Arguments
Name  Description  Type  Optional 
cost  Initial cost of the asset  Number 

salvage  Value at the end of the depreciation period  Number 

life  Number of periods over which the asset is being depreciated  Number 

start period  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  Number 

end period  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  Number 

factor  Rate at which the balance declines; if omitted, uses two (2)  Number  Y 
no switch  Logical value specifying whether to switch to straightline depreciation when depreciation is greater than the declining balance calculation; if omitted uses FALSE  Number  Y 
Comments
This function is the same as the Microsoft Excel 'VDB' function  using the same inputs, logic and outputs.