The VBA SLN Function
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
Dim yrly_dep As Double' the start of year 1, and has a salvage value of $1,000 after 5 years. 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
