The Excel SLN function calculates the straight line depreciation of an asset for one period.
The format of the function is :
where the arguments are as shown in the table below:
|cost||-||The initial cost of the asset|
|salvage||-||The value of the asset at the end of the depreciation|
|life||-||The number of periods over which the asset is to be depreciated|
The examples below show the SLN function, used to calculate the yearly or monthly depreciation of assets with different cost, salvage and lifetime values.
Further examples of the Excel SLN function can be found on the Microsoft Office website.
If you get an error from the Excel SLN Function, this is likely to be one of the following :
|#DIV/0!||-||Occurs if the supplied life argument is 0|
|#VALUE!||-||Occurs if any of the supplied arguments are not numeric values|