AMORLINC(arg1, arg2, arg3, arg4, arg5, arg6, arg7) → { number | string | boolean }

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


number | string | boolean