Skip to content
Excel

ACCRINTM function in Excel

Returns the accrued interest for a security that pays interest at maturity

=ACCRINTM(issue, settlement, rate, par, [basis])

ACCRINTM syntax and parameters

Five arguments, four required.

  • issueanyRequired

    The security's issue date.

  • settlementanyRequired

    The security's maturity date.

  • ratenumberRequired

    The security's annual coupon rate.

  • parnumberRequired

    The security's par value. If you omit par, ACCRINTM uses $1,000.

  • basisanyOptional

    The type of day count basis to use.

ACCRINTM examples

Formulas you'll actually reuse.

  1. Interest accrued on a $10,000 note that pays everything at maturity — six months at 4%:

    =ACCRINTM(DATE(2026, 1, 1), DATE(2026, 7, 1), 4%, 10000, 0)

    Result200

  2. The same from cells on an actual/actual basis:

    =ACCRINTM(B2, C2, D2, E2, 1)

ACCRINTM in Google Sheets

Same name — your formula ports as-is.

Try ACCRINTM in the playground

Edit the example — nothing to install.

Preloaded with the ACCRINTM formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.