SLN

Syntax

SLN (Cost, Salvage, Life)

Description

The SLN function returns the depreciation on an asset by using the straight line method, which is a single programming statement. This function returns the same depreciation for each period.

Parameters

Parameter	Description
Cost	The cost of the asset.
Salvage	The worth of the asset at the end of its useful life.
Life	The number of periods in the asset's useful life.

Returns

The depreciation on an asset using the Straight Line method. This function returns the same depreciation for each period.

Example

Suppose that you purchase a machine for 6000 USD, and you plan to sell it for 500 USD after five years. You can calculate the depreciation for each year as follows:

SLN(6000, 500, 5) = 1100