Function Type: Financial


Returns the depreciation for each accounting period by using a depreciation coefficient

Function Structure:

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

Argument Breakdown:

cost – The cost of the asset.

date_purchased – The date that the asset was purchased.

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

salvage – The salvage value after asset has been fully depreciated.

period – The period in which to calculate the linear depreciation.

rate – The rate of depreciation.

basis – it is the type of year basis to use when calculating the depreciation. If this parameter is omitted, it assumes that the basis is set to 0.

0360 days (NASD)
3365 days (in a year)
4360 days (in a year)


If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: