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 plug-in: both as part of the objective function and constraint functions

Syntax

VDB(cost, salvage, life, start period, end period, OPTIONAL factor, OPTIONAL no switch)

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 straight-line 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.