Leading the way in Microsoft Office Development
 Home|

Excel

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

SYD(cost, salvage, life, per)

 
 Returns the depreciation of an asset using the sum-of-years 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.
 perThe period.

 REMARKS
 
  		• The value of an asset at the end of the depreciation is also known as the salvage value.
     
  		• The number of periods over which the asset is being depreciated is also known as the useful life.
     
  		• The "life" and "per" must be in the same units.

     EXAMPLES
     
     A
    1=SYD(30000,7500,10,1) = £4,090.91
    2=SYD(30000,7500,10,10) = £409.09
    		 
     Functions - S | Index - S | Office Online 2003 | Office Online 2007 

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