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:
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.