| Line 1: |
Line 1: |
| − | =SLN(C, Salvage, L)= | + | <div style="font-size:30px">'''SLN (Cost,SalvageValue,LifeValue)'''</div><br/> |
| | | | |
| | Where | | Where |
| − | *<math>C</math> is the initial cost of an asset, | + | *<math>Cost</math> is the initial cost of an asset, |
| − | *<math>Salvage</math> is the value at the end of depreciation, and | + | *<math>SalvageValue</math> is the value at the end of depreciation, and |
| − | *<math>L</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() calculates the straight-line depreciation of an asset for one period. | + | SLN(), returns the straight-line depreciation of an asset for one period. |
| | | | |
| | == Description == | | == Description == |
| | | | |
| − | SLN(C, Salvage, L) | + | SLN (Cost,SalvageValue,LifeValue) |
| | | | |
| | *Depreciation is the decrease in value of an asset. | | *Depreciation is the decrease in value of an asset. |
| − | *If <math>L</math> is <=0, Calci displays #N/A error message. | + | *If <math>LifeValue</math> is <=0, Calci displays #N/A error message. |
| − | *If '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 - | + | *If 'Cost' is the cost of fixed asset, 'SalvageValue' is the residual value and 'LifeValue' 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> |