SLN
Formulas / SLNCalculate depreciation.
=SLN(cost, salvage, life)
- cost - required, double
- salvage - required, double
- life - required, double, must be positive
Examples
SLN(cost, salvage, life)This function returns the depreciation for each year within the range specified.
=SLN($20,000, $2,000, 4)Let's say you want to calculate the depreciation of a car over a 4 year period. The car originally cost $20,000, and is estimated to have a salvage value of $2,000 at the end of its life. To calculate its depreciation in each year, you would enter the preceding formula in Sourcetable.The result would be $4,500, which is the depreciation for each year of the car's life.
=SLN($20,000, $2,000, 3.5)Let's say you want to calculate the depreciation of a car over a 3.5 year period. The car originally cost $20,000, and is estimated to have a salvage value of $2,000 at the end of its life. To calculate its depreciation in each year, you would enter the formula in Sourcetable.The result would be $5,000, which is the depreciation for each year of the
Summary
The SLN function is used to calculate the depreciation of an asset over a certain period of time. It requires three arguments: cost, salvage, and life.
- The SLN function calculates the amount of depreciation for an asset over a period of time.
- The three arguments that must be included when using the SLN function are cost, salvage, and life.
Frequently Asked Questions
What is the SLN function?
What is the return value of the SLN function?
What are the required arguments for the SLN function?
- Cost
- Salvage
- Life
