Documentation/Calc Functions/SLN

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

DDB

SYD

ODF standard:

Section 6.12.45, part 2

Equivalent Excel functions:

SLN