# Manuals/calci/SLN

Jump to navigation
Jump to search

**SLN (Cost,SalvageValue,LifeValue)**

Where

- is the initial cost of an asset,
- is the value at the end of depreciation, and
- is the life of an asset that indicates the number of periods over which the asset is being depreciated.
- SLN(), returns the straight-line depreciation of an asset for one period.

## Description

SLN (Cost,SalvageValue,LifeValue)

- Depreciation is the decrease in value of an asset.
- If is <=0, Calci displays #N/A error message.
- Let 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset in years, then Depreciation using Straight-line method is calculated as -

## Examples

Consider the following example that shows the use of SLN function:

45,000 | ||

11,000 | ||

12 | ||

=SLN(A1,A2,A3) : Calculates the depreciation for values in the range A1 to A3.

Displays2833.3333333333335as a result. =SLN(20000,1000,10.5) : Displays1809.5238095238096as a result.

## Related Videos

## See Also

## References