O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACCRINTM()

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.

Arguments

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required