Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft 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 

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