AMORLINC Function in Google Sheets

Calculate the prorated linear depreciation of an asset using the AMORLINC function.

AMORLINC Function

The AMORLINC function in Google Sheets calculates the prorated linear depreciation of an asset for each accounting period.

Syntax

AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
  • cost: The initial cost of the asset.
  • purchase_date: The purchase date of the asset.
  • first_period_end: The end date of the first period.
  • salvage: The salvage value of the asset at the end of depreciation.
  • period: The period for which the depreciation is calculated.
  • rate: The depreciation rate.
  • basis: (Optional) The day count basis to use. Default is 0 (actual/actual).

Examples

  1. Basic Depreciation Calculation

Calculate depreciation for an asset purchased on January 1, 2020, with a cost of $1000, and a salvage value of $100:

=AMORLINC(1000, "1/1/2020", "12/31/2020", 100, 1, 0.1)

This will output the depreciation for the first period.

  1. Depreciation with Different Basis

Calculate using a 30/360 basis:

=AMORLINC(1000, "1/1/2020", "12/31/2020", 100, 1, 0.1, 1)

This will output the depreciation considering the 30/360 basis.

Notes

  • The function is used for prorating the depreciation when the period is less than a year.
  • Different bases can be used to adjust the depreciation calculation.
  • SLN: Calculate straight-line depreciation of an asset.
  • DB: Calculate depreciation at an accelerated rate using the declining balance method.