Function Type: Financial


Returns the depreciation for each accounting period

Function Structure:

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

Argument Breakdown:

cost – The cost of the asset.

date_purchased – The date of the purchase of the asset.

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

salvage – The salvage value at the end of the life of the asset.

period – The period.

rate – The rate of depreciation.

basis – The year basis to be used.


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: