AMORLINC function

description:

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

 

syntax:

AMORLINC( costdate_purchasedfirst_periodsalvageperiodrate[basis] )

 

required arguments:

cost The cost of the asset.
date_purchased The date of the purchase of the asset.
first_period The date of the end of the first period.
salvage The salvage value at the end of the life of the asset.
period The period.
rate The rate of depreciation.

 

optional arguments:

[basis] The type of day count basis to use. You use 0 for U.S. bonds.