ExcelFunctions.net

Search Site:

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. |

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.

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

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