SLN Function
The SLN function calculates the Straight Line Depreciation of an item, with the given values.
Formula:
= SLN(Cost, Salvage, Life)
Whereas Cost - initial cost of the asset.
Salvage - value at the end of the depreciation or the Selling Price
Life - the number of periods over which the asset is depreciated.
SLN is calculated as the difference between Cost and Salvage divided by the life (no of years)
Video Tutorial:
Let us check if the given number is positive or negative, using the SIGN function, with the help of the below video.
