Manuals/calci/AMORLINC

AMORLINC(cost, DP, FP, salvage, period, rate, basis)

• where, $cost$ is the cost of the asset
• $DP$ is the date of purchase of asset
• $FP$ is the end of first period
• $salvage$ is the salvage value at the end of life of asset
• $period$ is the accounting period
• $rate$ is the rate of depreciation
• $basis$ is the year basis to be used

AMORLINC() calculates the depreciation for each accounting period.

Description

• The function calculates the decrease in value of asset for the mentioned period.
• If $DP$ > $FP$, Calci displays #N/A error message.
• $salvage$ also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
• If $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 DURATION 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.

See Also

• DURATION
• ACCRINT

References

• Depreciation
• Day Count Basis