The VBA SLN Function

Related Functions:
VBA DDB
VBA SYD

Description

The VBA SLN function calculates the straight line depreciation of an asset for a single period.

The syntax of the function is:

SLN( Cost, Salvage, Life )

Where the function arguments are:

Cost-

The initial cost of the asset.

Salvage-The value of the asset at the end of its useful life.
Life-The number of periods over which the asset is to be depreciated.


VBA SLN Function Example

In the example below, the VBA SLN function uses the straight line depreciation method to calculate the yearly depreciation of an asset that cost $10,000 at the start of year 1, and has a salvage value of $1,000 after 5 years.

' Calculate the yearly depreciation of an asset that cost $10,000 at
' the start of year 1, and has a salvage value of $1,000 after 5 years.
Dim yrly_dep As Double
yrly_dep = SLN( 10000, 1000, 5 )
' yrly_dep is calculated to be 1800.

The above call to the VBA SLN function calculates the yearly depreciation of the asset to be $1,800.

Therefore, as expected, the total depreciation of the asset over 5 years is $9,000.


VBA SLN Function Error

If the supplied Life argument is equal to 0, the VBA SLN produces the error:

Run-time error '5': Invalid procedure call or argument

VBA Run Time Error 5 Message Box