Returns the prorated linear depreciation of an asset for each accounting period..
| Name | Type | Description |
| arg1 | any | Is the cost of the asset. |
| arg2 | any | Is the date the asset is purchased. |
| arg3 | any | Is the date of the end of the first period. |
| arg4 | any | Is the salvage value at the end of life of the asset.. |
| arg5 | any | Is the period. |
| arg6 | any | Is the rate of depreciation. |
| arg7 | any | Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.AMORLINC(3500, "1/1/2018", "3/1/2018", 500, 1, 0.25, 1));
builder.SaveFile("xlsx", "AMORLINC.xlsx");
builder.CloseFile();