WorksheetFunction.AmorDegrc (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 method is similar to AmorLinc, except that a depreciation coefficient is applied in the calculation depending on the life of the assets. The following table describes the values used in Arg7.

AmorDegrc (Arg1, Arg2, ..., Arg7)

Dim dblAmorDegrc As Double
dblAmorDegrc = WorksheetFunction.AmorDegrc(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