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

AMORLINC(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 of the end of the first period.
 salvageThe salvage value at the end of the life of the asset.
 periodThe period to calculate the depreciation.
 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.
     
  		• 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.
     
  		• If an asset is purchased in the middle of an accounting period then the pro-rated depreciation is taken into account.
     
  		• This function is provided for the French accounting system.

     EXAMPLES
     
     A
    1=AMORLINC(300,"01/01/2003","31/12/2005",50,1,0.15,1) = 45
    2=AMORLINC(300,"01/01/2003","31/12/2005",50,1,0.15,0) = 45
    3=AMORLINC(3000,"01/01/2003","31/12/2005",50,1,0.15,4) = 450
    4=AMORLINC(50000,"01/01/2003","31/12/2003",500,1,0.15,1) = 7500
    5=AMORLINC(50000,"01/01/2003","31/12/2003",500,2,0.15,1) = 7500
    6=AMORLINC(50000,"01/01/2003","31/12/2003",500,3,0.15,1) = 7500
    7=AMORLINC(50000,"01/01/2003","31/12/2003",500,3,0.15,0) = 7500
    8=AMORLINC(50000,"01/01/2003","31/12/2003",500,3,0.15) = 7500
    9=AMORLINC(100,"01/01/2003","31/12/2005",500,1,0.15,1) = #NUM!
    		 
     Functions - A | Index - A | Office Online 

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