Documentation/Calc Functions/AMORDEGRC

Function name:
AMORDEGRC

Category:
Financial Analysis

Summary:
Calculates the depreciation for a period using degressive depreciation, applying a depreciation factor that is dependent on the lifetime of the asset.

Syntax:
AMORDEGRC(Cost; Date Purchased; First Period; Salvage; Period; Rate[; Basis])

Returns:
Returns a non-negative real number.

Arguments:
Cost is a positive real number or a reference to the cell containing that number which is the acquisition cost.

DatePurchased is a date or a reference to a cell containing that date which is the date of acquisition.

FirstPeriod is a date or a reference to a cell containing that date which is the end date of the first depreciation period.

Salvage is a positive real number or a reference to the cell containing that number which is the salvage value of the asset at the end of the depreciable life.

Period is a non-negative integer or a reference to the cell containing that number which is the settlement period to be considered. The value of 0 represents the period from the purchase date to the end of the first period. A value of 1 is the next year, and so on.

Rate is a positive real number (expressed as a percentage or a fraction) or a reference to the cell containing that number which is the rate of depreciation.


 * If either of DatePurchased or FirstPeriod are not valid dates then the function returns a value (#VALUE!) error. For more details about dates visit help.
 * If either Rate or Cost is less than or equal to 0 then the function will return an error value.
 * If either Salvage or Period is less than 0 then the function will return an error value.
 * If Period is a non-integer non-negative real value, then it is truncated to an integer.
 * If the DatePurchased date is after the FirstPeriod date then the function returns an error value.
 * If Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.
 * After truncation if Basis is any number except 0,1,2,3,4 or missing,then the function will return an error value.

Additional details:

 * The coefficients for depreciation for AMORDEGRC are:

Here for the Life of assets is (1/Rate).
 * If the asset was purchased in the middle of the period, the depreciation is factored accordingly. Hence for period 0, the deprecation is equivalent to ROUND(Depreciation Factor * Cost * Rate * YEARFRAC (DatePurchased; FirstPeriod; Basis)). And for period 1 the depreciation is equivalent to ROUND(Depreciation Factor * Rate * (Cost – Depreciation from Previous Period)). And so on…
 * The function will not depreciate beyond the point at which the total depreciation is greater than Cost – Salvage.
 * For more details on amortization, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/AMORLINC AMORLINC]

ODF standard:
None

Equivalent Excel functions:
AMORDEGRC