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

SLN(cost, salvage, life)

 
 Returns the straight-line depreciation of an asset for one period.

 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.

 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.
     
  		• Example - Suppose you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500. The depreciation allowance for each year is £2,250.

     EXAMPLES
     
     A
    1=SLN(30000,7500,10) = £2,250.00
    		 
     Functions - S | Index - S | Office Online 

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