Documentation/Calc Functions/SLN
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
SLN
Category:
Financial Analysis
Summary:
Uses the straight-line depreciation method to calculate the constant depreciation expense to be charged during each period of the useful life of an asset.
Syntax:
SLN(Cost; Salvage; Life)
Returns:
Returns a real number which is the depreciation of the asset to be applied during each period, calculated using the straight-line depreciation method. The number returned is in the same currency unit as the specified cost and salvage values, and by default is formatted in a locale-dependent currency format.
Arguments:
Cost is a real number, or a reference to a cell containing that number, which is the cost or value of the asset before depreciation.
Salvage is a real number, or a reference to a cell containing that number, which is the residual value of the asset at the end of its depreciated life. Salvage must be in the same currency units as Cost.
Life is a non-zero real number, or a reference to the cell containing that number, which defines the number of periods over which the asset is depreciated.
- If any argument is non-numeric then SLN reports a #VALUE! error.
- If Life is equal to 0.0 then the function reports a #DIV/0! error.
- SLN performs a very simple calculation and it is deliberately left to the user to ensure that numeric argument values are as intended. Argument values are not specifically checked for validity and this means, for example, that the user could enter negative values without any error being reported.
Additional details:
- SLN calculates the constant depreciation for each depreciation period as:
- [math]\displaystyle{ \frac{Cost - Salvage}{Life} }[/math]
- General information about straight-line depreciation can be found at Wikipedia's Straight-line depreciation page.
Examples:
Note that the formatting of the return values given in the following examples assume the English (USA) locale.
Formula | Description | Returns |
---|---|---|
=SLN(50000; 3500; 28) | Office equipment with an initial cost of 50,000 currency units is to be depreciated quarterly over 7 years. The value at the end of the depreciation is to be 3,500 currency units. The straight-line depreciation in each quarter is 1,660.71 currency units. | $1,660.71 |
=SLN(400; 0; 1.4) | An asset with an initial cost of 400 currency units is to be depreciated over 1.4 years. The value at the end of the depreciation is to be 0 currency units. The straight-line depreciation in each year is 285.71 currency units. | $285.71 |
=SLN(A2; B2; C2) where cells A2, B2, and C2 contain the numbers 100000, 50000 and 15 respectively. | An asset with an initial cost of 100,000 currency units is to be depreciated over 15 years. The value at the end of the depreciation is to be 50,000 currency units. The straight-line depreciation in each year is 3,333.33 currency units. | $3,333.33 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
SLN