Navigation:  Formula Reference > Spreadsheet Formula Functions >

AMORDEGRC

Previous pageReturn to chapter overviewNext page

 

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