Documentation/Calc Functions/SLN

Function name:
SLN

Category:
Financial Analysis

Summary:
Calculates the depreciation of an asset in a single period using the straight-line depreciation method, when the useful life of the asset is specified as a number of such periods. This method depreciates the asset by the same constant value every period.

Syntax:
SLN(Cost; Salvage; Life)

Returns:
Returns a real number (in currency units) which is the amount of depreciation in a single period of time using the straight-line depreciation method. The currency units are the same as those used for the Cost and Salvage values.

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

Salvage is a real number or a reference to the cell containing that number which is the value of the asset at the end of the depreciation. Salvage and Cost should be in the same currency units.

Life is a positive real number or a reference to the cell containing that number which is the number of periods over which the asset is being depreciated.


 * If Life is equal to 0 then the function reports a #DIV/0! error.
 * If any argument is non-numeric then the function reports a #VALUE! error.

Additional details:
SLN calculates the depreciation in a period of time as $$ \frac{Cost - Salvage}{Life}. $$

General information about straight-line depreciation can be found at Wikipedia's Straight-line depreciation page.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/DDB DDB]

[[Special:MyLanguage/Documentation/Calc_Functions/SYD SYD]

ODF standard:
Section 6.12.45, part 2

Equivalent Excel functions:
SLN