Related Function:

The ACCRINTM function returns the accrued interest for a security that pays interest at maturity. 




Argument Description
issue The security’s issue date
settlement The security’s maturity date
rate The security’s annual coupon rate
par The security’s par value. If you omit par, ACCRINTM uses $1,000
[basis] Optional. Defines the day count basis to be used in the calculation

  [basis] Day Count Basis
  0 (or omitted) US (NASD) 30/360
  1 actual/actual
  2 actual/360
  3 actual/365
  4 European 30/360

The financial day count basis rules are explained in detail on the Wikipedia Day Count Convention page

Note: The issue and settlement dates should be input as either:

  • References to cells containing dates, or
  • Dates returned from formulas

If you attempt to input these date arguments as text, Excel may misinterpret them, due to different date systems, or date interpretation settings.

Warning: Although you can input the date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.


  A B C D
1 Data      
2 01-Apr-2014 Issue date    
3 15-Jun-2014 Maturity date    
4 10.0% Coupon rate    
5 $1,000 Par value    
6 3 Actual/365 Basis    
8 Formula Result Notes
9 =ACRINTM(A2,A3,A4,A5,A6) $20.55 The accrued interest for the above terms

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the issue or settlement arguments are not valid dates
#NUM! Occurs if:

  the rate argument is ≤ 0 or the [par] argument is ≤ 0
  the [basis] argument is not equal to 1, 2, 3 or 4
  the issue argument is ≥ the settlement argument
#NAME? Occurs when Analysis ToolPak add-in is not enabled