Excel ACCRINT Function
The ACCRINT function returns the accrued interest on periodic interest-paying securities.
The ACCRINT function returns a numeric value.
- ACCRINT will return the #VALUE! error if issue, first_interest or settlement is not a valid date.
- ACCRINT will return the #NUM! error if:
- rate ≤ 0 or par ≤ 0;
- frequency is not the number 1, 2, or 4;
- basis < 0 or basis > 4;
- issue ≥ settlement.
- Issue, first_interest, settlement, frequency, 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 periodic interest, please copy or enter the formula below in a blank cell, and press Enter to get the result:
√ Note: The calc_method argument is omitted in this formula. So, the function will calculate the accrued interest from the issue date to settlement date.
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, to calculate the accrued interest from the first interest date to settlement date, you should add the calc_method argument and set it as FALSE: