AMORLINC

Function Type: Financial

Description:

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.

Example:

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

Back to Learn Excel->