SLN function - Returns the depreciation value of an asset using the straight-line method in Excel
The following article details the syntax and usage of SLN in excel.
Description: Returns the depreciation of assets according to the straight-line method over a given period.
Syntax: SLN (cost, salvage, life) .
Inside:
- cost : The initial cost of the property, is a required parameter.
- salvage : Value after depreciation, also called the value of product recall, is a mandatory parameter.
- life : Number of periods of depreciation, also known as useful life of assets, is a required parameter.
Attention:
- SLN function is calculated by the formula:
For example: Calculating the annual average depreciation for an asset with initial value of 600,000,000 and the remaining value after depreciation is 125,000,000 and the asset has a shelf life of 10 years.
In the cell to calculate enter the formula: = SLN (B7, C7, D7) .
Press Enter -> the average depreciation per year of the property over a 10 year period is:
The above is a detailed guide of usage and specific example of SLN function. Hope to help you in the case of depreciation calculation.
Good luck!
You should read it
- DDB function - Calculate depreciation of assets in Excel
- AMORDEGRC function - The function returns the depreciation for each accounting period in Excel
- LINEST function - The function returns a line description array using the least square method in Excel
- DB function - The function calculates the depreciation of assets with specific maturity in Excel
- SLOPE function - The function returns the slope of a linear regression line through data points in Excel
- INTERCEPT function - The function returns the point at which the line will intersect the y-axis by using the existing x and y values in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- How to use the IF function in Excel
May be interested
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.