Excel ACCRINTM Function
The ACCRINTM function returns the accrued interest for a security that pays interest at maturity.
The ACCRINTM function returns a numeric value.
- ACCRINTM will return the #VALUE! error if issue or settlement is not a valid date.
- ACCRINTM will return the #NUM! error if:
- rate ≤ 0 or par ≤ 0;
- basis < 0 or basis > 4;
- issue ≥ settlement.
- issue, settlement and basis are truncated to integers.
- The result of the formula is a numeric value. To add a currency symbol to it, please apply the Format Cells feature.
As the information shown in the below table, to get the accrued interest for the security that pays interest at maturity, please copy or enter the formula below in a blank cell, and press Enter to get the result:
If a bond has the same information above except that the settlement date is October 1, 2021, you can add a DATE function to replace the C5 in the formula:
If a treasury bond has the same information above except that the day count basis is Actual/360, you should change the basis argument to 2: