Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Financial > VDB
 

VDB(cost, salvage, life, start_period, end_period [,factor] [,no_switch])

 
 Returns the depreciation of an asset for any period including partial periods.

 costThe initial cost of the asset.
 salvageThe value at the end of the depreciation.
 lifeThe number of periods over which the asset is being depreciated.
 start_periodThe starting period for which you want to calculate the depreciation
Start_period must use the same units as life.
 end_periodThe ending period for which you want to calculate the depreciation
End_period must use the same units as life.
 factor(Optional) The rate at which the balance declines.
 no_switch(Optional) True or False to specify whether to used straight-line depreciation or declining balance depreciation.

 REMARKS
 
  		• This function uses the double declining balance method.
     
  		• VDB stands for variable declining balance.
     
  		• True or False specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
     
  		• If "factor" = 1, then ??
     
  		• If "factor" = 2, then the double declining balance method is used.
     
  		• If "factor" is left blank, then 2 is used.

     EXAMPLES
     
     A
    1=VDB(2400,300,10,0,0.875,1.5) = 315
    2=VDB(2400,300,3650,0,1) = 1.315
    3=VDB(2400,300,120,0,1) = 40
    4=VDB(2400,300,10,0,1) = 480
    5=VDB(2400,300,120,6,18) = 396.306
    6=VDB(2400,300,120,6,18,1.5) = 311.809
    		 
     Functions - V | Index - V | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top