Skip to Content

AMORLINC

Returns the depreciation for each accounting period

Syntax

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

Parameters

  • cost: Required. The cost of the asset
  • date_purchased: Required. The date of the purchase
  • first_period: Required. The date of the end of the first period
  • salvage: Required. The salvage value
  • period: Required. The period
  • rate: Required. The rate of depreciation
  • basis: Optional. The year basis

Example

=AMORLINC(2400, "08/19/2024", "12/31/2024", 300, 1, 0.15, 1)
Returns: NumberSince: Excel 2003