ACCRINTM function
ACCRINTM calculates the interest earned from issue to maturity on a bond or note that pays all its interest in one lump at the end. It suits discount notes and short-term paper.
Example
Read it as a sentence: for a $1,000 bond paying 5% a year, issued January 1, 2024 and settled July 1, 2024, find the interest built up by the settlement date.
A
B
C
D
1
25
2
3
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
Arguments in [square brackets] are optional.
-
issue(required) - Date the security was issued.
-
settlement(required) - Maturity date, when interest is paid.
-
rate(required) - Annual interest rate.
-
par(required) - Face value; defaults to 1,000 if omitted.
-
basis(optional) - Day-count convention: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.
Returns: Total interest accrued on a security that pays everything at maturity.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0.1,1000,3) | 20.54794521 | Typical |
=ACCRINTM(DATE(2024,4,1),DATE(2024,4,1),0.1,1000) | 0 | Issue = settlement |
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0.1,1000,0) | 20.55555556 | Basis 0 |
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0.1,1000,1) | 20.49180328 | Basis 1 |
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0.1,1000,2) | 20.83333333 | Basis 2 |
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0.1,1000,4) | 20.55555556 | Basis 4 |
=ACCRINTM(DATE(2024,6,15),DATE(2024,4,1),0.1,1000) | #NUM! | Issue after settlement |
=ACCRINTM(DATE(2024,4,1),DATE(2024,6,15),0,1000) | #NUM! | Rate 0 |
Watch out for
- The second date is the maturity date, even though the argument is called settlement.
- Pass dates with DATE() or cell references; text dates can misbehave and invalid dates return #VALUE!.
Where it works
- Excel
- ACCRINTM is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .