Navigation:  Formula Reference > Spreadsheet Formula Functions >

VDB

Previous pageReturn to chapter overviewNext page

 

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.

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

 

See Also

DB

DDB

SLN

SYD