Sln (function)

Syntax

Sln(Cost,Salvage,Life)

Description

Returns the straight-line 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 straight-line 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()
  dep# = Sln(10000.00,500.00,10)
  MsgBox "The annual depreciation is: " & Format(dep#,"Currency")
End Sub

See Also

SYD (function); DDB (function).

 

 

 

More information

S