SheetFX
Back to Functions

AMORLINC

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

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

AMORLINC

The AMORLINC function in Google Sheets returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.

Function Syntax and Parameters

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

Parameters:

  • cost: The initial cost of the asset.
  • purchase_date: The date when the asset was purchased.
  • first_period_end: The end date of the first period.
  • salvage: The salvage value at the end of the asset's life.
  • period: The number of periods to calculate depreciation.
  • rate: The rate of depreciation.
  • [basis]: [Optional] The day count basis to use.

Use Cases and Scenarios

  1. Accounting: Calculate the prorated depreciation based on the purchase date and period.
  2. Asset Management: Determine the depreciation amount for accounting purposes.
  3. Financial Planning: Calculate the impact of depreciation on overall financial statements.

Related Functions

  • ACCRINT: Calculates the accrued interest for a security with periodic interest payments.
  • ACCRINTM: Calculates the accrued interest for a security that pays interest at maturity.

That's the .mdx content for the AMORLINC function.