Spread 8.0 Documentation
SLN
Support Options
Formula Reference > Built-In Functions > SLN

Glossary Item Box

SLN


Name

Straight-line depreciation

Description

Returns the straight-line depreciation of an asset for one period.

Syntax

SLN(Cost, Salvage, Life)

Remarks

Arguments are as follows:

Argument Description
Cost Initial cost of the asset
Salvage Value at the end of the depreciation
Life Number of periods over which the asset is being depreciated

See also DB, DDB, and SYD.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

SLN(R1C2,1000,10)
SLN(500000,20000,5)=96000

Copyright © GrapeCity, inc. All rights reserved.