AMORDEGRC

Function Type: Financial

Description:

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.

ValueExplanation
0360 days (NASD)
1Actual
3365 days (in a year)
4360 days (in a year)

Example:

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:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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: