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.
Entering dates
In Excel,dates are serial numbers.
To enter valid dates directly inside a function, you’re free to 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/360 basis.
Thisarticle on wikipediaprovides a detailed explanation of available conventions.
