Excel Function : ACCRINTM
Category
Financial
Description
Returns the accrued interest for a security that pays interest at maturity
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ACCRINTM-function-f62f01f9-5754-4cc4-805b-0e70199328a7
Syntax and Description of the ACCRINTM Excel Function
. The syntax for ACCRINTM in Microsoft Excel is: ACCRINTM(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Arguments issue The security's issue date. The security issue date is the date on which the security is first offered for sale. first_interest The security's first interest date. The security's first interest date is the date on which the first interest payment is due. settlement The security's settlement date. The security settlement date is the date by which a buyer must pay for the security. rate The security's annual coupon rate
About ACCRINTM Excel Function
The ACCRINTM function returns the interest that has accumulated on a security that pays periodic interest, up to and including the maturity date. ACCRINTM(issue, first_interest, settlement, rate, par, frequency, basis, calc_method) issue - The security's issue date. The security's issue date. first_interest - The security's first interest date. The security's first interest date. settlement - The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. The security's settlement date. rate - The security's annual coupon rate. The security's annual coupon rate. par
