# Documentation/Calc Functions/SLN

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

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

## Additional details:

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

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

SLN