AMORLINC

Depreciation for accounting period

Description

Returns the depreciation for an accounting period. If the asset was purchased during the period, returns the prorated depreciation. This provision is for users of the French accounting system.

Function signature

AMORLINC(cost: Number, purchasedate: String, firstperiodend: String, salvage: Number, period: Number, rate: Number, basis: String = us_nasd) => Number

Parameter

Description

Cost

The asset's purchase cost

Purchase date

The date the asset was purchased

First period end

The end date of the first period.

Salvage

The asset's value at the end of its life (i.e. its salvage value)

Period

The period for which to calculate depreciation

Rate

The annual depreciation rate.

basis

Method to use for counting days per month/year:

  • `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).

  • `actual`: Actual number of days per month/year.

  • `actual_360`: 360 day year, actual number of days per month.

  • `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.

  • `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.

Examples

date1 = "1969-07-20T13:06:15+03:00"
date2 = "1969-08-20T13:06:15+03:00"
date3 = "2000-07-20T13:06:15+03:00"
date4 = "2002-08-20T13:06:15+03:00"

Formula

Return value

AMORLINC(1000, date1, date2, 100, 1.9, 0.15)

150

AMORLINC(2000, date3, date4, 300, 1.9, 0.12, "actual")

240