Explainry Tutorials to Expert in IT

ACCRINTM function in Excel


ACCRINTM function returns the accrued interest of a security (usually a bond) that pays interest at maturity.


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

issue – Required. The issue date of the security.

settlement – Required. The date on which the security matured.

rate – Required. The rate of return (annual coupon rate) of the security.

par – Required. The par value of the security. If omitted, Excel uses $1,000.

[basis] – The optional argument that specifies the type of days count.

Basis Day count basis
0 or omitted US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360




Function Errors

Error If
#VALUE! When dates are not valid
#NUM! Rate ≤ 0 or par ≤ 0
Basis < 0 or basis > 4
Issue date ≥ settlement date

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved