AMORDEGRC

AMORDEGRC

Synopsis

AMORDEGRC(cost,purchase_date,first_period,salvage,period,rate[,basis])

Description

AMORDEGRC: Calculates depreciation for each accounting period using French accounting conventions. Assets purchased in the middle of a period take prorated depreciation into account. This is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.

Named for AMORtissement DEGRessif Comptabilite

cost The value of the asset.

purchase_date The date the asset was purchased.

first_period The end of the first period.

salvage Asset value at maturity.

period The length of accounting periods.

rate rate of depreciation as a percentage.

basis is the type of day counting system you want to use:

0 US 30/360

1 actual days/actual days

2 actual days/360

3 actual days/365

4 European 30/360

  • If basis is omitted, US 30/360 is applied.
  • If basis is not in between 0 and 4, #NUM! error is returned.

Examples

AMORDEGRC(2400,DATE(1998,8,19),DATE(1998,12,30),300,1,0.14,1) = 733

See also

AMORLINC.