SLN Function Explained
The SLN Function in Microsoft Excel is used to calculate the straight-line depreciation of an asset for a specified period. It takes three arguments: the cost of the asset, the salvage value of the asset, and the life of the asset in number of periods. It returns the depreciation amount for a single period.
SLN Function Syntax
SLN(cost, salvage, life)
- cost: The initial cost of the asset.
- salvage: The value of the asset at the end of its useful life.
- life: The number of periods over which the asset is being depreciated.