Difference between revisions of "Manuals/calci/SYD"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''SYD( | + | <div style="font-size:30px">'''SYD (Cost,SalvageValue,LifeValue,Period) '''</div><br/> |
− | *<math> | + | |
− | *<math> | + | *<math>Cost </math> is the initial cost. |
− | *<math> | + | *<math> SalvageValue </math> is the salvage which is the value of the asset. |
− | *<math> | + | *<math> LifeValue </math> is the life of the number of periods. |
+ | *<math> Period </math> is the number of periods. | ||
==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 <math>SYD( | + | *In <math>SYD (Cost,SalvageValue,LifeValue,Period) </math>, <math>Cost</math> is the original cost of the asset. |
− | *<math> | + | *<math>SalvageValue</math> is the salvage value after the asset has been fully depreciated. |
− | *<math> | + | *<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> | + | 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. | + | 2. SalvageValue<0 |
− | 3. | + | 3. LifeValue or Period<=0 |
− | 4. | + | 4. Period is greater than l. |
==Examples== | ==Examples== |
Revision as of 18:06, 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.
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
- =SYD(25000,2800,7,1) = 5550
- =SYD(50000,9000,15,3) = 4441.6666667
- =SYD(42500,6850,6,3) = 6790.47619047
Related Videos
See Also
References