Description
The Excel SLN function calculates the straight line depreciation of an asset for one period.
The format of the function is :
SLN( cost, salvage, life )
where the arguments are as shown in the table below:
SLN Function Examples
The examples on the right show the SLN function, used to calculate the yearly or monthly depreciation of assets with different cost, salvage and lifetime values.
The formulas are shown in the top spreadsheet, and the results are shown in the bottom spreadsheet.
Sln Function Errors.
If you get an error from the Excel SLN Function, this is likely to be one of the following :
Common Errors
No comments:
Post a Comment