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 $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 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.

See Also

• DURATION
• ACCRINT

References

• Depreciation
• Day Count Basis