ACCRINTM

Calculates interest on investment that pays out interest on maturity basis

Syntax of Excel ACCRINTM formula:
=ACCRINTM(issue, settlement, rate, par, [basis])

In words:
=Calculate interest at maturity of the investment with this(issue date, maturity date, rate of interest, face value, [day count basis])

Examples of Excel ACCRINTM formula

Consider the following data:

excel accrintm function

To determine the accrued interest we will use this formula in above situation:

=ACCRINTM(B1,B2,B3,B4,B5) and it will return $411.1475 as interest at maturity.