Back to all functions

In this lesson we will be going through the Depreciation function SYD, which returns the Sum of Years’ digits.
The function is written in the same way as SLN function, except that the period for each payment is also needed.
We’ll write Equals, SYD, select the cost, make it absolute, select the Residual Value, make it absolute, select the life span, make it absolute, and then select the period to the left without making it absolute.
We will then drag down to see the depreciation value for each of the periods, which eventually leads to the Asset value being the same as the Residual Value.
As we can see, the values are not all the same as in the SLN function, and we can insert a line graph to see the curvature of the line.
In this lesson we have looked at the SYD function, which returns the Sum of Years’ digits.

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.