description:
Returns the accrued interest for a security that pays interest at maturity. |
syntax:
ACCRINTM( issue, settlement, rate, par, [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. |