AMORLINC
Syntax:
AMORLINC ( cost , date-purchased , first-period , salvage , period ,rate [ , [ basis ] ] )
Description: Computes the depreciation for each accounting period. (This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.)
Arguments:
Name |
Type |
Description |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
cost |
number |
The cost of the asset. |
||||||||||||
date-purchased |
number |
The date of the purchase of the asset. |
||||||||||||
first-period |
number |
The date of the end of the first period. |
||||||||||||
salvage |
number |
The salvage value at the end of the life of the asset. |
||||||||||||
period |
number |
The period. |
||||||||||||
rate |
number |
The rate of depreciation. |
||||||||||||
basis |
number |
The truncated integer type of day count basis to use, as follows:
|
Return Type and Value: number – The depreciation for each accounting period.
However, if:
cost, salvage, period, or rate < 0,
#NUM!
is returned.date-purchased or first-period is out of range for the current date base value,
#NUM!
is returned.basis < 0 or basis > 4,
#NUM!
is returned.