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

Want to practice ACCRINT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

Arguments

ArgumentRequired?What it does
issueYesThe date the security was first issued.
first_interestYesThe first coupon date.
settlementYesThe date the buyer takes ownership (after the issue date).
rateYesThe annual coupon rate.
parYesThe face value.
frequencyYesCoupon payments per year: 1 = annual, 2 = semiannual, 4 = quarterly.
basisNoDay count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.
calc_methodNoWhen 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.

B8fx=ACCRINT(B1,B2,B3,B4,B5,B6,B7)
AB
1Issue11/15/2025
2First coupon5/15/2026
3Settlement3/15/2026
4Rate5%
5Par10000
6Frequency2
7Basis0
8Accrued interest166.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.

B2fx=ACCRINT(DATE(2025,1,15),DATE(2025,5,15),DATE(2026,3,15),5%,10000,2,0,FALSE)
AB
1calc_methodAccrued
2FALSE (since last coupon)166.67
3TRUE (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.
Kyle Stott

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.