Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .