AMORDEGRC

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

Returns the depreciation of an asset in a single period (declining-balance method).

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 = 30/360 (default, US convention) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = 30/360 (European convention)

REMARKS

* For an illustrated example refer to the Depreciation page.
* The name of this function comes from the two words amortization (which is depreciation) and degressive (which is declining).
* This function is used with the French accounting system.
* 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 years, then #NUM! is returned.
* If the life of the asset is between 1 and 2 years, then #NUM! is returned.
* If the life of the asset is between 2 and 3 years, then #NUM! is returned.
* If the life of the asset is between 3 and 4 years, then the coefficient is 1.5.
* If the life of the asset is between 4 and 5 years, then #NUM! is returned.
* 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.
* You can use the AMORLINC function return the depreciation of an asset in a single period (linear model)
* You can use the DB function to return the depreciation of an asset in a single period (declining balance method).
* You can use the DDB function to return the depreciation of an asset in a single period (double-declining balance method).
* You can use the SLN function to return the depreciation of an asset in a single period (straight-line method).
* You can use the SYD function to return the depreciation of an asset in a single period (sum-of-years digits method).
* You can use the VDB function to return the depreciation of an asset in a single period (variable-declining balance method).
* 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!