AMORDEGRC

Summary

This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets.

Syntax

AMORDEGRC(cost,datepurchased,firstperiod,salvage,period,drate,basis)

Arguments

This function has these arguments:

Argument	Description
cost	Cost of the asset
datepurchased	Purchase date of the asset
firstperiod	End date of the first period
salvage	Salvage value at the end of the life of the asset
period	Accounting period
drate	Rate of depreciation
basis	[Optional] Integer representing the basis for day count (Refer to Day Count Basis)

Remarks

This function returns the depreciation until the last period of the asset life or until the total value of depreciation is greater than the cost of the assets minus the salvage value. The depreciation coefficients are:

Life of assets	Depreciation Coefficient
Between 3 and 4 years	1.5
Between 5 and 6 years	2
More than 6 years	2.5

The depreciation rate will grow to 50 percent for the period proceeding the last period and will grow to 100 percent for the last period. If the life of assets is between 0 (zero) and 1, 1 and 2, 2 and 3, or 4 and 5, the #NUM! error value is returned.

This function differs from AMORLINC, which does not apply a depreciation coefficient in the calculation depending on the life of the assets.

Data Types

Accepts numeric and DateTime object data. Returns numeric data.

Examples

AMORDEGRC(B1,B2,B3,B4,B5,B6,B7)

AMORDEGRC(2800,DATE(2003,9,4),DATE(2006,12,31),200,1,0.02,1) gives the result 117