Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

SLN Function in Excel: How to Calculate Straight-Line Depreciation

Admin
Duration: 5:27
Submitted: 2 months ago
Views: 127

Comments (0)

Link to this video:

Description:

In this video, we are going to talk about the SLN function in Excel. The SLN function is a depreciation function that returns the straight-line depreciation of an asset for one period.

This can be helpful for businesses that want to calculate how much they will depreciate an asset over a certain number of years.

In order to use the SLN function, you will need to know the initial cost of the asset, the salvage value of the asset, and the number of years that you want to depreciate it for. Let's take a look at how to use this function in Excel!

How to Use SLN Function in Excel?

In order to use the SLN function, you will need to know the initial cost of the asset, the salvage value of the asset, and the number of years that you want to depreciate it for.

The SLN function is located in the Financial category of functions, and you can find it under the D category.

Once you have inserted the SLN function into your worksheet, you will need to input the following information:

- The initial cost of the asset

- The salvage value of the asset

- The number of years you want to depreciate it for

After you have entered this information, hit enter and Excel will return the straight-line depreciation for that asset over the given number of years.

Now, lets learn the syntax of SLN Function in excel;

The Syntax of SLN Function in excel is:

=SLN(cost,salvage,life)

Cost – This is the cost of the asset.

Salvage – This is the salvage value of the asset.

Life – This is the number of periods over which you want to depreciate the asset.

As you can see, the SLN function is a pretty simple function to use. Just remember to input the correct information, and Excel will do the rest for you!

This can be a helpful tool for businesses that want to keep track of their depreciation expenses. Thanks for watching!