Back to all functions

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.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.