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

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

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

* 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.office.com.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.

 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!


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited