ACCRINTM function

description:

Returns the accrued interest for a security that pays interest at maturity.

syntax:

ACCRINTM( issuesettlementratepar,  [basis] )

required arguments:

issue Security’s issue date.
settlement Security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. TheACCRINTfunction calculates the interest that would have been earned between the issue date and the settlement date.
rate Security’s annual coupon rate.
par Security’spar value. If you omit par, ACCRINTM uses $1,000.

optional arguments:

[basis] The type of day count basis to use. Use 0 for U.S. bonds.