Difference between revisions of "Manuals/calci/SYD"
| 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
- 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SYD(c,s,l,p)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle c} is the original cost of the asset.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s} is the salvage value after the asset has been fully depreciated.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle l} is the useful life of the asset or the number of periods that you will be depreciating the asset, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle p} is the period that you wish to calculate the depreciation for.
- SYD is calculated as follows:
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SYD = \frac{(c-s)*(l-p+1)*2}{(l)(l+1)}} where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle c} is the cost,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s} is the salvage,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle p} is the period and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle l} 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