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 period for which the depreciation is returned is expressed in the same unit of time as the useful life of the asset. All arguments must be positive numbers.