[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

SLN

SLN ( cost , salvage , life )

Description: Computes the straight-line depreciation of an asset for one period.

Arguments:

Name

Type

Description

cost

number

The number cost is the initial cost of the asset.

salvage

number

The value at the end of the depreciation. (This is sometimes called the salvage value of the asset.)

life

number

The number of periods over which the asset is being depreciated. (This is sometimes called the useful life of the asset.)

 

Return Type and Value: number – The straight-line depreciation of an asset for one period.

[Example:

SLN(30000,7500,10) results in 2,250.00

end example]