ACCRINT Function
Returns the interest built up on a bond since its last coupon.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Accrued interest
Overview
When you buy a bond between coupon dates you pay the seller the interest they've earned so far. ACCRINT calculates it.
par is the face value — enter 10000 for a $10,000 bond and the result is in dollars.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| issue | Yes | The date the security was first issued. |
| first_interest | Yes | The first coupon date. |
| settlement | Yes | The date the buyer takes ownership (after the issue date). |
| rate | Yes | The annual coupon rate. |
| par | Yes | The face value. |
| frequency | Yes | Coupon payments per year: 1 = annual, 2 = semiannual, 4 = quarterly. |
| basis | No | Day count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360. |
| calc_method | No | When settlement is after first_interest: TRUE or omitted = accrue from issue, FALSE = from the last coupon. |
Examples
Example 1 — Interest owed to the seller
Northstar buys $10,000 of a 5% semiannual bond issued 11/15/2025 (first coupon 5/15/2026), settling 3/15/2026.
| A | B | |
|---|---|---|
| 1 | Issue | 11/15/2025 |
| 2 | First coupon | 5/15/2026 |
| 3 | Settlement | 3/15/2026 |
| 4 | Rate | 5% |
| 5 | Par | 10000 |
| 6 | Frequency | 2 |
| 7 | Basis | 0 |
| 8 | Accrued interest | 166.67 |
Four months of 5% on $10,000.
Example 2 — calc_method on an older bond
A bond issued 1/15/2025 with its first coupon on 5/15/2025. By 3/15/2026 several coupons have been paid.
| A | B | |
|---|---|---|
| 1 | calc_method | Accrued |
| 2 | FALSE (since last coupon) | 166.67 |
| 3 | TRUE (since issue) | 583.33 |
For the amount a buyer pays, use FALSE — TRUE totals everything since issue.
Common mistakes
- #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.
- The accrued figure is far too big. calc_method defaults to TRUE (from issue). Set FALSE for interest since the last coupon.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: ACCRINTM, COUPDAYBS, PRICE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.