Manuals/calci/SLN - Revision history

Devika at 22:31, 22 August 2018

2018-08-22T22:31:37Z

Devika: /* Description */

2018-07-30T22:54:18Z

Description

Devika at 22:52, 30 July 2018

2018-07-30T22:52:42Z

Jayaram at 11:08, 14 March 2017

2017-03-14T11:08:43Z

Swapna at 18:57, 19 July 2015

2015-07-19T18:57:07Z

Swapna at 22:42, 27 February 2014

2014-02-27T22:42:18Z

Swapna at 22:39, 27 February 2014

2014-02-27T22:39:25Z

MassBot1: Created page with "
'''SLN'''
2013-10-25T02:44:31Z

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-..."

New page
<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-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>

<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>

</div>
----
<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

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">SLN(C,salvage, L)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>

<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">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 45000
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 11000
| 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="odd"
| class=" " | Row5
| class="SelectTD sshl_t ChangeBGColor" |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" sshl_t" |
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 5: / Line 5: @@
 *<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.
+**SLN(), returns the straight-line depreciation of an asset for one period.
 == Description ==

@@ Line 14: / Line 14: @@
 *Depreciation is the decrease in value of an asset.
 *If <math>LifeValue</math> is &lt;=0, Calci displays #N/A error message.
-*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 -
+*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>

@@ Line 1: / Line 1: @@
-=SLN(C, Salvage, L)=
+<div style="font-size:30px">'''SLN (Cost,SalvageValue,LifeValue)'''</div><br/>
 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 ==
-SLN(C, Salvage, L)
+SLN (Cost,SalvageValue,LifeValue)
 *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>

← Older revision		Revision as of 11:08, 14 March 2017
Line 62:		Line 62:
	*[http://en.wikipedia.org/wiki/Depreciation Depreciation]		*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
	*[http://en.wikipedia.org/wiki/Depreciation#Straight-line_depreciation Straight Line Depreciation]		*[http://en.wikipedia.org/wiki/Depreciation#Straight-line_depreciation Straight Line Depreciation]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 48: / Line 48: @@
   =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 ==

@@ 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
-<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 ==
-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:
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
 |- class="odd"
-| class=" " | Row1
+| class=" " | 11,000
-| class="sshl_f" | 45000
+| class=" " |
 | class=" " |
 |- class="even"
-| class="  " | Row2
+| class=" " | 12
-| class="sshl_f" | 11000
+| class=" " |
 | class=" " |
 |- class="odd"
-| class=" " | Row5
+| class=" " |
-| class="SelectTD                                                                    sshl_t ChangeBGColor" |
+| 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.