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

AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate [,basis])

 
 Returns the depreciation of an asset over a particular period.

 costThe cost of the asset.
 date_purchasedThe date the asset was purchased.
 first_periodThe date at the end of the first period.
 salvageThe salvage value at the end of the life of the asset.
 periodThe period to calculate the depreciation over.
 rateThe rate of depreciation.
 basisThe type of day counting to use:
0 = US 30/360
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/365

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function is identical to the AMORLINC() function except that a depreciation coefficient is applied in the calculation (depending on the life of the asset).
     
  		• The value of an asset at the end of the depreciation is also known as the salvage value.
     
  		• If "cost" < "salvage", then #NUM! is returned.
     
  		• If "basis" is left blank, then 0 is used.
     
  		• The life of the asset is calculated by (1 / "rate"). The depreciation coefficient depends on the life of the asset.
     
  		• If the life of the asset is between 0 and 1, 1 and 2, 2 and 3, or 4 and 5, then #NUM! error value is returned.
     
  		• If the life of the asset is between 3 and 4 years, the coefficient is 1.5.
     
  		• If the life of the asset is between 5 and 6 years then the coefficient is 2.
     
  		• If the life is the asset is greater than 6 years then the coefficient is 2.5.
     
  		• The depreciation rate will grow to 50 percent for the period preceding the last period and will grow to 100 percent for the last period.
     
  		• The depreciation is calculated until the last period of the life of the asset or until the cumulated value of depreciation is greater than the cost of the asset minus the salvage value.
     
  		• This function is provided for the French accounting system.

     EXAMPLES
     
     A
    1=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,1,0.15,1) = 11738
    2=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,2,0.15,1) = 7336
    3=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,3,0.15,1) = 4585
    4=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,4,0.15,1) = 2866
    5=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,5,0.15,1) = 2388
    6=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15,1) = 2388
    7=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15,0) = 2384
    8=AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15) = 2384
    9=AMORDEGRC(50000,"01/01/2003","31/12/2003","some text",6,0.15) = #VALUE!
    		 
     Functions - A | Index - A | Office Online 

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