During the period 23/12 to 6/1, we will have slightly longer response times than usual. Merry Christmas and a Happy New Year! 🎄✨

Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

SLN

See more Excel functions
Share

SLN is the simplest Depreciation function that Excel offers, and is short for Straight Line.
This means that if we were to graph the Asset Values, the line would appear straight, because each of the depreciation values will be the same.
We’ll write Equals, SLN, select the Cost, make it absolute, select the Residual Value, make it absolute, and then select the life span, and make that absolute as well.
We are given a value of thirteen hundred and sixty, which, if we drag down, we can see will be the same for all the periods.
If we take a look at the Asset Value section, we can see that the value is decreasing steadily until it gets to the Residual Value above.
We can insert a graph for the Asset Values to see that the line is straight.
In this lesson we have gone through SLN, the first of five Depreciation functions provided by Excel.