Manuals/calci/AMORLINC

AMORLINC(cost, DP, FP, 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 DP} 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 FP} 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
• 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() calculates the depreciation for each accounting period.

Description

• 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 DP} > $FP$, 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 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).
• 'basis' value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of 'basis' values:

Basis	Description
0	360 days (NASD)
1	Actual
3	365 days in a year
4	360 days in a year (European)

• If '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