Difference between revisions of "Manuals/calci/SLN"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
*Depreciation is the decrease in value of an asset. | *Depreciation is the decrease in value of an asset. | ||
*If <math>LifeValue</math> is <=0, Calci displays #N/A error message. | *If <math>LifeValue</math> is <=0, Calci displays #N/A error message. | ||
| − | * | + | *Let 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset in years, then Depreciation using Straight-line method is calculated as - |
<math>Annual Depreciation Expense = \frac{C - Salvage}{L}</math> | <math>Annual Depreciation Expense = \frac{C - Salvage}{L}</math> | ||
Revision as of 16:54, 30 July 2018
SLN (Cost,SalvageValue,LifeValue)
Where
- is the initial cost of an asset,
- is the value at the end of depreciation, and
- is the life of an asset that indicates the number of periods over which the asset is being depreciated.
is the initial cost of an asset,
is the value at the end of depreciation, and
is the life of an asset that indicates the number of periods over which the asset is being depreciated.SLN(), returns the straight-line depreciation of an asset for one period.
Description
SLN (Cost,SalvageValue,LifeValue)
- Depreciation is the decrease in value of an asset.
- If is <=0, Calci displays #N/A error message.
- Let 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset in years, then Depreciation using Straight-line method is calculated as -
Examples
Consider the following example that shows the use of SLN function:
| 45,000 | ||
| 11,000 | ||
| 12 | ||
=SLN(A1,A2,A3) : Calculates the depreciation for values in the range A1 to A3.
Displays 2833.3333333333335 as a result. =SLN(20000,1000,10.5) : Displays 1809.5238095238096 as a result.
Related Videos
See Also
References