AMORLINC
function AMORLINC(
arg1: any = null,
arg2: any = null,
arg3: any = null,
arg4: any = null,
arg5: any = null,
arg6: any = null,
arg7: any = null,
): number | string | booleanDescription
Returns the prorated linear depreciation of an asset for each accounting period..
Parameters
- arg1
anydefault: null Is the cost of the asset.
- arg2
anydefault: null Is the date the asset is purchased.
- arg3
anydefault: null Is the date of the end of the first period.
- arg4
anydefault: null Is the salvage value at the end of life of the asset..
- arg5
anydefault: null Is the period.
- arg6
anydefault: null Is the rate of depreciation.
- arg7
anydefault: null Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days..
Returns
number | string | booleanTry It
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));