Difference between revisions of "Manuals/calci/SYD"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by 3 users not shown)
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==
 
==Description==
 
*This function gives the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.  
 
*This function gives the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.  
*In SYD(c,s,l,p), c 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.  
*s 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.
*l is the useful life of the asset or the number of periods that you will be depreciating the asset, p 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:  
 
*SYD is calculated as follows:  
 
<math>SYD = \frac{(c-s)*(l-p+1)*2}{(l)(l+1)}</math>
 
<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  
 
*This function will give the result as error when  
   1. Any one of the argument is nonnumeric.
+
   1.Any one of the argument is nonnumeric.
   2.s<0  
+
   2. SalvageValue<0  
   3.l or p<=0
+
   3. LifeValue or Period<=0
   4.p is greater than l.
+
   4. Period is greater than l.
  
 
==Examples==
 
==Examples==
Line 23: Line 25:
 
#=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
 +
 +
==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 ]]

Latest revision as of 18:07, 30 July 2018

SYD (Cost,SalvageValue,LifeValue,Period)


  • is the initial cost.
  • is the salvage which is the value of the asset.
  • is the life of the number of periods.
  • 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 , is the original cost of the asset.
  • is the salvage value after the asset has been fully depreciated.
  • is the useful life of the asset or the number of periods that you will be depreciating the asset, is the period that you wish to calculate the depreciation for.
  • SYD is calculated as follows:

where is the cost, is the salvage, is the period and 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

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

Related Videos

SYD

See Also

References