# AMORDEGRC

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

Returns the depreciation of an asset in a single period (straight-line, implicit coefficient).

 cost The cost of the asset. date_purchased The date the asset was purchased. first_period The date at the end of the first period. salvage The salvage value at the end of the life of the asset. period The period to calculate the depreciation. rate The rate of depreciation. basis (Optional) The type of day counting to use:0 = US 30/360 (default)1 = Actual/Actual2 = Actual/3603 = Actual/3654 = European 30/365 depreciation_coefficient 1/"rate":Between 0 and 1 = #NUM!Between 1 and 2 = #NUM!Between 2 and 3 = #NUM!Between 3 and 4 = 1.5Between 4 and 5 = #NUM!Between 5 and 6 = 2Greater than 6 = 2.5.

 REMARKS
 * This function is used with the French accounting system.* This function is identical to the AMORLINC function except that a depreciation coefficient is implicitly applied in the calculation.* The value of an asset at the end of the depreciation is also known as the salvage value.* Dates must be entered as text strings within quotation marks or as serial numbers.* If "cost" < "salvage", then #NUM! is returned.* If "basis" is left blank, then 0 is used.* If "basis" is not integer, it is truncated.* If "basis" < 0, then #NUM! is returned.* If "basis" > 4, then #NUM! is returned.* The depreciation_coefficient is calculated as (1 / "rate") and is often referred to as the life of the asset.* If the life of the asset is between 0 and 1, 1 and 2, 2 and 3, or 4 and 5, then #NUM! error value is returned.* If the life of the asset is between 3 and 4 years, the coefficient is 1.5.* If the life of the asset is between 5 and 6 years then the coefficient is 2.* If the life is the asset is greater than 6 years then the coefficient is 2.5.* The depreciation rate will grow to 50 percent for the period preceding the last period and will grow to 100 percent for the last period.* The depreciation is calculated until the last period of the life of the asset or until the cumulated value of depreciation is greater than the cost of the asset minus the salvage value.* For a working example refer to the Quant > Accounting > Depreciation page.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,1,0.15,1) = 11738 2 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,2,0.15,1) = 7336 3 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,3,0.15,1) = 4585 4 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,4,0.15,1) = 2866 5 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,5,0.15,1) = 2388 6 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15,1) = 2388 7 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15,0) = 2384 8 =AMORDEGRC(50000,"01/01/2003","31/12/2003",500,6,0.15) = 2384 9 =AMORDEGRC(50000,"01/01/2003","31/12/2003","some text",6,0.15) = #VALUE!