Calculate depreciation.

`=SLN(cost, salvage, life)`

- cost - required, double
- salvage - required, double
- life - required, double, must be positive

`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

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.

The SLN function is a calculation used to determine the straight-line depreciation for an asset over one period. The required arguments for the SLN function are cost, salvage, and life.

The SLN function returns a value that is the straight-line depreciation for one period.

- Cost
- Salvage
- Life

Drop CSV