Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > DB
 

DB(cost, salvage, life, period [,month])

 
 Returns the depreciation of an asset using the fixed-declining balance method.

 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.
 periodThe period to calculate the depreciation over.
 monthThe number of months in the first year between 1 and 12.

 REMARKS
 
  		• The fixed-declining balance method computes depreciation at a fixed rate.
     
  		• The depreciation is calculated using: (cost - total depreciation from prior periods) * rate
     
  		• The value at the end of the depreciation (sometimes called the salvage value of the asset).
     
  		• The "period" and "life" must both use the same units.
     
  		• If "month" is left blank, then 12 is used.
     
  		• The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
     
  		• If the cell contains the General number format, then the format is automatically changed to "£#,##0.00;".

     EXAMPLES
     
     A
    1=DB(1000000,100000,6,1,7) = £186,083.33
    2=DB(1000000,100000,6,2,7) = £259,639.42
    3=DB(1000000,100000,6,3,7) = £176,814.44
    4=DB(1000000,100000,6,4,7) = £120,410.64
    5=DB(1000000,100000,6,5,7) = £81,999.64
    6=DB(1000000,100000,6,6,7) = £55,841.76
    7=DB(1000000,100000,6,7,7) = 15,845.10
    8=DB(10000,3000,12,1,12) = 950
    9=DB(0,5000,12,1,12) = 0
    10=DB(10000,3000,12,"some text",2) = #VALUE!
    		 
     Functions - D | Index - D | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top