Manuals/calci/SYD - Revision history

Devika at 23:07, 30 July 2018

2018-07-30T23:07:27Z

Devika at 23:06, 30 July 2018

2018-07-30T23:06:43Z

Jayaram at 11:08, 14 March 2017

2017-03-14T11:08:58Z

Swapna at 18:58, 19 July 2015

2015-07-19T18:58:03Z

Devika at 18:21, 13 May 2015

2015-05-13T18:21:45Z

Devika: /* Description */

2014-02-24T09:24:44Z

Description

Devika at 09:22, 24 February 2014

2014-02-24T09:22:56Z

MassBot1: Created page with "
'''SYD'''
2013-10-25T02:45:41Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''SYD'''</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">'''SYD'''</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 face="Arial, sans-serif"><font size="2">'''P'''</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, 'L' is the number of periods over which the asset is depreciated and 'P' is the period </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 sum-of-years' digits depreciation of an asset for a specified period.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">SYD is calculated as follows: </font></font></font>

<font color="#000000"></font>

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

SYD

</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">SYD(C, salvage, L, P)</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>=SYD(B2,B3,B4,1) is 5230.7692</nowiki></font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=SYD(B2,B3,B4,10) is 1307.6923</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="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </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="5SpaceContent" class="zcontent" align="left">

{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 45000
| class="SelectTD sshl_t ChangeBGColor" |
| class=" sshl_t" |
| class=" sshl_t" |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 11000
| class=" sshl_t" |
| class=" sshl_t" |
| class=" sshl_t" |
|- class="odd"
| Row3
| class=" " | 12
| class=" sshl_t" |
| class=" sshl_t" |
| class=" sshl_t" |
|- class="even"
| Row4
| class="sshl_f" | 5230.7692
| class=" sshl_t" |
| class=" sshl_t" |
| class=" sshl_t" |
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 1307.6923
| class=" sshl_t" |
| class=" sshl_t" |
| class=" sshl_t" |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}

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

@@ Line 5: / Line 5: @@
 *<math> LifeValue </math> is the life of the number of periods.
 *<math> Period </math> is the number of periods.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''SYD(c,s,l,p)'''</div><br/>
+<div style="font-size:30px">'''SYD (Cost,SalvageValue,LifeValue,Period) '''</div><br/>
-*<math>c </math>  is the initial cost.
-*<math> s </math> is the salvage which is the value of the asset.
+*<math>Cost </math>  is the initial cost.
-*<math> l </math> is the life of the number of periods.
+*<math> SalvageValue </math> is the salvage which is the value of the asset.
-*<math> p </math> is the number of periods.
+*<math> LifeValue </math> is the life of the number of periods.
 ==Description==
 *This function gives the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.
-*In <math>SYD(c,s,l,p)</math>, <math>c</math> is the original cost of the asset.
+*In <math>SYD (Cost,SalvageValue,LifeValue,Period) </math>, <math>Cost</math> is the original cost of the asset.
-*<math>s</math> is the salvage value after the asset has been fully depreciated.
+*<math>SalvageValue</math> is the salvage value after the asset has been fully depreciated.
-*<math>l</math> is the useful life of the asset or the number of periods that you will be depreciating the asset, <math>p</math> is the period that you wish to calculate the depreciation for.
+*<math>LifeValue</math> is the useful life of the asset or the number of periods that you will be depreciating the asset, <math>Period</math> is the period that you wish to calculate the depreciation for.
 *SYD is calculated as follows:
 <math>SYD = \frac{(c-s)*(l-p+1)*2}{(l)(l+1)}</math>
-where <math>c</math> is the cost,<math>s</math> is the salvage,<math>p</math> is the period and <math>l</math> is the life.
+where <math>Cost</math> is the cost,<math>SalvageValue</math> is the salvage,<math>Period</math> is the period and <math>LifeValue</math> is the life.
 *This function will give the result as error when
 .Any one of the argument is nonnumeric.
-.s<0
+. SalvageValue<0
-.l or p<=0
+. LifeValue or Period<=0
-.p is greater than l.
+. Period is greater than l.
 ==Examples==

← Older revision		Revision as of 11:08, 14 March 2017
Line 35:		Line 35:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_SYD_function Syd]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_SYD_function Syd]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 23: / Line 23: @@
 #=SYD(50000,9000,15,3) = 4441.6666667
 #=SYD(42500,6850,6,3) = 6790.47619047
 ==See Also==

← Older revision		Revision as of 18:21, 13 May 2015
Line 23:		Line 23:
	#=SYD(50000,9000,15,3) = 4441.6666667		#=SYD(50000,9000,15,3) = 4441.6666667
	#=SYD(42500,6850,6,3) = 6790.47619047		#=SYD(42500,6850,6,3) = 6790.47619047
		+
		+	==See Also==
		+	*[[Manuals/calci/PMT\| PMT]]
		+	*[[Manuals/calci/PPMT\| PPMT]]
		+	*[[Manuals/calci/PV\| PV]]
		+
		+	==References==
		+	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_SYD_function Syd]