AMORDEGRC function
The AMORDEGRC function is one of the financial functions. It is used to calculate the depreciation of an asset for each accounting period using a degressive depreciation method.
Syntax
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
The AMORDEGRC function has the following arguments:
| Argument | Description |
|---|---|
| cost | The cost of the asset. |
| date_purchased | The date when asset is purchased. |
| first_period | The date when the first period ends. |
| salvage | The salvage value of the asset at the end of its lifetime. |
| period | The period you wish to calculate depreciation for. |
| rate | The rate of depreciation. |
| basis | The day count basis to use, a numeric value greater than or equal to 0, but less than or equal to 4. It is an optional argument. The possible values are listed in the table below. |
The basis argument can be one of the following:
| Numeric value | Count basis |
|---|---|
| 0 | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
Notes
Dates must be entered by using the DATE function.
How to apply the AMORDEGRC function.
Examples
