Returns the depreciation for an accounting period. If the asset was purchased during the period, returns the prorated depreciation. This provision is for users of the French accounting system.
AMORLINC(cost: Number, purchasedate: String, firstperiodend: String, salvage: Number, period: Number, rate: Number, basis: String = us_nasd) => Number
The asset's purchase cost
The date the asset was purchased
First period end
The end date of the first period.
The asset's value at the end of its life (i.e. its salvage value)
The period for which to calculate depreciation
The annual depreciation rate.
Method to use for counting days per month/year:
date1 = "1969-07-20T13:06:15+03:00"date2 = "1969-08-20T13:06:15+03:00"date3 = "2000-07-20T13:06:15+03:00"date4 = "2002-08-20T13:06:15+03:00"