Manuals/calci/AMORLINC
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
- is the accounting 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 Rate} 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 accounting periodDescription
- 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 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