AMORLINC(cost,purchase_date,first_period,salvage,period,rate[,basis])
AMORLINC: Calculates depreciation for each accounting period using French accounting conventions. Assets purchased in the middle of a period take prorated depreciation into account.
Named for AMORtissement LINeaire Comptabilite.
cost The value of the asset.
purchase_date The date the asset was purchased.
first_period The end of the first period.
salvage Asset value at maturity.
period The length of accounting periods.
rate rate of depreciation as a percentage.
basis is the type of day counting system you want to use:
0 US 30/360
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360
AMORLINC(2400,DATE(1998,8,19),DATE(1998,12,31),300,1,0.15,1) = 360