Calculating depreciation of assets in Excel (AMORDEGRC Function)


AMORDEGRC Function returns the depreciation of an asset for each accounting period till a useful life of an asset. The function is similar to the AMORLINC function except that a depreciation coefficient is applied in the calculation depending on the life of the asset.


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

cost – The purchased value/ cost of the asset.

date_purchased – The date of purchase of the asset.

first_period – The date of the end of the first period.

salvage – The value left after the useful life of the asset.

Period – The period over which depreciation will be calculated.

Rate – The rate of depreciation.

[basis] – The optional argument which specifies the year basis to be used:

Basis Date system
0 or omitted 360 days (NASD method)
1 Actual
3 365 days in a year
4 360 days in a year (European method)







Copyright © 2016 - 2018 | All Rights Reserved