How to use SLN function in excel for depreciation calculation

Excel version in which SLN function can work:

SLN function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.

About SLN function in excel:

SLN is a worksheet financial function, this will calculate straight line depreciation of an asset for one period.

Syntax for SLN Function:

=SLN(cost, salvage, life)


Cost [Required]: initial total cost of the asset.
Salvage [Required]: expected sale vale at the end of the life of the asset.
Life [Required]: useful life of the asset or number of periods over which the asset is to be depreciated.

Using SLN function:

With SLN function we can calculate depreciation as per straight line method for an asset.

sln function in excel

Leave a Comment

Your email address will not be published. Required fields are marked *