SLN Function

       

Returns a Double specifying the straight-line depreciation of an asset for a single period.

Syntax

SLN(cost, salvage, life)

The SLN function has these named arguments:

Part	Description
cost	Required. Double specifying initial cost of the asset.
salvage	Required. Double specifying value of the asset at the end of its useful life.
life	Required. Double specifying length of the useful life of the asset.

Remarks

The depreciation period must be expressed in the same unit as the life argument. All arguments must be positive numbers.