Difference between revisions of "Manuals/calci/SLN"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
*<math>SalvageValue</math> is the value at the end of depreciation, and | *<math>SalvageValue</math> is the value at the end of depreciation, and | ||
*<math>LifeValue</math> is the life of an asset that indicates the number of periods over which the asset is being depreciated. | *<math>LifeValue</math> 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. | |
| − | SLN(), returns the straight-line depreciation of an asset for one period. | ||
== Description == | == Description == | ||
| Line 14: | Line 13: | ||
*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> | ||
Latest revision as of 16:31, 22 August 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.
- SLN(), returns the straight-line depreciation of an asset for one period.
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.
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