Difference between revisions of "Manuals/calci/AMORLINC"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =AMORLINC( | + | <div style="font-size:25px">'''AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)'''</div><br/> |
| − | *where, <math> | + | *where, <math>Cost</math> is the cost of the asset |
| − | *<math> | + | *<math>DatePurchased</math> is the date of purchase of asset |
| − | *<math> | + | *<math>FirstPeriod</math> is the end of first period |
| − | *<math> | + | *<math>Salvage</math> is the salvage value at the end of life of asset |
| − | *<math> | + | *<math>Period</math> is the accounting period |
| − | *<math> | + | *<math>Rate</math> is the rate of depreciation |
| − | *<math> | + | *<math>Basis</math> is the year basis to be used |
| − | + | **AMORLINC(), returns the depreciation for each accounting period. | |
| − | AMORLINC() | ||
== Description == | == Description == | ||
*The function calculates the decrease in value of asset for the mentioned period. | *The function calculates the decrease in value of asset for the mentioned period. | ||
| − | *If <math> | + | *If <math>DatePurchased</math> > <math>FirstPeriod</math>, Calci displays #N/A error message. |
| − | *<math> | + | *<math>Salvage</math> also called as 'residual value' is the remaining value of an asset after it has been fully depreciated. |
| − | *If <math> | + | *If <math>Rate</math> is <=0, Calci displays #N/A error message. |
| − | *If <math> | + | *If <math>Period</math> is omitted, Calci assumes it as 0.5 years(6 months). |
| − | *<math> | + | *<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0. |
| − | Below table shows the use of <math> | + | Below table shows the use of <math>Basis</math> values: |
{| class="wikitable" | {| class="wikitable" | ||
| Line 34: | Line 33: | ||
|} | |} | ||
| − | *If <math> | + | *If <math>Basis</math> value is other than 0, 1, 3 or 4, Calci displays #N/A error message. |
== Examples == | == Examples == | ||
| Line 80: | Line 79: | ||
=AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result. | =AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=DQfl_5hkeYo|280|center|AMORLINC}} | ||
== See Also == | == See Also == | ||
| Line 90: | Line 93: | ||
*[http://en.wikipedia.org/wiki/Depreciation Depreciation] | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | ||
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis] | *[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 14:22, 15 November 2018
AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)
- 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 Cost} is the 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 DatePurchased} is the date of purchase of 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 FirstPeriod} is the end of first period
- 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 Salvage} is the salvage value at the end of life of 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 Period} is the accounting period
- is the rate of depreciation
- 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 Basis}
is the year basis to be used
- AMORLINC(), returns the depreciation for each accounting period.
is the rate of depreciationDescription
- The function calculates the decrease in value of asset for the mentioned period.
- If 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 DatePurchased} > 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 FirstPeriod} , Calci displays #N/A error message.
- 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 Salvage} also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
- If 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 Rate} is <=0, Calci displays #N/A error message.
- If 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 Period} is omitted, Calci assumes it as 0.5 years(6 months).
- 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 Basis} value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of 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 Basis} values:
| Basis | Description |
|---|---|
| 0 | 360 days (NASD) |
| 1 | Actual |
| 3 | 365 days in a year |
| 4 | 360 days in a year (European) |
- If 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 Basis} value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
Examples
Consider the following example that shows the use of AMORLINC function:
| 3200 | ||
| 8/19/2010 | ||
| 12/31/2010 | ||
| 250 | ||
| 1 | ||
| 18% | ||
| 1 |
=AMORLINC(A1,A2,A3,A4,A5,A6,A7) displays 576 as a result.
Related Videos
See Also
References