WorksheetFunction.AmorLinc (Excel)

Returns the depreciation for each accounting period. This function is provided for the French accounting system.

If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The following table describes values used for Arg7.

AmorLinc (Arg1, Arg2, ..., Arg7)

Dim dblAmorLinc As Double
dblAmorLinc = WorksheetFunction.AmorLinc(Arg1:=, Arg2:=, Arg3:=, Arg4:=, Arg5:=, Arg6:=)


Arg1, Arg2, ..., Arg7

Arg1 - The cost of the asset

Arg2 - The date of the purchase of the asset

Arg3 - The date of the end of the first period

Arg4 - The salvage value at the end of the life of the asset

Arg5 - The period

Arg6 - The rate of depreciation

Arg7 - The year basis to be used