Description
AmorDEGRC returns the depreciation of an asset in the accounting year specified.
Overloads
AmorDEGRC (cost, purchaseDate, firstPeriodEndDate, salvage, period, rate)
AmorDEGRC (cost, purchaseDate, firstPeriodEndDate, salvage, period, rate, basis)
Arguments
cost is a positive number or currency specifying the initial cost of the asset.
purchaseDate is a
Date or
DateTime specifying when the asset was purchased.
firstPeriodEndDate is a
Date or
DateTime specifying the end of the first period. This date must be after the purchase date.
salvage is a non-negative number or currency specifying the value of the asset after its useful life. This number must be equal to or less than the cost of the asset.
period is a non-negative number specifying which period the depreciation should be calculated for.
rate specifies the rate at which the asset depreciates.
basis is an optional number specifying the day basis system to use. The following types are supported:
0 - American 30/360 (default)
Action
AmorDEGRC returns the depreciation of an asset in the accounting year specified. The accounting years are aligned with the firstPeriodEndDate. A depreciation factor is applied to the rate depending on the lifetime (1/rate) of the asset. The answer is rounded to the nearest whole number.
| depreciation factor applied |
---|
| |
greater than 4 but less than 6 | |
greater than or equal to 6 | |
Examples
Suppose a machine is purchased for $1500 on April 15, 2000. The machine can be sold for scrap at a price of $250 and depreciates at 10% per year. If the accounting periods start on January 1st of each year, then the first period after the purchase date is January 1, 2001. An actual/actual basis is used.
AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,0,.1,1)
Returns $267 as the depreciation for the period of time between April 15, 2000 and December 31, 2000. Since the lifetime is ten years, the depreciation rate is 2.5 x 0.1 = 0.25.
AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,1,.1,1)
Returns $308 as the depreciation during the first full year.
AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,6,.1,1)
Returns $43 as the depreciation for the sixth full year.
Comments
This function is similar to the Excel function of the same name.