In this article
ACCRINTM returns interest accrued on a security that pays all its interest at maturity, such as a cumulative fixed deposit or a zero-coupon-style note.
Advertisement
Syntax
=ACCRINTM(issue, settlement, rate, [par], [basis])| Argument | What it means |
|---|---|
issue |
Issue date |
settlement |
Maturity date |
rate |
Annual coupon rate |
par |
Face value |
basis |
Day count (0 = 30/360, 3 = actual/365) |
Examples
Example 1
=ROUND(ACCRINTM(DATE(2025,4,1),DATE(2026,3,31),B2,A2,3),2)Result: 7479.45. See the worked example table below for more cases.
ACCRINTM in practice
Where you will use it
- Interest on a cumulative deposit at maturity
- Commercial paper with interest at maturity
- Accrual entries
Worked example
| Par | Rate | Formula | Result |
|---|---|---|---|
| 100000 | 0.075 | =ROUND(ACCRINTM(DATE(2025,4,1),DATE(2026,3,31),B2,A2,3),2) | 7479.45 |
| 500000 | 0.07 | =ROUND(ACCRINTM(DATE(2025,4,1),DATE(2026,3,31),B3,A3,3),2) | 34904.11 |
| 100000 | 0.09 | =ROUND(ACCRINTM(DATE(2025,4,1),DATE(2026,3,31),B4,A4,3),2) | 8975.34 |
Results calculated in Excel. One-year instrument, 1 Apr 2025 to 31 Mar 2026, basis 3.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Settlement before issue | #NUM! |
| Basis | 3 = actual/365 for Indian instruments |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong