[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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]