This function calculates the accrued interest at maturity for a security that pays periodic interest.
Syntax
ACCRINTM(issue,maturity,rate,par,basis)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| issue | Date that the security is issued |
| maturity | Maturity date for security |
| rate | Annual interest rate for the security |
| par | [Optional] Par value for the security; if omitted, the calculation uses a value of $1,000 |
| basis | [Optional] Integer representing the basis for day count (Refer to Day Count Basis.) |
Remarks
This function requires that issue is a valid date (otherwise a #Value! error is returned). If the rate or par is less than or equal to 0, then a #NUM! error is returned. If the basis is less than 0 or greater than 4, a #NUM! error is returned. If the issue is less than the settlement, then a #NUM! error is returned.
Data Types
Accepts numeric and DateTime object data. Returns numeric data.
Examples
ACCRINTM(A2,A3,B4,D9,3)
ACCRINTM(R1C1,R2C3,R4C2,R9C4,3)
Version Available
This function is available in product version 1.0 or later.
See Also
ACCRINT | INTRATE | Financial Functions