Documentation/Calc Functions/SLN

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

SLN

Category:

Financial Analysis

Summary:

Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.

Syntax:

SLN(Cost; Salvage; Life)

Returns:

Arguments:

Cost is the initial cost of an asset.

Salvage is the value of an asset at the end of the depreciation.

Life is the depreciation period determining the number of periods in the depreciation of the asset.

Additional details:

Examples:

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.

=SLN(50000;3,500;84) = 553.57 currency units. The periodic monthly depreciation of the office equipment is 553.57 currency units.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: