Excel 2000 in a Nutshell

Name

VDB

Synopsis

You can use VDB to determine the amount of depreciation for an asset across multiple periods of time by specifying a start and end time. As a default, the function calculates the depreciation using the double-declining balance method, but you can use a different method by specifying a value for the Factor argument.

To Calculate

=VDB(Cost, Salvage, Life, Start_Period, End_Period, Factor, No_Switch)

The Factor and No_Switch arguments are optional. All other arguments must have a value.

Cost

Indicates the total amount paid to acquire the asset.

Life

An integer value that indicates the number of periods that the asset will be depreciated over. For example, if you purchase a computer that will have a useful life of five years you would specify a value of 5 for the Life argument.

Start_Period

An integer value that represents the starting of the period of time that you want to calculate the depreciation amount. If you want to determine the amount of depreciation for the second through the fourth year, the value of the Start_Period argument would be 2 and the End_Period argument would be 4.

Note

If the start period or the end period you want to specify is not a complete period, you can specify a decimal value that represents the expected amount of the period. For example, if the asset was purchased halfway through the first year you would specify as the value for the Start_Period argument and .5 as the value of End_Period to determine the amount of depreciation for the remainder ...