The SLN function calculates the straight-line depreciation of an asset for one period.

SLN takes 3 required arguments and no optional arguments:

Syntax: SLN(cost, salvage, life)

#1)
Using the SLN function:
#2)
The arguments for the SLN function are:
Argument Required? Description
cost Required The initial cost of the asset.
salvage Required The value at the end of the depreciation (the salvage value of the asset). This value can be 0.
life Required The number of periods over which the asset is being depreciated (the useful life of the asset).

Summary

The SLN function calculates the straight-line depreciation of an asset for one period.
comments powered by Disqus