SLN function
The SLN function in Excel is used to calculate the straight-line depreciation of an asset over a specified period. It assumes that the asset depreciates by the same amount each period. This function is commonly used in accounting and finance to determine how much an asset’s value decreases over time.
Syntax
SLN(cost, salvage, life)
Parameters
cost: The initial cost of the asset, or how much the asset was purchased for.salvage: The salvage value, which is the expected value of the asset at the end of its useful life (i.e., how much the asset is worth when it is no longer in use).life: The number of periods over which the asset will be depreciated (e.g., the number of years the asset will be in use).
How It Works
The SLN function calculates the annual depreciation of an asset using the straight-line method. The formula used by the SLN function is:
Where:
- Cost is the initial value of the asset,
- Salvage value is the asset’s value at the end of its useful life,
- Life is the total number of periods over which depreciation is spread.
Example
Suppose you bought a machine for $10,000, and you expect it to have a salvage value of $2,000 after 5 years. To calculate the straight-line depreciation per year, you would use the SLN function as follows:
=SLN(10000, 2000, 5)
In this case:
- The cost is $10,000,
- The salvage value is $2,000,
- The life is 5 years.
The function will return $1,600, which means that the machine will depreciate by $1,600 each year for 5 years.
Important Notes
- The SLN function does not account for changing depreciation methods, irregular depreciation amounts, or tax considerations. It assumes equal depreciation over the asset’s useful life.
- The result of the SLN function is the same every period.
Summary
The SLN function in Excel is used to calculate straight-line depreciation, which is the same amount deducted for each period over the asset’s useful life. It’s a simple and widely used method in accounting to estimate the loss in value of an asset over time.