How to Use AMORLINC() in Google Sheets

Description

Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period..

How To Actually Use AMORLINC() in Sheets

AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])

Try AMORLINC yourself

In cells A1 to A6, input the cost, purchase date, first period end, salvage value, period, and rate of an asset. Use the AMORLINC formula in cell B1 to calculate the depreciation for the first period.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for AMORLINC(). Click through to watch.

Browse more tutorials

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Unlock these tutorials

Learn more about the AMORLINC() formula:

Generate a AMORLINC() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses AMORLINC(). 2 free AI generations, no signup. Members get unlimited use.

Generate a AMORLINC() formula

How to Use AMORLINC() in Google Sheets

Try AMORLINC yourself

More related tutorials

What is this Ampersand Doing in Google Sheets?