Syntax. ACCRINTM(Issue,Settlement,Nominal_Interest,Par_Value,Basis)

Definition. The function ACCRINTM() calculates the accrued interest of a debt due in full intra-annually or the accrued interest of a fixed-interest security with one interest payment per year.


  • Issue (required) The date of the issue of the security.

  • Settlement (required) The date when the ownership of the security changes.

  • Nominal_Interest (required) The agreed-upon interest rate of the security based on one year.

  • Par_Value (optional) The nominal value of the security. If this argument is not specified, Excel calculates with 1000 monetary units (contrary to the information in Excel Help in Excel 2003 and earlier versions).

  • Basis (optional) Defines the method you ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.