Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

VDB

Description: For a period you specify, returns the depreciation of an asset, using the double-declining balance method. VDB stands for variable declining balance.

Syntax: VDB(Cost, Salvage, Life, Start_Period, End_Period)

Remarks:

Example:

Suppose a factory purchases a new machine. The machine costs $2,400 and has a lifetime of 10 years. The salvage value of the machine is $300. The following examples show depreciation over several periods. The results are rounded to two decimal places.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.