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).

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

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 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.
* 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!


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top