Difference between revisions of "Manuals/calci/SYD"
Jump to navigation
Jump to search
(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-...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SYD(c,s,l,p)'''</div><br/> |
| + | *<math>c </math> is the initial cost. | ||
| + | *<math> s </math> is the salvage which is the value of the asset. | ||
| + | *<math> l </math> is the life of the number of periods. | ||
| + | *<math> p </math> 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 SYD(c,s,l,p), c is the original cost of the asset. | ||
| + | *s 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. | ||
| + | *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. | ||
| + | *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 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:22, 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.
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 SYD(c,s,l,p), c is the original cost of the asset.
- s 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.
- SYD is calculated as follows:
where is the cost, is the salvage, is the period and is the life.
where - 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