Documentation/Calc Functions/SLN

    From The Document Foundation Wiki
    Other languages:

    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]

    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:

    AMORDEGRC

    AMORLINC

    DB

    DDB

    SYD

    VDB

    ODF standard:

    Section 6.12.45, part 2

    Related (or similar) Excel functions:

    SLN