Difference between revisions of "Manuals/calci/SLN"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''SLN'''</font></font><font face="Arial, sans-...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> 
+
=SLN(C, Salvage, L)=
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''SLN'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''C'''</font></font><font face="Arial, sans-serif"><font size="2">,</font></font><font face="Arial, sans-serif"><font size="2">'''salvage'''</font></font><font face="Arial, sans-serif"><font size="2">, </font></font><font face="Arial, sans-serif"><font size="2">'''L'''</font></font><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+
Where
 +
*<math>C</math> is the initial cost of an asset,
 +
*<math>Salvage</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.
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'C''''</font></font><font face="Arial, sans-serif"><font size="2"> is the initial cost of the asset, 'salvage' is the value at the end of the depreciation and 'Life' is the number of periods over which the asset is depreciated.</font></font></font>
+
SLN() calculates the straight-line depreciation of an asset for one period.
  
</div>
+
== Description ==
----
 
<div id="1SpaceContent" class="zcontent" align="left"><font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the straight-line depreciation of an asset for one period.</font></font></font></div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
DAVERAGE
+
SLN(C, Salvage, L)
  
</div></div>
+
*Depreciation is the decrease in value of an asset.
----
+
*If <math>L</math> is &lt;=0, Calci displays #N/A error message.
<div id="8SpaceContent" class="zcontent" align="left"> 
+
*If 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset, then Depreciation using Straight-line method is calculated as -
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
+
<math>Annual Depreciation Expense = \frac{C - Salvage}{L}</math>
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">SLN(C,salvage, L)</font></font></font>
+
== Examples ==
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>
+
Consider the following example that shows the use of SLN function:
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">45000</font></font></font>
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">11000</font></font></font>
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">12</font></font></font>
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=SLN(B2, B3, B4) is 2833.333</nowiki></font></font></font>
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
 
<div id="2SpaceContent" class="zcontent" align="left">
 
<div id="2SpaceContent" class="zcontent" align="left">
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
 +
| class=" " | 45,000
 +
| class=" " |
 
| class=" " |
 
| class=" " |
| Column1
+
 
| Column2
 
| Column3
 
| Column4
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row1
+
| class=" " | 11,000
| class="sshl_f" | 45000
+
| class=" " |  
| class="                                                                                                                                  " |
 
| class=" " |
 
 
| class=" " |
 
| class=" " |
 +
 
|- class="even"
 
|- class="even"
| class=" " | Row2
+
| class=" " | 12
| class="sshl_f" | 11000
+
| class=" " |  
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 12
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row4
 
| class="sshl_f" | 2833.3333
 
| class=" " |
 
| class=" " |
 
 
| class=" " |
 
| class=" " |
 +
 
|- class="odd"
 
|- class="odd"
| class=" " | Row5
+
| class=" " |  
| class="SelectTD                                                                    sshl_t ChangeBGColor" |
+
| class=" " |  
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row6
 
| class=" sshl_t" |
 
| class=" " |
 
| class=" " |
 
 
| class=" " |
 
| class=" " |
 
|}
 
|}
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
=SLN(A1,A2,A3) : Calculates the depreciation for values in the range A1 to A3. <br />Displays '''2833.3333333333335''' as a result.
----
+
=SLN(20000,1000,10.5) : Displays '''1809.5238095238096''' as a result.
 +
 
 +
== See Also ==
 +
 
 +
*[[Manuals/calci/db | db]]
 +
*[[Manuals/calci/DDB | DDB]]
 +
 
 +
== References ==
 +
 
 +
*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
 +
*[http://en.wikipedia.org/wiki/Depreciation#Straight-line_depreciation Straight Line Depreciation]

Revision as of 17:39, 27 February 2014

SLN(C, Salvage, L)

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() calculates the straight-line depreciation of an asset for one period.

Description

SLN(C, Salvage, L)

  • Depreciation is the decrease in value of an asset.
  • If 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, 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.

See Also

References