Required. The date of the end of the first period.
Required. The salvage value.
Required. The rate of depreciation.
Required. The year count.
Life of asset
Between 3 and 4 years
Between 5 and 6 years
More than 6 years
The depreciation rate will grow to 50 percent for the period before the last period and grows to 100 percent for the last period.
The prorated depreciation is taken into account if an asset is purchased in the middle of the accounting period. There is a depreciation coefficient taken into account in the calculation based on the life of the assets.
This function will calculate the depreciation for all periods except the last period of the life of the assets or if the cumulated value of depreciation is greater than the cost of the assets minus the salvage value.
Keep in mind to use the DATE function if you enter dates in the function instead of using cell references.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Financial'
The AMORDEGRC function function is one of many functions in the 'Financial' category.