This function is provided for the French accounting system.

Depreciation is prorated based on the date an asset is purchased in the first period.

The salvage value is $1000, and the basis is European 30/360.

Excel AMORDEGRC function

To enter valid dates directly inside a function, you might use theDATE function.

Basis

Thebasisargument controls how days are counted.

The DISC function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.

Thisarticle on wikipediaprovides a detailed explanation of available conventions.