writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + + − + − + − + − + − + − + − +
no edit summary
<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.
==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(c,s,l,p)</math>, <math>c</math> 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.
*<math>s</math> 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.
*<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.
*<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==