EXCEL ACCRINTM FUNCTION

The Excel ACCRINTM function calculates the accumulated interest on a securities that pays interest at maturity.

Syntax : 

=ACCRINTM( issue_date, maturity_date, rate, par, [basis] )

Parameters : 

  • issue_date : The date on which the security was issued is referred to as the issue date.
  • maturity_date : The security’s maturity date
  • rate : The rate is the security’s yearly coupon rate.
  • par : A security’s par value. If this argument is not specified, the ACCRINTM function will presume that the par value is $1,000.
  • basis : Optional basis It is the day count to be used for computing interest on the security. If this option is left blank, the basis is assumed to be set to 0. It can be any of the following:
ValueExplanation
0US (NASD) 30/360
1Actual/Actual
2Actual/360
3Actual/365
4European 30/360

Step By Step Guide of ACCRINTM Function

Example :

=ACCRINTM(B1,B2,B3,B4,B5)
Result: 365.9589041

=ACCRINTM(DATE(2012,1,1),DATE(2013,2,15),0.065,5000,3)
Result: 365.9589041

ACCRINTM function Example

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now