deepcalc
DocsACCRINTM

ACCRINTM

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

Accrued interest for a security paying at maturity.

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

Examples

=ACCRINTM(DATE(2025,3,1), DATE(2026,1,15), 0.05, 1000)
Result 43.611111111111114

Syntax

ACCRINTM(issue, settlement, rate, [par], [basis])
issue
number required
settlement
number required
rate
number required
par
number optional
basis
number optional

Errors

#NUM!
=ACCRINTM(2, 2, 0.05)
ACCRINTAccrued interest for a security paying periodic interest. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement. COUPDAYSNCDays from settlement to the next coupon date.