deepcalc
DocsAMORLINC

AMORLINC

View as markdown/docs/functions/amorlinc.md Ask Claude about this pageOpens Claude with this page's address

Depreciation per period, French accounting, linear.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=AMORLINC(10000, DATE(2026,1,15), DATE(2026,9,30), 1000, 1, 0.15)
Result 1500

Syntax

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

Errors

#NUM!
=AMORLINC(2, DATE(2026,1,15), 2, 2, 2, 0.05)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement. COUPDAYSNCDays from settlement to the next coupon date.