Description
To calculate the accrued interest for a stock/bond or other security that pays interest at maturity
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
- Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437
- Settlement: maturity date
- rate: annual coupon rate
- par: par value of security; if blank then defaults at $1000
- [basis]: 5 types of day counts; this is optional
Basis consists of 5 options below:
![](http://dataempower.net/wp-content/uploads/2021/08/image-5.png)
Examples
Lets calculate its accrued interest at maturity. Below are the the examples and their results:
![](http://dataempower.net/wp-content/uploads/2021/09/image-7-1024x245.png)
References
Check out similar function ACCRINT(), which calculates accrued interest with periodic interest.