Difference between revisions of "Manuals/calci/SYD"

Latest revision as of 17:07, 30 July 2018

SYD (Cost,SalvageValue,LifeValue,Period)

$Cost$ is the initial cost.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SalvageValue } is the salvage which is the value of the asset.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle LifeValue } is the life of the number of periods.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Period } is the number of periods.
- SYD(), returns the sum-of-years digits depreciation of an asset for a specified period.

Description

This function gives the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.
In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SYD (Cost,SalvageValue,LifeValue,Period) } , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Cost} is the original cost of the asset.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SalvageValue} is the salvage value after the asset has been fully depreciated.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle LifeValue} is the useful life of the asset or the number of periods that you will be depreciating the asset, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Period} is the period that you wish to calculate the depreciation for.
SYD is calculated as follows:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SYD = \frac{(c-s)*(l-p+1)*2}{(l)(l+1)}} where is the cost,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SalvageValue} is the salvage,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Period} is the period and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle LifeValue} is the life.

This function will give the result as error when

  1.Any one of the argument is nonnumeric.
  2. SalvageValue<0 
  3. LifeValue or Period<=0
  4. Period is greater than l.

Examples

=SYD(25000,2800,7,1) = 5550
=SYD(50000,9000,15,3) = 4441.6666667
=SYD(42500,6850,6,3) = 6790.47619047

References

Syd

List of Main Z Functions

Z3 home

@@ 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.
+*<math> Period </math> is the number of periods.
+**SYD(), returns the sum-of-years digits depreciation of an asset for a specified period.
 ==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==
@@ Line 23: / Line 25: @@
 #=SYD(50000,9000,15,3) = 4441.6666667
 #=SYD(42500,6850,6,3) = 6790.47619047
+==Related Videos==
+{{#ev:youtube|oEG3X1WouKM|280|center|SYD}}
+==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]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]