Difference between revisions of "Manuals/calci/SYD"
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
- =SYD(25000,2800,7,1) = 5550
- =SYD(50000,9000,15,3) = 4441.6666667
- =SYD(42500,6850,6,3) = 6790.47619047