# Documentation/Calc Functions/SLN

Jump to navigation Jump to search

SLN

## Category:

Financial Analysis

## Summary:

Calculates the straight-line depreciation of an asset for one period. The amount of depreciation is constant during the depreciation period.

## Syntax:

SLN(Cost; Salvage; Life)

## Returns:

Returns a real number which is the amount of depreciation at a given period of time using the straight-line depreciation method.

## Arguments:

Cost is a positive real number or a reference to the cell containing that number which is the initial cost of an asset.

Salvage is a positive real number or a reference to the cell containing that number which is the value of an asset at the end of the depreciation.

Life is a positive real number or a reference to the cell containing that number which is the depreciation period determining the number of periods in the depreciation of the asset.

• If Life is 0 then the function returns a #DIV/0! error

None

## Examples:

Formula Description Returns
=SLN(50000;3500;84) Office equipment with an initial cost of 50,000 currency units is to be depreciated over 7 years. The value at the end of the depreciation is to be 3,500 currency units. 553.57 (currency units)
=SLN(400;0;0.4) The function calculates the straight-line depreciation of an asset for one period. The amount of depreciation is constant during the depreciation period. 1000.00 (currency units)

SLN