Difference between revisions of "Manuals/calci/SYD"

From ZCubes Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
==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(c,s,l,p)</math>, <math>c</math> is the original cost of the asset.  
*s is the salvage value after the asset has been fully depreciated.
+
*<math>s</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>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.  
 
*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>c</math> is the cost,<math>s</math> is the salvage,<math>p</math> is the period and <math>l</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.s<0  
 
   3.l or p<=0
 
   3.l or p<=0

Revision as of 03:24, 24 February 2014

SYD(c,s,l,p)


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

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.s<0 
  3.l or p<=0
  4.p 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