Changes

Jump to navigation Jump to search
111 bytes added ,  22:52, 30 July 2018
no edit summary
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 &lt;=0, Calci displays #N/A error message.
+
*If <math>LifeValue</math> is &lt;=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>
writer
6,694

edits

Navigation menu