Syntax 
Sln(Cost,Salvage,Life) 

Description 
Returns the straightline depreciation of an asset assuming constant benefit from the asset. 

Comments 
The Sln of an asset is found by taking an estimate of its useful life in years, assigning values to each year, and adding up all the numbers. The formula used to find the Sln of an asset is as follows: (Cost  Salvage Value) / Useful Life The Sln function requires the following parameters: 


Parameter 
Description 

Cost 
Double representing the initial cost of the asset. 

Salvage 
Double representing the estimated value of the asset at the end of its useful life. 

Life 
Double representing the length of the asset's useful life. 

The unit of time used to express the useful life of the asset is the same as the unit of time used to express the period for which the depreciation is returned. 

Example 
This example calculates the straightline depreciation of an asset that cost $10,000.00 and has a salvage value of $500.00 as scrap after 10 years of service life. Sub Main() 

See Also 




S 